dslink-java-jdbc

A Java DSLink that works with JDBC.

MS SQL

Step 1: Install JDBC DSLink

Follow steps under "Add a new DSLink" section from http://wiki.dglogik.com/dglux5_wiki:getting_started:access_dsa_data.
Select "From Repository" when you right click on /links node. In this case select JDBC from the list and install.

Step 2: Configure correct MS SQL JDBC driver

Download MS SQL JDCB from https://www.microsoft.com/en-US/download/details.aspx?id=11774.
Install MS SQL driver.
Copy MS SQL driver jar file (select correct jar version based on JDK). Typical path is <Microsoft JDBC Driver 6.0 for SQL Server>\sqljdbc_6.0\enu\jre8 (for JDK 8).
Copy driver jar file to dsa-server\dslinks\jdbc\lib folder.

Step 3: Restart DSLink

Restart DSLink : sys -> links -> JDBC right-click and select restart dslink.

Step 4: Configure MS JDBC

Right click downstream -> jdbc (Name may changes based on your DSLink name from step 1).
Select MS SQL driver from a list.

Example Connection Strings

jdbc:sqlserver://[ServerIP or ServerName]:[Port];instance=[instance name];databaseName=[database name]

Notes

Default port is 1433. If the port is not default, include port in the connection string.
Make sure TCP\IP connection is enabled for SQL Server.
Make sure SQL server port is not dynamic.