Skip to main content

Azure Synapse

Azure Synapse is a cloud-based analytics service that brings together big data and data warehousing. It enables querying and analyzing large volumes of structured and unstructured data using serverless or dedicated resources. Synapse integrates with Power BI, Azure Data Lake, and other data services for end-to-end analytics.

Prerequisites​

Before connecting, ensure the following prerequisites are met:

  • The Azure Synapse server must be accessible from iceDQ server.
  • Valid credentials to access the database.
  • Azure Synapse JDBC version 8.4 or above.

Authentication Mechanism​

The following authentication mechanism is supported.

  • SQL Server

Connection Properties​

SQL Server Authentication​

Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *         A unique name that identifies the connection.Prod_sales_data
Driver *Driver used to establish the connection. By default, one driver is available.Azure Synapse Native JDBC
Custom JDBC URLStandardized string used to define the connection details. Use this format supported by the driver: jdbc:sqlserver://[host]:[port];databaseName=[database]jdbc:sqlserver://acme-synapse-server.sql.azuresynapse.net:1433;databaseName=SalesAnalyticsDB
Host *The endpoint (hostname) of the Azure Synapse instance.acme-synapse-server.sql.azuresynapse.net
Port *Port on which the SQL Server listens. Default is 1433.1433
Database *Target database name.SalesAnalyticsDB
Type *Connection type – System Connection or User Connection. Refer Connections for more details.System or User
Username *Azure Synapse login username.john_doe
Password *Password for the specified username.Admin@123

Custom Properties​

Custom properties are optional connection parameters in the Azure Synapse driver, allowing customization of settings like timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the version of the Azure Synapse JDBC driver in use.

Supported Datatypes​

The following datatypes are supported.

  • BIGINT
  • BINARY
  • BIT
  • CHAR
  • DATE
  • DATETIME
  • DATETIME2
  • DATETIMEOFFSET
  • DECIMAL
  • FLOAT
  • INT
  • MONEY
  • NCHAR
  • NTEXT
  • NUMERIC
  • NVARCHAR
  • REAL
  • SMALLDATETIME
  • SMALLINT
  • SMALLMONEY
  • TIME
  • TINYINT
  • UNIQUEIDENTIFIER
  • VARBINARY
  • VARCHAR

Unsupported Datatypes​

The following datatypes are not supported.

  • CURSOR
  • GEOGRAPHY
  • HIERARCHYID
  • SQL_VARIANT
  • XML
Last updated on