OAC CONNECTOR OPTIONS FOR EBS

image

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

Vast Edge has been empowering businesses since 2004 with tailored cloud solutions that go beyond regular IT management. As a Cloud Solution Provider (CSP), we specialize in delivering fully managed services that combine implementation, integration, and ongoing support - positioning us as your trusted IT partner, not just a vendor.
Our Offerings:
- Azure, GCP, AWS, OCI Cloud Services: Security, DevOps, Data Analytics, Warehousing, AI/ML, and Seamless Integrations
- ERP Migration & Implementation: Expertise across Dynamics, SAP, Sage, Oracle EBS, JDE, & NetSuite
We deliver complete solutions. Our CSP model is built around value-added services, ensuring customers receive expert implementation, optimization, and support alongside their Cloud investments.
Read more about us

QUICK LINKS

TECHNOLOGY PARTNERS

CONTACT US

Copyrights © July 17 , 2025 All Rights Reserved by Vast Edge Inc.