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.
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.
No comments:
Post a Comment