Database Settings

Feedback & Reviews Documentation
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

2 Likes
6

thank you Aliasger_Kiranawala it works.

1 Like
7

image
image791×602 22.6 KB

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

10

I can’t see ‘JDBC Driver’ field too.
Please help me.

Thanks

11

katalon
katalon802×631 65 KB
.
have connect msaccess driver into database connect it throw the following error.if any one knows help me