Skip to content

Click in-app to access the full platform documentation for your version of DataRobot.

MS SQL Server Connector for Data Prep

User Persona: Data Prep Admin or Data Source Admin

Note

This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.

Configure Data Prep

The ability to connect to Microsoft SQL Server is part of the Data Prep JDBC Connector. This topic provides details specific to setting up a connection to Microsoft SQL Server. See also the JDBC Connector Documentation to configure the connection.

Example JDBC URI:

jdbc:sqlserver://cs-mssql1-db1.yourMsSqlHost:yourMssqlPort

Technical Specs

Driver Specs

  • Microsoft SQL Database driver name & version:
    • Driver Classname: com.microsoft.sqlserver.jdbc.SQLServerDriver
    • Version: 7.4
  • Supported Microsoft SQL Database versions:
    • Microsoft SQL Server 2019
    • Microsoft SQL Server 2017
    • Microsoft SQL Server 2016
    • Microsoft SQL Server 2014
    • Microsoft SQL Server 2012

Driver Documentation


Updated October 28, 2021
Back to top