Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Integrating data

Updated on June 22, 2022

You can integrate your database tables using a data page that calls a report definition. The results appear in a data page (each record is an instance of a data class).

Pega Smart Dispute for Acquirers Implementation Guide
  1. Replace Pega Foundation for Financial Services integration layer with your own integration classes to connect to your external data. This could be using a connector to a web service or the Database Table Class Mapping wizard for a database.
  2. Create a report definition in the new integration layer.
  3. Create a data class based on the Pega Foundation for Financial Services data class and PegaFS-Data as per your requirement.
  4. The report definition can be used in a data page. The data page can also use a connector to a web service or use a Lookup to fetch details from the external database table.
  5. Create the data transforms OpenMap and SaveMap for newly created integration class for fetching the data from the table and saving the data into the table. The property names for columns from the database should be mapped to the Pega Foundation for Financial Services properties, if the data layer of Pega Foundation for Financial Services is intended to be reused. Modify the response data transform for the data page.
  6. Repeat this process to populate all the data pages that need to fetch data from the data layer.
For example: The following example shows how to obtain credit card account data from an external database for an application named MyApp:
  1. Use the Database Table Class Mapping wizard to generate a data class named MyApp-Int- SAMPLE_CCACCT that accesses the external database table with credit card account information.
  2. Create a report definition named GetCreditCardDetails that returns a list of all the credit card accounts.
  3. Create data transforms OpenMap and SaveMap in MyApp-Int-SAMPLE_CCACCT.
  4. Create a data page D_MyAppCreditCardAccountDetails datapages to use the report definition that you created.

    For example: D_CreditCardAccountSummary

  5. Create a response data transform in the Code-Pega-List class which uses the OpenMap data transform to fetch data from the database table.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

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

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us