Home › Discussions › Questions & Answers › Consolidated Reporting: Accessing External Non-Oracle Data Sources with Blitz Report via DB Link

Consolidated Reporting: Accessing External Non-Oracle Data Sources with Blitz Report via DB Link

Avatar photoCustomer Questions & Answers 6 replies

Our Oracle EBS runs in a heterogeneous environment where critical operational data resides in non-Oracle databases like MySQL and Vertica. We urgently require consolidated reporting capabilities that merge this external data with our core EBS information. Can Blitz Report facilitate accessing these external data sources, and what underlying database technologies are necessary to achieve seamless cross-platform reporting within EBS?

6 replies

  • Support Enginatics

    Yes, Blitz Report fully supports retrieving data from external databases, including PostgreSQL, MySQL, and Vertica. This capability relies on setting up an Oracle Database Gateway and utilizing Heterogeneous Services to create a predefined connection called a Database Link within your EBS database.

  • Avatar photoCustomer

    Once the database link is configured by our DBA team, how does a developer incorporate that external data into a Blitz Report SQL query?

  • Support Enginatics

    Accessing remote data within a Blitz Report SQL query is straightforward; you simply use the ‘object@databaselink’ notation. For instance, to query a supplier table on a remote database, you would use `select from supplier_info@your_remote_db`.

  • Avatar photoCustomer

    We are concerned about performance when joining local EBS tables with remote tables over the database link. Are there optimization strategies recommended?

  • Support Enginatics

    Performance optimization is critical when mixing local and remote queries. A key strategy is employing the DRIVING_SITE hint within your Blitz Report SQL statement. This helps the execution planner decide where the bulk of the processing should occur, ideally pushing large operations to the remote site to minimize data round trips.

  • Support Enginatics

    Using Blitz Report allows you to leverage this connectivity for centralized EBS reporting, providing a single repository for outputs from multiple database platforms.

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