Microsoft SQL Server connector

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

Supported platforms

  • Unix

  • Linux

  • Windows

  • AWS RDS

  • Azure SQL

  • Azure Managed Instance

  • Azure SQL Data Warehouse

  • Google Cloud SQL

Supported versions

  • 2012

  • 2014

  • 2016

  • 2017

  • 2019

  • 2022

Supported features

Mode

Feature

Availability
Security

TLS/SSL

Available

Password Vault

Available

Kerberos

Available
In-place masking

Multi-tenant

Available

Streams/Threads

Available

Batch Update

Available

Drop Indexes

Available

Disable Triggers

Available

Disable Constraints

Available

Identity Column Support

Available
On-the-fly masking

Truncate

Available

Disable Triggers

Available

Disable Constraints

Available
Profiling

Multi-tenant

Available

Streams

Available

TLS/SSL setup instructions

To enable TLS/SSL connectivity with an Microsoft SQL server connector:

  1. Add the database’s certificate to the setup application. Follow instructions in the Adding a Certificate section under the TrustStore settings page.

  2. Restart the Continuous Compliance Engine.

  3. Create a Microsoft SQL Server connector in Continuous Compliance with the relevant parameters. Upload a properties file for the connector with the following:

    4. encrypt = true 
    trustServerCertificate = false / true <—---- Depending upon whether to directly accept the database certificate without checking certificate common-name
hostNameInCertificate = 10-110-229-143.qa-ad.delphix.com   <—---- This property is only required in case trustServerCertificate is set to false

Google Cloud SQL IAM Authorization setup

To authorize connections from Continuous Compliance to a Google Cloud SQL Microsoft SQL Server instance, do the following:

  1. Provision a Google Compute Engine running Continuous Compliance. In the compute engine’s settings, enable Cloud SQL in the Identity and API access section.

  2. Create a built-in Microsoft SQL Server connector with the following settings:

    1. Advanced Connector with JDBC URL:

      jdbc:sqlserver://localhost;databaseName=<your-database>;encrypt=false

    2. Upload a property file with the following:

      3. socketFactoryClass=com.google.cloud.sql.sqlserver.SocketFactory 
      socketFactoryConstructorArg=<connection name of the SQL Server instance from the Google Cloud web console>