Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
How to connect on-premises EBS data source directly to oracle analytics cloud (OAC)?

Hi
Allan Gomes here. I have never used Oracle Analytics Cloud (OAC) before.
Can anyone please tell me how to connect on-premises EBS data source directly to oracle analytics cloud (OAC)?
How will the data be directly integrated into the Oracle Analytics Cloud (OAC) from an on-premises EBS data source?
Could someone kindly explain to me how to link straight from an on-premises EBS data source to Oracle Analytics Cloud (OAC)?
How will the OAC hierarchy be reflected? What would I do if I desired the parent-child hierarchy?
Please provide a relevant link, PDF, video, or sample if at all feasible.
Best Answer
-
0
Answers
-
Hi
If your EBS database is on-premise you would have to setup Private Access Channel OR Remote Data Gateway for OAC to connect to the EBS datasource. Please find documentation here :https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/overview-connecting-premises-data-sources.html#GUID-E229598F-D5D1-482A-88E6-5B66507AED6A
There is no out-of-box integration between OAC and EBS, so whatever customization you would need has to be created by you (RPD init blocks, reports, etc.).
Thanks
Gayathri
0 -
In addition to the specific connection question, you may also want to review
- Oracle E-Business Suite Accelerator is a pre-built cloud analytics solution that includes more than 80 pre-built dashboards with over 300 KPIs and reports, and respective data models, so anyone can quickly gain insights on their Oracle E-Business Suite data and extend it with cloud or on-premises sources. By combining Oracle Data Integrator, Oracle Autonomous Database, and Oracle Analytics Cloud, organizations can enhance the analysis of financial and supply chain data with a hybrid cloud and on-premises solution.
2 -
How will the OAC hierarchy be reflected? What would I do if I desired the parent-child hierarchy? - Advised to user Admin tool to design your rpd for custom heirarchy and upload it from console rather than using pre-built model from console.
1