Skip to content

3_OracleHDI.md

Latest commit

 

History

History
92 lines (67 loc) · 6.04 KB

3_OracleHDI.md

File metadata and controls

92 lines (67 loc) · 6.04 KB

Connecting Microsoft Fabric to Oracle HDI

Costa Rica

GitHub brown9804

Last updated: 2025-07-17

Oracle Health Data Intelligence (HDI), formerly known as HealtheIntent, is a modular suite of cloud applications, services, and analytics. It enables healthcare and government stakeholders to use data from across the healthcare ecosystem to advance patient health, improve care delivery, and drive operational efficiency.

Wiki

Prerequisites:

  1. Register and Set Up API Access
    • Register Your Application: Go to the Oracle Health Developer Program console and register your application. Review and accept the API Access Terms and Conditions.
    • Review API Documentation: Familiarize yourself with the Oracle Health API documentation, including available FHIR API resources.
  2. Install Necessary Tools
    • Oracle Client: Ensure the Oracle Client is installed on the machine running the on-premises data gateway.
    • Microsoft Fabric: Set up Microsoft Fabric and ensure you have the necessary permissions to create and manage data pipelines.

How to

Set Up Data Gateway: If your Oracle database is on-premises, configure the on-premises data gateway to facilitate the connection.

  1. Setup the Data Pipeline in Microsoft Fabric

    • Open Data Factory: Navigate to Microsoft Fabric's Data Factory.

      image

    • Create a Pipeline: In Data Factory, create a new pipeline to manage the data flow from Oracle HDI to your desired destination.

      image

    • Add Copy Activity: Add a copy activity to the pipeline.

      • In the Source tab of the Copy Data activity, select the Oracle linked service you created.
      • Specify the table or query to extract data from Oracle HDI.
      image image image
      • Configure Connection:
        • Server Name: Enter the Oracle server name.
        • Database Name: Enter the name of your Oracle HDI database.
        • Authentication: Choose the appropriate authentication method (e.g., Basic).
        • Username and Password: Enter your Oracle database credentials.
        • Test Connection: Click on Test Connection to ensure the details are correct.

  2. Configure Data Compression

    • In the Destination tab, choose the destination data store (e.g., Azure Blob Storage, SQL Database).
    • Select Compression Type: In the copy activity settings, choose the desired compression type (LZ4 or GZIP) for the data transfer.
    • Destination Configuration: Configure the destination settings to store the compressed data in your preferred format. Specify the file format and path where the compressed data will be stored.
    image image
    • Ensure the destination supports the chosen compression format.

Possible Issues and Solutions

  1. Connection Issues
    • Issue: Unable to connect to the Oracle database.
    • Solution: Verify the connection details, ensure the Oracle Client is correctly installed, and check network connectivity. Ensure the on-premises data gateway is properly configured and running.
  2. Authentication Problems
    • Issue: Authentication failures when connecting to the Oracle API.
    • Solution: Double-check the credentials and authentication method used. Ensure that the API key or token is valid and has the necessary permissions.
  3. Data Transfer Errors
    • Issue: Errors during data transfer.
    • Solution: Check the data pipeline logs for specific error messages. Ensure that the data format and schema are compatible between the source and destination. Adjust the query or data mapping as needed.
  4. Compression Issues
    • Issue: Data not being compressed as expected.
    • Solution: Verify the compression settings in the copy activity. Ensure that the destination supports the specified compression format (LZ4 or GZIP).
Total views

Refresh Date: 2025-07-18