ThingWorx Extensibility > JDBC Extensibility > JDBC Configuration Examples
  
JDBC Configuration Examples
JDBC Configuration for SQLServer
The following table contains the configuration for SQL Server/SQL Server Express
* 
SQL Server must have SQL Authentication enabled. this means you must either be in SQL Authentication or Mixed mode
Option
Value
Connection Test/String Query
SELECT GetDate()
JDBC Connection URL
jdbc:sqlserver://<Server>\<Instance>;databaseName=<Database name>
JDBC Driver Class Name
com.microsoft.sqlserver.jdbc.SQLServerDriver
Example:
jdbc:sqlserver://10.128.0.169\SQLEXPRESS;databaseName=ThingWorxSample
JDBC Configuration for Teradata
Option
Value
Connection Test/String Query
Select count(*) from dbc.tables;
JDBC Connection URL
Jdbc:Teradata://DatabaseServerName/user=Value,
password=Value,database=Value
JDBC Driver Class Name
Com.teradata.jdbc.TeraDriver
Example:
jdbc:Teradata://10.128.0.169/user=TWUser;password=TWPass,
database=ThingWorxSample
JDBC Connection to IBM DB2 UDB on an AS400
Option
Value
Connection Test/String Query
SELECT count(*) FROM SYSIBM.TABLES;
JDBC Connection URL
jdbc:as400://servername/;Libraries=TESTDTA;

TranslateBinary=true;Prompt=false;TransactionIsolation=none
JDBC Driver Class Name
com.ibm.as400.access.AS400JDBCDriver
Example:
jdbc:as400://10.128.0.135/;Libraries=ThingWorxSample;

TranslateBinary=true;Prompt=false;TransactionIsolation=none