You can configure an SQL transformation in a PostgreSQL mapping to process stored functions in PostgreSQL.
To process a stored function in PostgreSQL, complete the following prerequisite steps:
•Configure the JDBC driver from the latest folder for PostgreSQL Connector. For more information about configuring the JDBC driver, see Configure the JDBC driver for PostgreSQL Connector Knowledge article.
•Set the POSTGRESQL_ENABLESTOREDFUNCTION custom property in the Secure Agent properties.
To configure the custom property in the Secure Agent, perform the following steps:
1Log in to Informatica®Intelligent Data Management Cloud™ (IDMC).
2Select Administrator > Runtime Environments.
3On the Runtime Environments page, select the Secure Agent.
4Click Edit.
5In the Custom Configuration Details section, select Data Integration Server as the service and Tomcat JRE as the type.
6Enter POSTGRESQL_ENABLESTOREDFUNCTION in the Name field and set the value to true.