nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to connect on-premises EBS data source directly to oracle analytics cloud (OAC)?

User_D3AO2

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.

Find more posts tagged with

Analytics

EBS

Connection

Data Connectivity

Accepted answers

Viswanath-Oracle

All comments

GayathriAnand-Oracle

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

Steve F-2

In addition to the specific connection question, you may also want to review

https://www.oracle.com/news/announcement/ocw-comprehensive-integrated-data-analytics-empower-business-users-2022-10-18/

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.

Viswanath-Oracle

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.

Viswanath-Oracle