Manage Test Data


#1

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

#2

The Test Data option looks great. But how do I use it to get data into my web form ?

Most online database systems have an import option from CSV.

The database I am using has this option and I want to Automate the process of getting the data out of my system manipulate it in Excel, and then put it back into the online database system.

It would be great to use this product to do it. But the steps are disjointed from one another.
IE you have the option to upload a CSV file to your database. But I need to use my import facility to get access to the CSV file.

Anyhow,
That is the issue, thanks for listening.

Regards,
Nigel.


#3

Team, unlike we add multiple rows and columns in internal test data, is it possible to store multiple database queries in Database test object? Something similar to hibernate? Please advise.


#4

One more suggestion is to have test data in key value pair or store it as variables. Global variables are okay but sometimes we have content which is common for all environment profiles. We cannot replicate same variables for all profiles and there are chances to get missed.
There should be something like common test data file which all test cases and keywords can access.


#5

I want to use global database connection in custom keyword, so how can I call it ?


#6

I had the same need. One workaround I used, that works fine is I created a internal DB called SharedVariables that only has 2 columns ( like a key,value pair) first one is the variableName (key) and the second one is the value. I added in all the common items for all environments. Then in the profile for that environment, for those Global Variables that are in the SharedVariables db I reference the SharedVariable DB associated rows. In the Script View for the Profile, after I setup all the ones I had that were shared, I then copied that XML for those Shared Variables to other environment profiles that needed them.

Downside is I just have to remember when I create new SharedVariable in the DB and reference in a profile, need to remember to copy it to any of the other Environment profiles as well so they will have it. However, if any of those SharedVariables change I only have to change it in one place the SharedVariable internal DB.

Ideally, figure out all of your known variables that are the same across all environments ahead of time, setup the references in the default profile and then make a copy of that one for any other environment profiles.


#7

That last link isn’t working https://docs.katalon.com/pages/viewpage.action?pageId=786668 I am seeing this https://share.getcloudapp.com/nOuE2G45


#8

Thanks Monica, but this still does not solve the database query storage issue.