Easily and seamlessly pull data and hierarchies from Oracle sources directly into your Databricks platform.
ExoInsight enables connectivity Oracle Fusion Cloud ERP and Oracle EPM sources directly to Databricks, giving you the ability to access and process your Oracle Essbase, PBCS, FCCS, PCMCS, Tax Reporting, Cloud Freeform, FIN, HCM, PRC, PPM, SCM, and CRM data and hierarchies.
With the connectivity for Databricks provided by ExoInsight, you no longer need to create complicated extract processes from the source system to land the data somewhere you can access. There are no extract or report objects to create or maintain within any Oracle source system.
Simply execute the ExoInsight process to pull data and hierarchies from your Oracle source system and ExoInsight will take care of the rest: extract the data, create the tables, load the data, and kick off any Databricks process you like.
Easily pull and combine data from different cubes into a singular dataset for downstream processes. Merge your forecast from your people planning cube with actuals from your P&L cube to see how a reorganization is going to impact EBITDA. Pull key drivers from your statistics cube to seed your budget. Pull journal lines from the Financials module and reconcile them with the consolidated values in HFM or Essbase.
The possibilities Databricks and ExoInsight provide for your data are endless.
Pulling your metadata and hierarchies out of your EPM data sources has never been easier. Want to see what your relational data would look like against an existing hierarchy? Simply pull your hierarchy from your source and join it with your data in Databricks to start analyzing your data as you’ve never been able to before.
ExoInsight’s innovative POV String query language makes it easy for anyone to specify the data required from their Oracle applications.
Whether you’re a seasoned Oracle Fusion Cloud ERP or Oracle EPM pro or have never logged in at all, you’ll have no problem getting the data you need. ExoInsight provides the absolutely easiest way to pull data from Oracle sources into Databricks.