Layer7 API Management

  • Private Community

  • 1.  Can API Gateway connect to PostgreSQL?

    Posted Apr 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 Apr 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

    Broadcom Employee
    Posted Apr 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 Apr 24, 2017 01:43 PM

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

     

     

    Regards

    Kareem