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?