Spanish English German Portuguese
Spanish English German Portuguese

Vertica Analytics Platform Sink Connector

Vertica Analytics Platform Sink Connector

att_0_for_1847918887.png

Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives.

Tags: Integration | Sink | Data Warehouse | Databases

Tool or system

Vertica Analytics Platform

Tool manufacturer

Vertica

Connector provider

Vertica

Connector name

Vertica Analytics Platform Sink Connector

Connector type

Sink

Tags

Integration | Sink | Data Warehouse | Databases

Information it handles

datasets, tables, and analytical data

Details

The Vertica Analytics Platform Sink Connector allows sending information related to datasets, tables, and analytical data from GlobalSuite to Vertica Analytics Platform.

It is useful when Vertica Analytics Platform needs to act as a destination, exploitation, archive, or monitoring system for executive reporting cases, risk dashboards, data consolidation, and historical analytics.

Features

  • Controlled sending of datasets, tables, and analytical data from GlobalSuite to Vertica Analytics Platform or the defined destination 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 Vertica Analytics Platform Sink Connector.

  2. Configure the destination in Vertica Analytics Platform: 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://www.vertica.com/

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