Database Settings


#1

This is a companion discussion topic for the original entry at https://docs.katalon.com/katalon-studio/docs/database-settings.html

#2

Hello team, sometimes a single Web application is communicating with multiple micro services which has separate databases. Is it possible to add more than one database profiles inside Database settings screen. Currently I have to prepare a custom keyword to achieve it.


#3

Hello all,
I have the same requirement as Aliasger.
I am following the below steps to test data manually, but automating this scenario using Katalon is my ultimate task -
Login to App1 to access Qlik Sense app (QSApp) (single sign-on feature)
Extract data for all customers from App1,
Extract the same data from QSApp database
Compare the two of them to see if there is any data discrepancies.

Constrains:
The data exported on App1 does not have the same field names / details as that on QSApp. So i am applying macros on excel to make the two files identical.

For now, I know that I can query database using Katalon, but is it possible to Query two database, extract the results and compare them, all during the test execution (run-time checks) ?
Any help on this would be much appreciated.

Thank you in advance for you time and help!


#4

Hello. Does anyone know how to access different databases within the same Katalon project? Thank you!


#5

You can use Database plugin and define database connection details in global variable.
https://store.katalon.com/product/24/DBMS-Keywords


#6

thank you Aliasger_Kiranawala it works.


#7


I can’t see ‘JDBC Driver’ field when try to connect DB.
Please help to check this case.

Thanks


#8

Hi,

I am trying to connect the Snowflake database from Katalon studio and it’s throwing me an error related to “No Suitable driver found”. Can you provide a link to get the appropriate JDBC driver for snowflake??

Thanks.


#9

@siri.korla have you tried this one?

https://docs.snowflake.net/manuals/user-guide/jdbc.html