A new PostgreSQL Connector is now available in the TIBCO Scribe Online Marketplace. This updated version supports PostgreSQL 17 and higher, as well as instances hosted on Amazon Aurora.

To distinguish between connectors, the original connector—which is based on the CData PostgreSQL ADO.NET provider—has been renamed to TIBCO Scribe® Online Connector for PostgreSQL (Legacy). 

The new PostgreSQL Connector facilitates seamless integration and data migration across enterprise systems, supporting both source and target operations within Integration Services. It offers advanced data retrieval through native SQL query execution and is fully compatible with both On-Premise and Cloud Agents.

How to Set Up New Connections to PostgreSQL?

Navigate to the Scribe Online Connector Marketplace 

1. Find the new PostgreSQL connector  in the Scribe Online Connector Marketplace
2. Click “Install” to add the connection type to your organization 

Set up a new connection to TIBCO Scribe® Online Connector For PostgreSQL

1. Select More > Connections from the menu.
2. From the Connections page, select Add + to open the Add a New Connection dialog.
3. Select the Connector from the dropdown list in the Connection Type field, and then enter the following information for this Connection:
   1. Name — This can be any meaningful name, up to 25 characters.
   2. Alias — An alias for this Connection name. The alias is generated from the Connection name, and can be up to 25 characters. The Connection alias can include letters, numbers, and underscores. Spaces and special characters are not accepted. You can change the alias. For more information, see Connection Alias.
   3. Host — IP address or URL of the target PostgreSQL server instance. Requires a valid IPv4 IP or URL address.
   4. Port — PostgreSQL server port number, which must be in the 1023 to 65535 range. The default value is 5432.
   5. Database — Name of the PostgreSQL database to which you want to connect.
   6. Username — Username for this PostgreSQL database instance.
   7. Password — Password for this Username. PostgreSQL databases do not require a password.
   8. Additional Properties — Optional field where you can specify one or more connection string parameters. See the See the Connection String Options section for a list of parameters that can be used and their default values.
      Syntax for the Additional Parameters field is as follows:
      1. Connection strings have the form keyword1=value; keyword2=value; and are case-insensitive.
      2. Values containing special characters (for example, semicolon (;)) can be double-quoted.
      3. All blank characters, except those within a value or within quotation marks, are ignored.
      4. Preceding and trailing spaces are ignored unless enclosed in single or double quotes, such as keyword=" value".
      5. Semicolons (;) within a value must be delimited by quotation marks.
      6. Use a single quote (') if the value begins with a double quote (").
      7. Use a double quote (") if the value begins with a single quote (').
      8. Parameters that are handled by other fields or default settings in the Connection dialog are ignored if used in the Additional Parameters field, including: 
         1. Host
         2. Port
         3. Database
         4. Username
         5. Password
4. Select Test to ensure that the Agent can connect to PostgreSQL. Be sure to test the Connection against all Agents that use this Connection. See Testing Connections.
5. Select OK/Save to save the Connection.

Reassign connection 

1. Open the Map with the Connection you want to reassign.
2. On the Connection panel, locate the Connection.
3. From the Gear menu for that Connection select Reassign. The Reassign Connection dialog displays.
4. Select a Connection from the drop-down list or select Create a New Connection.
5. Select OK to save your changes and close the dialog box.
6. Any references to the original Connection change to the new selected Connection. If the Entities and fields are identical, you do not need to make changes to the Block

Run Solution 

Check your solution is running properly with no unexpected errors.

This article explains the process of switching Connections to the new TIBCO Scribe PostgreSQL Connector 

For any issues, check the TIBCO Scribe Online Help Documentation or contact Support via support.tibco.com.