How to configure a JDBC Data Source to Azure SQL Data Warehouse in Team Studio?
Article ID: KB0076335
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?
Issue/Introduction
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)
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:
jdbc:sqlserver://tsds.database.windows.net:1433;database=dw;
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)
Feedback
Yes
No
Powered by
