Posted: 20 Nov 2019 8:21 EST Last activity: 22 Nov 2019 2:27 EST
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.
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.