Home › Discussions › Questions & Answers › Accessing External Data Sources with Blitz Report™

Accessing External Data Sources with Blitz Report™

Avatar photoCustomer August 9, 2021 at 9:05 am

Our Supply Chain Planning module requires metrics derived partly from EBS data and partly from external databases, specifically a MySQL data warehouse and a Vertica analytics instance. Can Blitz Report facilitate direct reporting across these disparate data sources?

Viewing 6 reply threads
  • Author
    Replies
    • Support August 9, 2021 at 4:49 pm  

      Yes, Blitz Report fully supports accessing external data sources. Specifically, it allows you to connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databases.

    • Avatar photoCustomer August 11, 2021 at 4:50 am  

      What is the underlying technical requirement to make the connection between EBS (Oracle DB) and non-Oracle sources like MySQL? Are database links sufficient?

    • Support August 11, 2021 at 6:49 pm  

      To connect the Oracle E-Business Suite database to non-Oracle sources, you generally rely on Oracle Heterogeneous Services or Oracle Database Gateways. This involves configuring a database link that utilizes an ODBC connection to bridge the gap between the Oracle instance and the external database, such as Vertica or MySQL.

    • Avatar photoCustomer August 12, 2021 at 6:12 pm  

      If we set up these database links, how does Blitz Report utilize them? Is there a special syntax required in the SQL query?

    • Support August 13, 2021 at 11:57 pm  

      Once the necessary database links are configured, Blitz Report treats the external data sources as extensions of the standard EBS database. You simply write standard SQL queries within Blitz Report that reference the linked tables using the database link syntax (e.g., `@`), allowing you to seamlessly join EBS transactional data with external analytical data.

    • Avatar photoCustomer August 15, 2021 at 4:23 am  

      We require output in Excel for analysis, potentially including pivot tables. Can Blitz Report handle the data volume and formatting for combined reporting from these sources?

    • Support August 16, 2021 at 4:49 pm  

      Absolutely. Blitz Report is optimized for exporting mass data quickly and generates formatted, native Excel files, overcoming the data limitations and formatting issues often seen with simple CSV exports. This is also critical for financial analysis with pivot tables, ensuring the data structure is clean and reliable upon export.

  • Author
    Replies
Viewing 6 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™ 123992

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14853

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 14264

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12113

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 10071

Securing sensitive data with Oracle VPD 8061

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

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