Home › Discussions › Questions & Answers › Connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databases

Connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databases

Avatar photoCustomer Questions & Answers 3 replies

We have critical operational data stored in a Vertica database that needs to be consolidated into our Oracle EBS reports. How does Blitz Report support accessing external data sources, especially non-Oracle platforms like Vertica or MySQL?

3 replies

  • Support Enginatics

    Blitz Report explicitly supports accessing external data sources. To integrate data from non-Oracle databases such as Vertica or MySQL, you leverage standard Oracle database capabilities like Database Links. These links rely on underlying infrastructure like Oracle Heterogeneous Services or Oracle Database Gateway to establish connectivity.

  • Avatar photoCustomer

    So, the core technical setup must be completed at the database layer using Oracle’s native tools first?

  • Support Enginatics

    That is correct. Once the database link infrastructure (Heterogeneous Services) is configured within the Oracle database, Blitz Report can use standard SQL queries, incorporating the database link syntax (e.g., `@DBLINK_NAME`), to seamlessly integrate the data from the external source directly into your EBS report output. Blitz Report then provides the fast Excel output interface over this consolidated dataset.

  • You must be logged in to reply to this post.