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