plotly VS airbyte

Github: https://github.com/plotly/plotly.py

First we need to install the Plotly. To create some very dynamic graphics, this tool helps a lot.

my good dude wake up and smell the plotly. Knowing the ins and outs of matplotlib is helpful but doing interactive stuff with jupyter I always use plotly.

Plotly documentation (https://plotly.com/python/)

I don´t know your workflow, but I use 2 markdown based presentations: obsidian advance slides and Quarto presentations. The former is a plugin for Obsidian, which is the software I use to take all my notes, write my thesis, etc., so It makes it extremely easy to make presentations since all my information is in Obsidian. In the other hand, Quarto is a publishing system (articles, presentations, websites books) that can be easily integrated with python and R. This makes it supper convenient for showing my data to my PI since I can analyze my data and at the same time make a presentation for the data. Besides this, Quarto also integrates with my Zotero library, so I can insert citations. Lastly, one thing that made my Quarto presentations infinitely better that the powerpoints, Is that I can insert interactive graphs with plotly, so when I'm showing my data, my PI is able to explore the data inside the presentation.

Plotly GitHub repository: https://github.com/plotly/plotly.py

I'm using plotly.py now. This is why I love this community.

Depending on the nature of your reporting requirements, you could output a formatted Excel document with Python and a library such as openpyxl, and shove that into your SharePoint environment. This would be less dynamic than PBI reports can be, but may be sufficient. If you want viz as well, you can use something like ggplot or Plotly. Again, less dynamic than PBI for the same effort.

I'l also give a shout-out to Airbyte (https://airbyte.com/), with which I've had some limited success with integrating Salesforce to a local database. The particular pull for Airbyte is that we can self-host the open source version, rather than pay Fivetran a significant sum to do this for us.

It's an immature tool, so I don't yet know that I can claim we've spent _less_ than Fivetran on the additional engineering and ops time, but it feels like it has potential to do so once stabilized.

Link to GitHub -->

When it says "available in open source", is that under the main airbyte repo's licensing [1], hence primarily licensed under the Elastic License v2 and therefore not typically considered open source by many?

Airbyte has previous of advertising their offering as open source while not really being as per the OSD[2]. This has been raised with them previously but without response [3][4]. They've also been extending their use of ELv2, recently moving many of their existing MIT licensed connectors to be ELv2 [5].

[1] https://github.com/airbytehq/airbyte/blob/master/LICENSE

As possible solution, I can suggest Airbyte(https://airbyte.com/). it's more performant than generic python script.

Airbyte, an open-source data integration engine that offers hundreds of connectors with data warehouses and databases, has gained popularity for its seamless integration and data syncing capabilities. Xata's integration with Airbyte offers a streamlined data ingestion process from any Airbyte input source directly into your Xata database.

You can try and contribute some new connectors/operators for workflow managers like Airflow or Airbyte