How to configure a JDBC Data Source to Azure SQL Data Warehouse in Team Studio?
book
Article ID: KB0076335
calendar_today
Updated On:
Products
Versions
Spotfire Data Science Team Studio
6.5.0
Description
How to configure a JDBC Data Source to Azure SQL Data Warehouse in Team Studio?
Resolution
Download the JDBC MSSQL Driver Jar Version 7.4.1 for Java JDK 1.8 from Microsoft Site.
Place the JAR file on Team Studio Server in the following Directories: 1. $CHORUS_HOME/shared/libraries 2. $CHORUS_HOME/shared/ALPINE_DATA_REPOSITORY/jdbc_drivers/Public
Restart Team Studio.
Use the following connection formation for the JDBC URL:
Explanation of fields: database=dw : dw is the name of your database 1433 : is the port tsds.database.windows.net : this is your host (Use hostname or IP)
Issue/Introduction
How to configure a JDBC Data Source to Azure SQL Data Warehouse in Team Studio?