Spanish English German Portuguese
Spanish English German Portuguese

PostgreSQL Sink (JDBC) Connector

PostgreSQL Sink (JDBC) Connector

att_0_for_1848017425.png

Connector to send records, tables, collections, and data changes from GlobalSuite to PostgreSQL (JDBC) or to the defined target system.

Tags: Databases | Sink | Cloud

Tool or system

PostgreSQL (JDBC)

Tool manufacturer

PostgreSQL Global Development Group

Connector provider

Confluent Cloud

Connector name

PostgreSQL Sink (JDBC) Connector

Connector type

Sink

Tags

Databases | Sink | Cloud

Information it handles

records, tables, collections, and data changes

Details

The PostgreSQL Sink (JDBC) Connector allows sending information related to records, tables, collections, and data changes from GlobalSuite to PostgreSQL (JDBC).

It is useful when PostgreSQL (JDBC) must act as a target system, exploitation, archive, or monitoring for cases such as catalog synchronization, change auditing, regulatory reporting, and elimination of manual uploads.

Features

  • Controlled sending of records, tables, collections, and data changes from GlobalSuite to PostgreSQL (JDBC) or to the defined target repository.

  • Selection of tables, collections, views, or fields to synchronize only information with functional value.

  • Support for additions, modifications, and deletions when the source or target system allows it.

  • Mapping of keys, fields, and entities to maintain consistency with corporate catalogs and inventories.

  • Traceability of changes and results for auditing, reconciliation, and data quality control.

Key benefits

  • Keeps catalogs, inventories, and critical records synchronized with less manual intervention.

  • Reduces errors due to duplication or misalignment between databases and GlobalSuite processes.

  • Facilitates change auditing, information reconciliation, and regulatory reporting.

  • Allows incorporating operational information into the GRC flow without waiting for specific exports.

  • Improves data quality by working with structured sources and defined mapping rules.

Installation

Configuration note: Before activating the integration, validate credentials, permissions, functional scope, and a data test with the responsible area.

  1. Access the GlobalSuite® Marketplace and select PostgreSQL Sink (JDBC) Connector.

  2. Configure the target in PostgreSQL (JDBC): URL or endpoint, credentials, permissions, and environment.

  3. Define what information will be sent: records, tables, collections, and data changes, filters, format, and periodicity.

  4. Map the fields from GlobalSuite to the structure expected by the target system.

  5. Run a test, review the reception at the destination, and activate the integration.

More information

https://docs.confluent.io/kafka-connectors/jdbc/current/

Use this connector when you need to send information from GlobalSuite to PostgreSQL (JDBC), for example, for catalog synchronization, change auditing, regulatory reporting, and elimination of manual uploads. Before publishing it, validate with the team responsible for the target system the expected format, permissions, frequency, and quality criteria.