Azure Synapse

Owned by Juliane Wetzel
Nov 23, 2020

INFO

Azure Synapse is an analytics service that brings together enterprise data warehousing and Big Data analytics.

Prerequisites

Preparing the Azure Synapse Instance

INFO

Set up your Azure Synapse instance accordingly.

Uploading the Database Driver

INFO

Set up the database driver in the 'Admin' tab.

Configuring Azure Synapse as a Connection

To configure Azure Synapse as a connector:

  1. Click the "+" button and select "Connection" or right-click in the File Browser and select "Create New" → "Connection". The "New Connection" tab appears in the menu bar.
     or 
  2. Select "Azure Synapse" from the drop-down and confirm with "Next". The type is displayed in the drop-down.
     
  3. Enter the connection string from the database driver. 
  4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Safe Connection' tab opens.
     
  5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.
     
  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring Azure Synapse  is finished.

Importing Data with an Azure Synapse Connector

INFO

Find how to import from Azure Synapse here.

Exporting Data with an Azure Synapse Connector

INFO

Find how to export to Azure Synapse here.