Data Source URL String Having SQL Server Instance

Modified on Wed, 12 Feb at 3:50 PM

Data Source URL String Having SQL Server Instance :

In case your database connection string has a server instance please follow the following string format while creating the data source profile.

SQL :

jdbc:jtds:sqlserver://10.0.0.85;instance=SQLEXPRESS;databasename=test

jdbc:jtds:sqlserver://10.223.3.16:1433/RDS;instance=INSTANCE2

MYSQL :

jdbc:mysql://127.0.0.1:3306/test

Oracle :

jdbc:oracle:thin:@10.0.0.7:1521:jmc

Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten Version 5.x you may be using.

Tags: Data Source URL, Instance, String, Business Intelligence Support, Business Intelligence Articles, Business Intelligence Training, SQL Server Instance, Database Connection String, SQL, jdbc, jtds, MySQL, Oracle, Server Instance, Connection Profile, SQLEXPRESS, INSTANCE2, RDS, MySQL JDBC, Oracle JDBC, Database Name, port, IP Address, Connection Format,