Marketo announced the availability of the new Microsoft Power BI connector for their products.
Their goal is that with the PowerBI connector for Marketo, companies can more easily combine marketing data with data sets from finance, customer service, operations and other functions to discover new insights and make more informed decisions across the business. The cloud-based business analytics service will be integrated with Marketo's marketing and customer data.
Have any thoughts about this new offering? Share with the community!
IT Leader at a tech services company with 1,001-5,000 employees
Consultant
Top 20
Mar 25, 2015
I have used Marketo as an independent Marketing software and integrating it with other downstream systems leveraging Enterprise Service Bus. It will be interesting to note how out of box MS Power BI Connector can speed up data flow across the system and reduce the challenges during after system goes in production.
The two are similar, it is cars but of different brands; I ask 1-) the users use Windows 2-) you have Office 365 3-) They will use Excel for the data. If you answer yes to the 3, better BI due to integration, and learning is easier for the user. If they are non-Microsoft databases, investigate on the provider's side, for example, SAP, IBM, etc. I have trained end users in Power BI. I know that Power BI has the majority of connectors. I hope my comment is helpful. Regards
Hi Ross,Good news! The BI Connector, a Power BI-certified connector is created exactly for this purpose!With BI Connector, it's possible to extract your Oracle Fusion data directly to Power BI. Please check it out below:https://www.biconnector.com/po...The connector works seamlessly with both Power BI Desktop and Service (or Report Server) and supports Import and Direct Query modes. It also ret...
Financial Systems Advisor - US Controller Group at McDonald's
Apr 19, 2023
Hi Ross,
Easy is a tricky description...We are going through this effort too. We are 'grappling' with the governance of this type of access as well as the technical journey. So you are not alone.
Fusion Middleware applications include a number of connectivity options including native client or Oracle Data Access Components (ODAC), with OLEDB, JDBC, etc., on top. Each has its own quirks. This is the 'plumbing' between the analytic tool and source.
Adding to that is the cloud and database level security of the data source.
A good way to start is to use Oracle's SQL Developer to connect to your data source. It gives developers a great query tool for Oracle and other databases. (https://www.oracle.com/databas...)
Once you understand what you can access, you can easily migrate that connectivity to Power BI.
Moreover, you will have validated queries that you can test directly or simply bring in the tables using the PBI Navigator.
Hi Ross,Good news! The BI Connector, a Power BI-certified connector is created exactly for this purpose!With BI Connector, it's possible to extract your Oracle Fusion data directly to Power BI. Please check it out below:https://www.biconnector.com/po...The connector works seamlessly with both Power BI Desktop and Service (or Report Server) and supports Import and Direct Query modes. It also retains the underlying table joins in the Oracle Fusion Cloud, so you don't have to recreate them from scratch in Power BI.Thanks,Dinesh
I have used Marketo as an independent Marketing software and integrating it with other downstream systems leveraging Enterprise Service Bus. It will be interesting to note how out of box MS Power BI Connector can speed up data flow across the system and reduce the challenges during after system goes in production.