Clarity PPM

Expand all | Collapse all

Connect to Postgres SQL using GEL Script?

Jump to Best Answer
  • 1.  Connect to Postgres SQL using GEL Script?

    Posted 01-21-2020 03:54 PM
    Hi everybody.
    We have this system that contains a list of Supplier Companies, but is installed in Postgress SQL database.
    We need to read and import the external company list using SQL commands into Clarity.
    Is it possible to do it via GEL Script?
    Do I need an additional Java/Postgres library to install in Clarity?

    Thank you
    Juan


  • 2.  RE: Connect to Postgres SQL using GEL Script?
    Best Answer

    Posted 01-22-2020 06:26 AM
    Starting with 15.7.1 the postgresql jdbc thin driver has been included in the Clarity /lib folder.  It is, at this time, the generic postgresql driver and not (for example) a licensed datadirect driver as the Oracle / MSSQL ones have been until now.

    If you are on-premises and not yet on Clarity 15.7.1 then as the following documentation states, you can place the jdbc driver jar files yourself into the classpath (e.g. the /customlib folder of Clarity) and then create your datasource in GEL with the applicable jdbc url:
    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-7/reference/xml-open-gateway-xog-development/xog-gel-scripting/xog-gel-tag-library/xog-sql-tag-library.html