Integrations → Fabric with Advanced SQLi

Microsoft Fabric is an end-to-end, unified analytics platform that brings together various data tools and services, such as data integration, data engineering, data warehousing, data science, real-time analytics, and business intelligence (including Power BI), into a single SaaS (Software as a Service) environment.
Starting with Incorta 2024.7.5, you can seamlessly connect Microsoft Fabric to Incorta via Advanced SQLi using Dataflow Gen2 and the Spark connector.

Connect Fabric to Incorta via Spark connector

1. In your Microsoft Fabric workspace, select New item.

2. On the New Item page, select Dataflow Gen2.

3. Enter a name for your dataflow, and then select Create.

4. On the dataflow page, select Get data from another source.

5. On the Choose data source page, select Spark.

6. On the Connect to data source page, under Connection settings, enter the following:

   • In Server, enter the Incorta URL in one of the following formats:

     • For Incorta Cloud: https://<ClusterName>-sqlx.spark-cloud.incorta.com:443/<httpPath>

       Note

       You can get the HTTP Path from the Advanced SQL Interface Connection String, available when you turn on the Enable Advanced SQL Interface option in the Cloud Admin Portal > Clusters > <CLUSTER_NAME> > Configurations.

       Example:

       • If the Advanced SQL Interface Connection String is: jdbc:hive2://MyCluster-sqlx.spark-cloud.incorta.com:443/;transportMode=http;httpPath=gc-us-central1-a-13/cliservice;ssl=true
       • The Server URL will be: https://MyCluster-sqlx.spark-cloud.incorta.com:443/gc-us-central1-a-13/cliservice

     • For On-Premises: <PublicIP>:<KyuubiPort>
       Example: 203.0.113.45:10009

       Note

       You can use one of the following Kyuubi ports: kyuubi.frontend.thrift.http.bind.port or kyuubi.frontend.thrift.binary.bind.port

   • In Protocol, select HTTP to connect to Incorta Cloud, or Standard to connect to an Incorta On-Premises cluster.

   • Select OK.

7. Under Connection credentials, enter the following:

   • In Authentication kind, select Username / Password
   • In Username, enter the Incorta username in the following format: <IncortaUser>%<tenantName>. Example: admin%default.
   • In Password, enter a valid personal access token (PAT).

8. Select Next. Schemas, tables, and views available to Advanced SQLi are listed.

9. Select a table or view and wait till data is loaded, then select Create.

10. Select Publish now to start extracting data.