For years, ExoInsight has enabled companies all over the world to integrate their Oracle Fusion Cloud ERP data with downstream systems such as Alteryx, Snowflake, Tableau, Power BI, and many others. The two primary methods of pulling data, the ExoInsight POV String and BI Publisher Report integration, have been the foundational methods to pull data out of Oracle Cloud Financials, HR, Procurement, or any other Fusion Cloud ERP module. The ExoInsight POV String provides a guided, self-service, ad-hoc method of pulling data, and the BI Publisher Report integration adds the ability to pull data from existing reports.

Today, we’re excited to announce a third way. ExoInsight now allows you to write custom SQL against any underlying table and directly integrate those results with any downstream system. This opens up an entirely new frontier in data access for Oracle Fusion Cloud ERP and covers 100% of all data use-cases.

Imagine being able to write a custom SQL statement, including any transformations or access to fields not exposed directly by the API, and having those results directly integrated with any downstream system for reporting, analysis, reconciliations, or other use-cases.

Maybe you’re an Alteryx user and you want to pull invoice details in a specific format, automatically combining the segments to form the COA string and pulling the data directly into your workflow:

Or maybe you want to set up an automated process to move your cash flow data directly into your Snowflake environment:

The possibilities are endless, just like the SQL you could write. ExoInsight makes data movement easy to any tool across your organization.

For those worried about moving from EBS to Fusion Cloud ERP because of the loss of control over the data you can easily access, ExoInsight will put the control back in your hands. And the best part is that all the security and restrictions you have set up in your Oracle Fusion Cloud ERP environment applies with ExoInsight too. Oracle will be the only place you set up and manage access to your data, so you’re still in full control.

Please reach out to us if you’d like more information or a demo of ExoInsight. We’d love to show you how easily ExoInsight can solve your most pressing Oracle data integration challenges!