Question
Merkle
GB
Last activity: 4 Jun 2024 6:25 EDT
How to access Pega Cloud PostgreSQL from external tools
Hi,
Sometime we had to change keys, needs to check the table DDL definetion etc.
For those we had to raise CC ticket for now, as everything can't be done via Pega schema tools.
I am talking about all different operations we used to do via SQL Developer kind of tools.
Is there any way we can do the same in Dev environment?
We are in V8.8.3 and in cloud.
Many thanks,
Gopesh
Accepted Solution
Merkle
GB
@SohamM95 Thanks for your replay!
Hi,
I did explore further and as you mentioned we don't have any OOTB way to run SQL and use connect-SQL rule to write the queries!
Reach out to Pega via a Cloud ticket, which Pega responded very quickly to run any DDL or query any information about the DB table or database. Even they help to run any query on our behalf.
Via activity we can use connect-SQL method to run DDL too, if needed.
So, we have options to update DDL but we can't directly update/see DB table & schema details via tools like SQLDeveloper.
Hence marking this question as resolved as per this solution.
Thanks,
Gopesh
Maantic Inc
IN
I don't think its possible in Pega cloud. Essentially db access in cloud is kind of like a black box. You can use the Query Runner to normal SQLs, otherwise Connect-SQL can be used. But essentially you're mostly relying on Pega GCS for most db actions.
Accepted Solution
Merkle
GB
@SohamM95 Thanks for your replay!
Hi,
I did explore further and as you mentioned we don't have any OOTB way to run SQL and use connect-SQL rule to write the queries!
Reach out to Pega via a Cloud ticket, which Pega responded very quickly to run any DDL or query any information about the DB table or database. Even they help to run any query on our behalf.
Via activity we can use connect-SQL method to run DDL too, if needed.
So, we have options to update DDL but we can't directly update/see DB table & schema details via tools like SQLDeveloper.
Hence marking this question as resolved as per this solution.
Thanks,
Gopesh