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 June 2, 2022 at 3:57 am

Our Oracle EBS instance needs to integrate key master data from a separate, external Vertica database for comprehensive reporting. How can Blitz Report facilitate accessing and reporting on this external, non-Oracle data source?

Viewing 8 reply threads
  • Author
    Replies
    • Support June 2, 2022 at 10:53 am  

      Blitz Report fully supports accessing external data sources. To achieve integration with non-Oracle platforms like Vertica, MySQL, or even DB2, the technical foundation must be built first using standard Oracle database functionality: the Database Link.

    • Avatar photoCustomer June 2, 2022 at 8:50 pm  

      What Oracle components are required to establish the Database Link connectivity layer for a non-Oracle source like Vertica?

    • Support June 4, 2022 at 1:01 pm  

      The Database Link must rely on underlying infrastructure such as Oracle Heterogeneous Services or the Oracle Database Gateway, which often utilize ODBC connectivity to communicate with the external database system. Once this gateway layer is configured in your Oracle EBS reporting instance, the database link can be created.

    • Avatar photoCustomer June 6, 2022 at 6:37 am  

      Once the database link is created, how complex is the SQL needed within Blitz Report to pull consolidated EBS and Vertica data?

    • Support June 6, 2022 at 10:42 am  

      The SQL complexity remains standard. Within your Blitz Report query, you simply reference the external table using the standard database link syntax (e.g., `@DBLINK_NAME`). Blitz Report then executes this integrated query seamlessly, drawing data from both the EBS database and the external Vertica source.

    • Avatar photoCustomer June 7, 2022 at 1:07 pm  

      We are specifically running EBS 12.2. Is this cross-database reporting approach compatible with our version?

    • Support June 8, 2022 at 5:00 pm  

      Yes, this functionality is fully compatible with EBS 12.2, as demonstrated in our resources covering connecting to external databases. Blitz Report gives you the flexibility to retrieve data from any database system, provided the necessary Oracle database link setup is in place.

    • Avatar photoCustomer June 10, 2022 at 4:06 am  

      Finally, since this involves custom SQL linking to external systems, can we ensure the output data is easily consumable by business users?

    • Support June 10, 2022 at 4:31 pm  

      Certainly. Regardless of the complexity of the integrated query, Blitz Report delivers the consolidated data immediately as a native, formatted Excel file, which can then be easily utilized by business users or imported into tools like Tableau or Microsoft Power BI.

  • Author
    Replies
Viewing 8 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123993

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 20561

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14854

How to check if a patch is applied in Oracle EBS 12.2 14616

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14265

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12114

Migration to Java Web Start in Oracle EBS 12.2 instance 10115

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 10072

Securing sensitive data with Oracle VPD 8062

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6639

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2027
2036
2025
2024
2023
2022
2021
2020
2019
2018