Integration with the Oracle Autonomous Database

Cloud EPM customers can now connect directly to the Oracle Autonomous Database to extract data from it and load the data to the Cloud EPM, eliminating the need to use the agent for this type of connection.. This type of integration enables you to extract source data from staging or other applications running on the Oracle Autonomous Database.

Additionally, customers can also use the external table function in the Oracle Autonomous to define a table where the source data is from a file in Object Storage and then extract data from it.

Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Profitability and Cost Management, Tax Reporting

Business Benefit: Cloud EPM customers now have a set of easy-to-use, no-code tools to load data stored in the Oracle Autonomous Database. Prior to this update, in order to extract data from the Oracle Autonomous Database, Cloud EPM customers had to install the EPM Integration Agent and add on a compute instance.

Tips and considerations

Write back to the Oracle Autonomous Database Data is not supported in this update. Drill through is supported.

Key resources