Connect to Postgres SQL using GEL Script?

[Juan Vizcarra]

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

[Nick Darlington]

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