RDBMS providers: SQL Server

Overview

Redpoint Data Management v9.6.1 introduces a next-generation set of database providers, including Microsoft SQL Server, with bulk load. These next-generation data providers were rewritten to be more robust and performant.

Next-generation provider features: Refer to RDBMS database providers for additional information.
Connection options: Refer to Configure RDBMS connection options for information about setting options for both next-generation and legacy database providers.
Schemas: Refer to RDBMS schemas for information about schemas for both next-generation and legacy database providers.

This section summarizes the database providers that can connect to Microsoft SQL Server database servers and describes their variants.

Data Management v9.5.3 introduces the following connection attributes (refer to the corresponding properties in Setting the connection properties for more information).

Connection attribute

Description

Default value

Encrypt

Set to "true" to specify that the SQL Server uses TLS encryption for all the data sent between the client and the server if the server has a certificate installed.

"true"

Trust server certificate

If false, the driver validates the server TLS/SSL certificate. If the server certificate validation fails, the driver raises an error and closes the connection.

Set to true to specify that the driver doesn't validate the server TLS/SSL certificate. If true, the server TLS/SSL certificate is automatically trusted when the communication layer is encrypted using TLS.

false

Host name in certificate

The host name to be used to validate the SQL Server TLS/SSL certificate.

null

Many providers offer authentication variants:

Trusted connections use implicit operating system security based on the login used by the Data Management services.
SQL Auth or Standard Security both refer to SQL Server Authentication.

Many providers offer both "allow reconnect" and "no reconnect" variants. Select the "allow reconnect" option to enable database reconnect for long-running projects that may be susceptible to database disconnects due to cloud-based environmental factors or other issues.

"Allow reconnect" strategies will cause the RDBMS Input tool to spool records until the data set is complete and then move the entire data set at once, rather than streaming records as soon as they are available.

Database name	Database API	Authentication options available	Reconnect option available	Notes
SQL Server	JDBC	SQL Auth, Trusted	Yes	Requires `mssql-jdbc-12.8.1.jre8.jar`.