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 9 replies

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?

9 replies

  • Support Enginatics

    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

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

  • Support Enginatics

    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

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

  • Support Enginatics

    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

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

  • Support Enginatics

    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

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

  • Support Enginatics

    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.

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