Skip to main content

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

Pega 8 integration layer

Updated on March 4, 2022

A new integration layer and data page rules are introduced in Pega7 Smart Investigate release. Prior to Smart Investigate 7.

  • A separate database integration layer was not defined.
  • Data from the database was fetched directly via connect-SQL rules making it tightly coupled with the application.
  • New set of connect-SQL rules had to be defined in the application to extend the support for new databases.

Starting Smart Investigate 7x.

  • A new pluggable database integration layer has been added for easy implementation.
  • Data from the database is fetched via Data Pages through Report Definition rules.
  • With Report Definition rules, the troublesome approach of creating new connect-SQL rules for new database is eliminated, making the application loosely coupled with Database.

As part of the integration layer Connect-SQL rules in Smart Investigate Layer have been converted to Report definitions referred through Data pages.

Ideally Integration class is required if data is read from external system. We don’t need the data integration layer if the if data is populated during runtime in database table or If the framework is designed for mapping data class layer with database layer for storing data (for example: Data- Admin-Operator-Security class instances are directly stored in DB table)

Following are the list of Smart Investigate Database tables considered for adding Integration layer in the Framework.

  • Research Manager Layer
  • Payments Layer
  • Securities Layer
Pega Smart Investigate for Payments Implementation Guide
  • Previous topic Smart investigate for payments data tables and views
  • Next topic High level implementation approach for data page conversion

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. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us