Oracle provides two ways to connect enterprise business suite (EBS) on-premise ERP to Oracle analytics cloud; though direct ODBC connection and by using remote data connectors. Both options work fine to connect the two platforms and have their own pros and cons. the ODBC connection is easier to establish and pull the data, however, this option exposes the entire dataset posing higher security risks. On the other hand, the RDC option connects to the on-prem WebLogic server that connects to the database to offer added security and data caching. The RDC option enables you to directly visualize EBS data using OAC DV.
The 3 steps required to implement this are 1) setup the public and private keys, 2) setup firewall to open the connection to OAC, 3) copy the RDC war file to on-premise EBS Weblogic server, and 4) setup OAC connection pool using OAC client desktop tool to connect to the EBS HTTP web server.
Remember to download the RDC war file for your app server (Oracle Weblogic or Apache tomcat). Make sure to configure your RDC App to point to the EBS data source using JDBC connector.
About Vast Edge - Simplified Cloud Solutions
Founded in the year 2004, Vast Edge is a leading IT Consulting Company and Global Service provider of Business Intelligence, big data analytics, cloud ERP, IoT platform, enterprise backup, and disaster recovery, Blockchain, Cassandra, AI/ML, and Integration solutions. We perform Application modernization, follow continuous change management, and implement advanced practices while working on the key areas of enhancing methodologies of project development.
Get a Free Assessment from our experts to integrate Okta SSO smoothly into your system.