Create a Microsoft OneLake connection

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • Establish a zero copy connection to a Microsoft OneLake system in Workflow Data Fabric Hub.

    Before you begin

    Role required: df_connection_admin

    About this task

    Work with your data source admin to create a connection to Microsoft OneLake. For additional information about connecting to Microsoft OneLake, refer to the Microsoft OneLake documentation.

    Procedure

    1. Navigate to the available primary connectors in Workflow Data Fabric Hub in one of the following ways:
      • Navigate to All > Workflow Data Fabric Hub > Available connectors > Primary connectors.
      • Navigate to Admin > Workflow Data Fabric Hub > Available connectors > Primary connectors.
    2. Find the Microsoft OneLake connector and select Connect.
    3. On the form, fill in the fields.
      Table 1. New Microsoft OneLake Connection form
      Field Description
      Name and description
      Connection label Unique name for this connection. This helps in identifying the connection within your system.
      Connection name System-generated name based on the Connection label. This field cannot be modified once the connection is established.
      Short description Description of the connection explaining what it is about.
      Connection attributes
      Connection URL JDBC URL to establish the connection. For example:

      jdbc:microsoftonelake://<host>:<port>;database=<databaseName>
      Authentication methods
      Authentication method Authentication method to use with Microsoft OneLake. Default is Basic Authentication.
      Database username Username associated with the database.
      Database password Password associated with the username.
    4. Select Connect.

    Result

    A test connection is made to the external data source, verifying that the connection details are correct and the data source is accessible.

    What to do next

    If the connection succeeds, configure data steward access on the Access Control tab. See Manage access to an established connection using roles.

    If the connection fails, verify the connection details with your data source administrator and try again.