Data Source URL String Having SQL Server Instance

Modified on Wed, 6 Mar at 3:39 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 Smarten Version 5.x. This may or may not be relevant to the Smarten Version 5.x you may be using.


 

 

 

Data Source URL Instance String 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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article