Manage your Vertica data in Oracle with Talend

Vertica offers two lines of analytics data warehouse based on massively scalable architecture. Vertica in Enterprise Mode runs on data center servers with tightly coupled storage, while Vertica in Eon Mode has a cloud-native architecture that separates compute from storage. The company, formerly part of HP Enterprise, is now owned by Micro Focus. Manage Vertica data in Oracle with Talend's suite of data integration tools.

Connecting to Vertica

To connect to Vertica, use the tVerticaConnection component. Enter the database type and version, host name and port, database and schema names, and username and password.

Learn more about connecting to Vertica

More about integrating Vertica data

Talend has detailed documentation on how to ETL your Vertica data for a better view of the business.

Connecting to Oracle

Oracle provides a proprietary multi-model database management system commonly used for running online transaction processing, data warehousing and mixed database workloads.

Talend offers a native Oracle connector so you only have to set up your integration once, and any future management of the connection is made easy. Once you connect to your Oracle database, you can do the following actions on your tables:

  • Write, update, make changes or suppress entries in an Oracle database.
  • Write a file with columns based on the defined delimiter and the Oracle standards.
  • Check Oracle database rows against specific data quality patterns (regular expression) or data quality rules (business rules).
  • Execute a SQL query on a specified Oracle database.
  • Call an Oracle database stored procedure.

Get more from your Vertica data

Deliver data your organization can trust... Get started today.

Explore Talend's full suite of apps