How to configure a JDBC Data Source to Azure SQL Data Warehouse in Team Studio?

Created
October 08, 2021 23:16

Date Posted: 2020-01-31
Product: TIBCO Spotfire®

Problem:

Solution:

How to configure a JDBC Data Source to Azure SQL Data Warehouse in Team Studio? 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:

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)