Posted: 20 Jan 2020 17:36 EST Last activity: 22 Jan 2020 8:12 EST
Robotic Database Search at DB Object Layer
I am new to Pega and I currently work in databases that are all over the place. So im trying to develop an automation to do a search on a DB server at DB object Layer. but I would like to know if this is possible.
Has anyone developed or have an idea of how to implement an RPA/RDA to do a search on the DB server at the DB object layer using keywords to search for DB NAME, DB TABLE, COLUMN NAMES.
In terms of the specific tables or what not that you'd need to connect to or search on, I can't really help you, but in terms of how you'd make calls to a Database in a robotic automation, you have the various components available under the "Data" section in the Toolbox. The various "query" components allow you to run queries against databases using the SQL you create to get or update whatever data you wish.