JDBC Driver for Azure Synapse

Build 22.0.8326

CData JDBC Driver for Azure Synapse

Overview

The CData JDBC Driver for Azure Synapse offers the most natural way to connect to Azure Synapse data from Java-based applications and developer technologies. The driver wraps the complexity of accessing Azure Synapse data in an easy-to-integrate, 100%-Java JDBC driver. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

  • Write SQL to retrieve and update Azure Synapse data.
  • Compliant with JDBC 3.0 and JDBC 4.0.
  • Codeless integration with popular BI, reporting, and ETL tools.

Getting Started

See Getting Started for A-Z guides on authenticating and connecting to Azure Synapse data. See the Azure Synapse integration guides for information on connecting from other applications.

NOTE: The license file, cdata.jdbc.azuresynapse.lic, must be in the same location as the JAR file, cdata.jdbc.azuresynapse.jar. See the readme file for more information.

Using the JDBC Driver/Using from Tools

See Using JDBC for examples of using standard JDBC classes like DataSource, Connection, Statement, ResultSet, and others, to work with Azure Synapse data.

Using from Tools walks through the steps of integration with JDBC tools, using several popular database tools as examples.

Schema Discovery

See Schema Discovery to access schema information through the standard JDBC interfaces.

Advanced Features

Advanced Features details additional features supported by the driver, such as , ssl configuration, firewall/proxy settings, and advanced logging.

Connection String Options

The Connection properties describe the various options that can be used to establish a connection.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8326