Set Up a Microsoft Fabric Connection

Set up the Microsoft Fabric connection to start the flow of data into Data 360.

User Permissions Needed
To create a connection:System Admin profile or Data Cloud Architect permission set

Before you begin:

  • Verify your admin has enabled firewalls on the system you want Data 360 to connect to by including these IP addresses to your allowlists.

  1. In Data Cloud, click Setup, and select Data Cloud Setup.

  2. Under External Integrations, select Other Connectors.

  3. Click New.

  4. On the Source tab, select Microsoft Fabric and click Next.

  5. Enter a connection name, connection API name, and provide the authentication and connection details.

  6. For Username and Password, enter the Microsoft Entra (formerly Active Directory) credentials authorized to access the Microsoft Fabric workspace and SQL endpoint.

  7. For Connection URL, enter the Microsoft Fabric SQL endpoint URL for the warehouse or lakehouse you want to connect to.

    The MS Fabric SQL endpoint follows this format: {workspace-name}.datawarehouse.fabric.microsoft.com

    The MS Fabric Lakehouse SQL endpoint follows this format: {workspace-name}.lakehouse.fabric.microsoft.com

  8. For Schema, enter the schema name within the warehouse or lakehouse.

  9. For Database, enter the warehouse or lakehouse name that contains the schema.

  10. To review your configuration, click Test Connection.

  11. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.