Get data from external data sources for pega application

Normally we store data in our application from tables using data pages and access these data in UI using sections. In this post I will explain how to reference external source data in our application. 
There are two ways to do this:-
1. Database Table Class Mapping Tool
2. SQL Connector

The Database Table Class Mapping tool is a inbuilt wizard in pega PRPC which generates all the artifacts needed to reference data in an external database. These artifacts include a data class, a database table instance and a link between those two artifacts.

The SQL connector is advance tool in pega PRPC which is used when you want to write your custom and complex SQL queries to interact with database tables. 

So to summarize, Database Table Class Mapping Tool is very simple method to do this. Before starting this wizard you need to configure the external database in your application. Then decide which table from configured database you want to use. 

Search and replace a string in Pega

Use this OOTB Pega function to search and replace a particular string with another string.

@(Pega-RULES:String).replaceAll("your feed","old chars","new chars")

Add a SLA in a screen flow

A SLA can be added to a screen flow in the process tab of screen flow or you can customize Assign-.NewDefaults OOTB activity.