Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Additional Jdbc Parameter

Hi Team

 

I am very basic to Java

Can you please help me out what is the reason to use additional jdbc parameters in db componets

in Which scenarios do we need to use it

 

Please help me out with your answer

 

Thanks in Advance

Saranya

 

 

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

depending on the database you're connecting to there may be the need to pass additional information beyond the standard jdbc connection fields  host/port/database/schema/user/password. One example of this is for MSSQL, often you need to define a specific "instance". To add this information to the connection string, you would add "instance=myInstance" in the additional jdbc parameters. If additional parameters are required for your specific database, you'll be able to find how exactly to define them in the database documentation. 

 

 

View solution in original post

1 Reply
Anonymous
Not applicable
Author

depending on the database you're connecting to there may be the need to pass additional information beyond the standard jdbc connection fields  host/port/database/schema/user/password. One example of this is for MSSQL, often you need to define a specific "instance". To add this information to the connection string, you would add "instance=myInstance" in the additional jdbc parameters. If additional parameters are required for your specific database, you'll be able to find how exactly to define them in the database documentation.