Topic Thread

Expand all | Collapse all

CP4D - PostgreSQL Connection

  • 1.  CP4D - PostgreSQL Connection

    Posted 14 days ago
    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 12 days ago

    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 9 days ago
    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 8 days ago

    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 7 days ago
    This helped. Thanks!

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