Delphix Products

 View Only

Converting MSSQL Advanced Database Connectors to Basic Connectors

By Sandro Latini posted 07-06-2022 12:29:47 PM

  

MSSQL Advanced database connectors are widely used to permit customers to access their databases via a domain user account on the Delphix Continuous Compliance engine (KBA reference: Configuring_Masking_Connector_for_Microsoft_SQL_(MSSQL)_(KBA1214)).
However, starting from Delphix Continuous Compliance version 6.0.6.0, customers are able to provide a Customer Properties File where they can pass on to the JDBC driver all the extra properties required.

Please consider updating your configuration to take advantage of this new functionality, as we may deprecate the MSSQL Advanced connectors in a future release.

Advanced Connector Configuration

The example below shows a MSSQL Advanced database connector in Delphix Continuous Compliance version 6.0.5.0 or older 6.0.x.y version:

Advanced Connector Configuration

The JDBC URL field included three extra properties to indicate that we wanted to use a domain user account to access the database:


domain=[domain_name]

integratedSecurity=true

authenticationScheme=NTLM


Below is an example of the resulting JDBC URL (on 2 lines due to formatting in this blog, please do not insert a line break after domain_name):

jdbc:sqlserver://;serverName=server_hostname;port=port_number;databaseName=database_name;domain=domain_name;
integratedSecurity=true;authenticationScheme=NTLM


Migrating to the Basic Connector with Property File

The same database connector will have an additional Customer Properties File option after upgrading to version 6.0.6.0 or later:

Basic Connector Configuration Edit

Using the example above, a customer can convert the database connector to a Basic Connector by completing the following procedure:

  1. Click on the Basic radio button
  2. In the Database Name field, type the name of the SQL Server database.
  3. Provide the hostname of the database in the Host Name/ IP field. 
  4. Leave the Instance name field blank.
  5. Provide the port number in the Port field.
  6. Click Select in the Custom Properties File section and provide the .properties file. Example of content of a typical mssql.properties file:
    domain=domain_name
    integratedSecurity=true
    authenticationScheme=NTLM


    This file can be reused to convert any other Advanced connector to Basic as long as the domain property is the same. 

  7. Provide username and password.
  8. Verify connectivity by clicking Test Connection.

Example of the converted database connector:

​​

0 comments
39 views

Permalink