Cloud Pak for Data Group

Expand all | Collapse all

CP4D - PostgreSQL Connection

  • 1.  CP4D - PostgreSQL Connection

    Posted Fri February 07, 2020 03:50 PM
    Hello!

    I am exploring the 'Connections' on CP4D. I am trying to create a new connection for PostgresSQL database. I don't find an option to select in the connection type. Any reason why I cannot create PostgresSQL connection?

    Thanks!

    ------------------------------
    Geeta Rayarapu
    ------------------------------


  • 2.  RE: CP4D - PostgreSQL Connection

    Posted Mon February 10, 2020 04:49 AM

    Hi,

    PostgresSQL is by default not supported as a global connection (unless you add a custom driver).
    Please start a Analytics project and check if you can add it from there:

    https://www.ibm.com/support/knowledgecenter/en/SSQNUZ_2.5.0/wsj/manage-data/conn_types.html

    Thanks



    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------



  • 3.  RE: CP4D - PostgreSQL Connection

    Posted Thu February 13, 2020 10:22 AM
    Thomasz - Thanks for the link. I am using an analytics project and I cannot create a  Postgres shared connection but I can create a Postgres Connection asset. I cannot tell but if this is a bug or implemented as part of a design. Could you please explain the differences? Please find the screenshots attached.

    Thanks!

    ------------------------------
    Geeta Rayarapu
    ------------------------------



  • 4.  RE: CP4D - PostgreSQL Connection

    Posted Fri February 14, 2020 04:56 AM

    Hi,

    At this point you will be able to add PostgreSQL connections to a project, but you can not Publish it as global catalog, unless you define is using custom JDBC connector.


    See below:



    The top connection uses PostgreSQL driver and can only be added to catalog (if you have WKC), the second connection is using JDBC PostgreSQL connector and can be used as a global connection.

    Thanks


    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------



  • 5.  RE: CP4D - PostgreSQL Connection

    Posted Fri February 14, 2020 05:27 PM
    This helped. Thanks!

    ------------------------------
    Geeta Rayarapu
    ------------------------------