10.4.4 Microsoft Fabric Lakehouse

• About Microsoft Fabric Lakehouse Connections
  
• Before You Begin
  
• Create and Validate a Microsoft Fabric Lakehouse Connection
  
• Use a Microsoft Fabric Lakehouse Connection in Replicat
  

10.4.4.1 About Microsoft Fabric Lakehouse Connections

A Microsoft Fabric Lakehouse connection stores the information that Oracle GoldenGate for Distributed Applications and Analytics uses to connect to a Microsoft Fabric Lakehouse.

You can use the connection with Replicat to deliver transactional data to Microsoft Fabric Lakehouse. After you create and validate the connection, you can reuse it across multiple Oracle GoldenGate for Distributed Applications and Analytics processes.

The connection stores the Microsoft Fabric endpoint information, authentication settings, and optional runtime settings independently of the process configuration.

10.4.4.2 Before You Begin

10.4.4.3 Create and Validate a Microsoft Fabric Lakehouse Connection

Use the Add Connection page to create a Microsoft Fabric Lakehouse connection.

Procedure

1. In the navigation menu, select DB Connections.
2. Click Add Connection.
3. In Connection Alias, enter a unique name for the connection.
4. From Technology Type, select Microsoft Fabric Lakehouse.
5. In the Technology Settings section, provide the Microsoft Fabric Lakehouse connection information.

   Configure the following technology settings:

   • Connection URL – Specifies the JDBC connection URL for the Microsoft Fabric Lakehouse SQL Warehouse or workspace. This field is required.
   • Authentication Type – Specifies the authentication method. Supported values are Personal Access Token and OAuth M2M.
   • Storage Credential Name – Specifies the Microsoft Fabric Lakehouse storage credential used by the deployment, when required.
6. Configure the authentication settings based on the selected authentication type.
7. Configure the following settings when Authentication Type is Personal Access Token:
   • Username – Specifies the Microsoft Fabric Lakehouse user name associated with the personal access token. This field is required.
   • Password – Specifies the Microsoft Fabric Lakehouse personal access token. This field is treated as sensitive information and is displayed as a password field.
8. Configure the following settings when Authentication Type is OAuth M2M:
   • Client ID – Specifies the OAuth client ID registered with Microsoft Fabric Lakehouse. This field is required.
   • Client Secret – Specifies the OAuth client secret associated with the client ID. This field is treated as sensitive information and is displayed as a password field.
9. Configure Common Settings, if additional runtime configuration is required.

   Classpath: (Required) Specify the full path to client libraries are required by the replicat type. You can use Dependency Downloader to download client libraries.

   Note:

   Download the supported Microsoft Fabric Lakehouse JDBC driver and required client libraries by using the Dependency Downloader for Microsoft Fabric Lakehouse. Configure the runtime classpath to reference the downloaded libraries before starting the Replicat process.
10. (Optional) Configure Proxy Settings if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses Microsoft Fabric Lakehouse through an HTTP proxy.

    Configure the following proxy settings:

    • Proxy URL – Specifies the URL or host name of the proxy server used to access Microsoft Fabric Lakehouse.
    • Proxy Port – Specifies the port number of the proxy server.
    • Proxy Username – Specifies the user name for proxy authentication, if required.
    • Proxy Password – Specifies the password for proxy authentication. This field is treated as sensitive information.
    • Truststore – Specifies the Java truststore file that contains the certificate authority (CA) certificates used to validate the proxy server certificate, when required.
    • Truststore Password – Specifies the password associated with the truststore.
    • Keystore – Specifies the Java keystore file containing the client certificate and private key used for client authentication, when required.
    • Keystore Password – Specifies the password associated with the keystore.
    • SSL Key Password – Specifies the password protecting the private key stored in the keystore when it differs from the keystore password.

    Note:

    If the Oracle GoldenGate for Distributed Applications and Analytics deployment has direct network connectivity to Microsoft Fabric Lakehouse, leave the proxy settings blank.
11. Click Submit.
12. On the DB Connections page, click DB Login to validate the connection.

Note:

A successful DB Login validates only the saved connection information. It does not validate the Replicat configuration or Microsoft Fabric Lakehouse Handler configuration. After successful validation, the connection is available for selection during Replicat creation.

10.4.4.4 Use a Microsoft Fabric Lakehouse Connection in Replicat

After the Microsoft Fabric Lakehouse connection has been successfully validated:

1. Create or edit a Replicat.
2. Select Microsoft Fabric Lakehouse as the target technology.
3. Select the validated Microsoft Fabric Lakehouse connection.
4. Complete the remaining Replicat configuration.
5. Create and start the Replicat.

The selected connection provides the authentication and endpoint information required during Replicat execution.