Michael Talbott (MichaelT1003)

MichaelT1003 Member since 2015 9 posts
Posted: September 8, 2015
Last activity: September 9, 2015
Posted: 8 Sep 2015 13:24 EDT
Last activity: 9 Sep 2015 15:40 EDT

postgreSQL integration

I am trying to integrate with a postgres sql database. 

We are integrating a sql database with pega 7.1.6. We have created the database instance and used the database class mapping tool to map the class in Data. I can see each column as they are displayed as a property underneath the table name.

The hierarchy is like this Bsu-Intergrat-Data.  

How do I actually use the properties that were created in the database class mapping tool. I would gather I need a data page somewhere. Does that data page need to be on the work or data side?

I have tried to make a data page and then also try to use connector as a source of the data page which I dont seem to be doing correctly. The data page creation screen at the data source I ran the connect and metadata wizard which then created the Bsu-Integrat-Work-Int class where I can again see the properties from the actual database but not see them or manipulate them in pega.  

The connection is good to the database and the mapping correctly displays each column. But how do i actually query the database and show results in pega? 

Thanks for your help in advance.

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.