Configure Source Connection

Configure the connection to your source database: the Synapse Dedicated SQL Pool

Within Omni Loader, data can be read in two separate modes.

Polybase: recommended for large databases. Polybase leverages Synapse's parallelism, allowing all nodes to export data simultaneously in Parquet format, making it significantly faster than SQL Select.

SQL Select: provides better progress tracking, reliability, and error handing. However, it's slower for large datasets.

Begin configuration of the source database

Select source database from the drop-down menu.

The Source Connection interface appears.

Enter the following information:

• Server name

• Database name: select from the menu.

• Authentication: there are several methods, such as SQL Auth, Managed Identity, or Service Principal (preferred).

• Choose connection method:

  • Polybase

  • SQL Select