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 August 7, 2022 at 12:56 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support August 8, 2022 at 5:47 pm  

      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 August 10, 2022 at 5:02 am  

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

    • Support August 11, 2022 at 4:00 am  

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: