Spanish English German Portuguese
Spanish English German Portuguese

Amazon Redshift Sink Connector

Amazon Redshift Sink Connector

att_0_for_1848017466.png

Connector to send datasets, tables, and analytical data from GlobalSuite to Amazon Redshift or to the defined target system.

Tags: Data Warehouse | Cloud | Sink

Tool or system

Amazon Redshift

Tool manufacturer

Amazon Web Services

Connector provider

Confluent, Inc

Connector name

Amazon Redshift Sink Connector

Connector type

Sink

Tags

Data Warehouse | Cloud | Sink

Information it handles

datasets, tables, and analytical data

Details

The Amazon Redshift Sink Connector allows sending information related to datasets, tables, and analytical data from GlobalSuite to Amazon Redshift.

It is useful when Amazon Redshift needs to act as a target system, exploitation, archive, or monitoring for executive reporting cases, risk dashboards, data consolidation, and historical analytics.

Features

  • Controlled sending of datasets, tables, and analytical data from GlobalSuite to Amazon Redshift or to the defined target repository.

  • Preparation of datasets for reporting, dashboards, historical analysis, or business intelligence.

  • Mapping of tables, schemas, fields, or partitions according to the agreed analytical model.

  • Support for incremental or periodic loads to keep exploitation data up to date.

  • Separation between operational information and analytical layer to facilitate governance and performance.

Key benefits

  • Allows exploiting data from GlobalSuite and related systems in BI and analytics tools.

  • Accelerates the creation of executive dashboards on risks, compliance, auditing, or operations.

  • Reduces dependency on manual extractions for recurring reporting.

  • Facilitates historical analysis, comparisons, and trend tracking.

  • Helps separate daily operational management from the analytical layer used by management and reporting.

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 Amazon Redshift Sink Connector.

  2. Configure the target in Amazon Redshift: URL or endpoint, credentials, permissions, and environment.

  3. Define what information will be sent: datasets, tables, and analytical data, 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://aws.amazon.com/redshift/

Use this connector when you need to send information from GlobalSuite to Amazon Redshift, for example, for executive reporting, risk dashboards, data consolidation, and historical analytics. Before publishing it, validate with the team responsible for the target system the expected format, permissions, frequency, and quality criteria.