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

 OR 

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 ElegantJ BI Version 4.1. This may or may not be relevant to the ElegantJ BI version you may be using.