Microsoft Fabric

You can connect Microsoft Fabric to CData Connect Cloud with the CData Connect Cloud plugin.

Prerequisites

Before you connect, you must first connect a data source to your CData Connect Cloud account. See Connections for more information.

To establish a connection from Microsoft Fabric to CData Connect Cloud, follow these steps.

Log in to Microsoft Fabric.
In Microsoft Fabric, select a workspace in which to create the flow, or create a new workspace.
Click New item and then click Dataflow Gen2.
Once inside the data flow, click Get Data. Enter CData Connect Cloud in the search bar and select the CData Connect Cloud plugin.
In the Get data dialog, enter the following credentials:
- Connection—select Create new connection.
- Connection name—create a user-defined connection name.
- Data gateway—select (none).
- Authentication kind—select CData Connect account.
Click Sign in. You are redirected to our authentication page via OAuth, establishing a connection to CData Connect Cloud.
Click Next. All your connections, derived views, and workspaces are now visible.
Select a table in your connection/schema hierarchy to load the desired table.
Click Create to launch the Power Query page.
To replicate your data to a destination, click + next to Data destination. A Connect to data destination dialog appears. In this example, we used SQL Server as a destination. Enter the destination settings and click Next.
Select a destination target. You can overwrite an existing table or create a new destination table. Click Next.
Map the data types for your destinations. Click Save settings.
When you run/refresh the data flow, your table is copied to the selected destination. You can also modify the content in the Power Query editor.