Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 SATHISH KRISHNAMURTHY (SATHISHK7575) Infosys Ltd
Infosys Ltd
IN
SATHISHK7575 Member since 2018 27 posts
Infosys Ltd
Posted: Nov 20, 2019
Last activity: Nov 22, 2019
Posted: 20 Nov 2019 8:21 EST
Last activity: 22 Nov 2019 2:27 EST
Closed

How to access DB2 and MEM SQL databases from Pega Openspan

Hi, How to establish connectivity from Pega Openspan to DB2 and MEM SQL databases. Our project requirement is by using Pega Openspan, we need to access tables from DB2 and MEM SQL databases and do a comparison of data fetched from both databases.

To see attachments, please log in.
Robotic Process Automation

Posted: 4 years ago
Posted: 20 Nov 2019 15:51 EST
Thomas Sasnett (ThomasSasnett) MOD Lead Robotics Architect
Pegasystems Inc.
US

You would use the ODBCQuery component; in this case two of them. You'd execute your stored procedure (or SQL) which would return a DataTable. Whatever comparison you'd be doing on that object would best be done in a C# script.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice