Layer7 API Management

Expand all | Collapse all

Can API Gateway connect to PostgreSQL?

Jump to Best Answer
  • 1.  Can API Gateway connect to PostgreSQL?

    Posted 04-24-2017 03:41 AM

    Hi 

     

     

    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?

     

     

    Regards

    Kareem



  • 2.  Re: Can API Gateway connect to PostgreSQL?

    Posted 04-24-2017 06:21 AM

    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?



  • 3.  Re: Can API Gateway connect to PostgreSQL?
    Best Answer

    Posted 04-24-2017 12:42 PM

    Kareem,

     

    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 

     

    Sincerely,

     

    Stephen Hughes

    Director, CA Support



  • 4.  Re: Can API Gateway connect to PostgreSQL?

    Posted 04-24-2017 01:43 PM

    Thanks Stephen, we will follow the steps from the documentation. 

     

     

    Regards

    Kareem