Data Source URL String Having SQL Server Instance

Modified on Wed, 15 Mar 2017 at 11:19 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

 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.


 

 

 

Data Source URL Instance String ElegantJ BI Support ElegantJ BI Knowledgebase ElegantJ BI Articles ElegantJ BI Training Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article