Can API Gateway connect to PostgreSQL?
I could see an assertion perform 'Perform JDBC Query'.
Is there a way to connect to PostgreSQL and insert records in the table?
We are following below document.
Create a JDBC Connection to the OTK/OIDC Database (PostgreSQL) - CA Secure Cloud - 1.58 for Service Providers - CA Techn…
PostgreSQL connection driver is not available in our environment. Can someone guide on the steps to get the driver and on gateway for connectivity?
We deliver with Data Direct drivers and have validated the JDBC drivers listed in the JDBC connection drop down through testing in our lab environment. For other providers, you can download the JAVA driver libraries and follow the steps outlined in our documentation to implement.
PostgreSQL driver download:PostgreSQL JDBC Download
Gateway JDBC documentation: Install the JDBC Interface - CA API Gateway - 9.2 - CA Technologies Documentation
Director, CA Support
Thanks Stephen, we will follow the steps from the documentation.