Question
igate global solutions
IN
Last activity: 30 Nov 2015 12:27 EST
What are the prerequisites to use DB in a PEGA Application.
What are the rules needed to create in a PEGA Application and please provide me the steps to do so.
What has to be done from PEGA Side to use an existing Database. How to do when the Database is DB2 and when it is PEGA DB.
Please provide me some links.
Accepted Solution
Pegasystems Inc.
IN
Hi Nagavenkata, As Ashish mentioned, if you are mapping external DB to some class, you need to create Data-Admin-DB-Name instance. Access Use the Rules explorer to list database data instances on your system. Category The Data-Admin-DB-Name class contains database data instances. They are part of the SysAdmin category. Refer to below pdn link for more details. https://community.pega.com/sites/default/files/help_v62/procomhelpmain.htm When you create Data-Admin-DB-Name instance you have to select from one of three choices. Use configuration in preferences to refer to a database/databases/pegarules element in the prconfig.xml file that defines the location, TCP/IP port, account name and password of a relational database. Use JDBC Connection Pool to use a connection pool defined by a Java Naming and Directory Interface (JNDI) facility. Use JDBC URL listed below to use a Universal Resource Locator to find the Java Database Connectivity information. Refer below pdn link for more details.
Hi Nagavenkata, As Ashish mentioned, if you are mapping external DB to some class, you need to create Data-Admin-DB-Name instance. Access Use the Rules explorer to list database data instances on your system. Category The Data-Admin-DB-Name class contains database data instances. They are part of the SysAdmin category. Refer to below pdn link for more details. https://community.pega.com/sites/default/files/help_v62/procomhelpmain.htm When you create Data-Admin-DB-Name instance you have to select from one of three choices. Use configuration in preferences to refer to a database/databases/pegarules element in the prconfig.xml file that defines the location, TCP/IP port, account name and password of a relational database. Use JDBC Connection Pool to use a connection pool defined by a Java Naming and Directory Interface (JNDI) facility. Use JDBC URL listed below to use a Universal Resource Locator to find the Java Database Connectivity information. Refer below pdn link for more details. https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm Hope this answers your query.
JPMC
IN
below links explain about application creation:
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm delivery/new-application-wizard/proj-creating-express-application-tsk.htm
BTW what is your PRPC version?
And i did not understnad your query about DB. Your DB configuration would have been already done while you installed PRPC.
When you say existing DB, have you installed PRPC yet or not? What tables does your existing DB have?
igate global solutions
IN
Yes DB will be installed when you install PEGA but I am asking about What are the rules need to be created in PEGA to interact with DB like Database rule etc.,
I am using PEGA version 6.2
JPMC
IN
You need not do that manually unless you are also having an external DB which you want to map some of the classes.
The rules to be created then are:
1) Create Data-Admin-DB-Name instance
2) Under the class(to which external table needs to be mapped) create a Data-Admin-DB-Table instance.
igate global solutions
IN
Thanks for the information.
Also would like to know about the Data Source, Connection pool for a external DB, how they will get created and where we can see in PEGA.
Accepted Solution
Pegasystems Inc.
IN
Hi Nagavenkata, As Ashish mentioned, if you are mapping external DB to some class, you need to create Data-Admin-DB-Name instance. Access Use the Rules explorer to list database data instances on your system. Category The Data-Admin-DB-Name class contains database data instances. They are part of the SysAdmin category. Refer to below pdn link for more details. https://community.pega.com/sites/default/files/help_v62/procomhelpmain.htm When you create Data-Admin-DB-Name instance you have to select from one of three choices. Use configuration in preferences to refer to a database/databases/pegarules element in the prconfig.xml file that defines the location, TCP/IP port, account name and password of a relational database. Use JDBC Connection Pool to use a connection pool defined by a Java Naming and Directory Interface (JNDI) facility. Use JDBC URL listed below to use a Universal Resource Locator to find the Java Database Connectivity information. Refer below pdn link for more details.
Hi Nagavenkata, As Ashish mentioned, if you are mapping external DB to some class, you need to create Data-Admin-DB-Name instance. Access Use the Rules explorer to list database data instances on your system. Category The Data-Admin-DB-Name class contains database data instances. They are part of the SysAdmin category. Refer to below pdn link for more details. https://community.pega.com/sites/default/files/help_v62/procomhelpmain.htm When you create Data-Admin-DB-Name instance you have to select from one of three choices. Use configuration in preferences to refer to a database/databases/pegarules element in the prconfig.xml file that defines the location, TCP/IP port, account name and password of a relational database. Use JDBC Connection Pool to use a connection pool defined by a Java Naming and Directory Interface (JNDI) facility. Use JDBC URL listed below to use a Universal Resource Locator to find the Java Database Connectivity information. Refer below pdn link for more details. https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm Hope this answers your query.