Databases - Connecting Spotfire Data Science to MSSQL Server using JTDS driver

Databases - Connecting Spotfire Data Science to MSSQL Server using JTDS driver

Connecting Spotfire Data Science to MSSQL Server using JTDS driver

Connecting Spotfire Data Science to MSSQL Server using JTDS driver

Follow the steps below to connect Spotfire Data Science to MSSQL Server via jtds driver (you have to download the jtds 1.3.1 jar file from MSSQL web site):

1. Copy the jtds driver to the $CHORUS_HOME/shared/ALPINE_DATA_REPOSITORY/jdbc_driver/Public and $CHORUS_HOME/shared/libraries directories and change the ownership of these copies to the user who runs Spotfire Data Science (usually user 'chorus').

2. Create a new jtds directory: $CHORUS_HOME/shared/ALPINE_DATA_REPOSITORY/jdbc/jtds and copy the content of $CHORUS_HOME/shared/ALPINE_DATA_REPOSITORY/jdbc/sqlserver directory to the newly created jtds directory.

3. Edit the content of $CHORUS_HOME/shared/ALPINE_DATA_REPOSITORY/jdbc/jtds/driver.properties file:

# Specify the JDBC class driver for the desired database type.
# Examples:
# Oracle = oracle.jdbc.driver.OracleDriver
# Greenplum = org.postgresql.Driver
# DB2 = com.ibm.db2.jcc.DB2Driver
# Netezza = org.netezza.Driver
# PostgreSQL = org.postgresql.Driver
# SQLServer = com.microsoft.sqlserver.jdbc.SQLServerDriver
# MySQL = com.mysql.jdbc.Driver
# Teradata = com.teradata.jdbc.TeraDriver
# Vertica = com.vertica.jdbc.Driver
# Sybase = com.sybase.jdbc2.jdbc.SybDriver
# Informix = com.informix.jdbc.IfxDriver
# SAPDB = com.sap.dbtech.jdbc.DriverSapDB
# InterBase = interbase.interclient.Driver
# HSqlDB = org.hsqldb.jdbcDriver
# MariaDB = org.mariadb.jdbc.Driver
# MySQL = com.mysql.jdbc.Driver
driverClass=net.sourceforge.jtds.jdbc.Driver
#driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

4. Restart Spotfire Data Science and set the Data Connection using a similar URL:

jdbc:jtds:sqlserver://10.0.0.199:1433;databaseName=robot_automation