Question
postgres sql database 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.
Michael,
I'm not sure I exactly follow what you are trying to do. Do you want to create an object that you can interact with on the clipboard and write to that specific table? You created the class "Bsu-Intergrat-Data" and allowed the system to build a table with columns for the various properties you care about? If you create a clipboard page of that class and map values into your page, can you successfully to an obj-save to see it get written to the DB? If that works, an obj-open-by-handle should work to get instances out from the database (or any of the other methods for reviewing objects in the database, like obj-browse).
I'm not 100% certain I actually answered the question for you. It might help if you could clearly outline the business problem you need to solve with this. Then it would be easier to offer guidance on how best to do that.
Thanks,
Mike Townsend