Manage your Vertica data in SQL Server 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 SQL Server 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 SQL Server

SQL Server is a popular relational database management system created by Microsoft.

Connect to your Microsoft SQL Server database with our native connector and easily carry out the following actions on your data:

  • Write, update, make changes or suppress entries defined on a table and/or on the data contained in a table
  • Prepare a file to be used as parameter in an INSERT query to feed a MS SQL database.
  • Execute a SQL query stated onto a specified Microsoft SQL Server or Azure SQL database.
  • Offer a convenient way to centralize multiple or complex queries in a database and calls them easily.

Get more from your Vertica data

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

Explore Talend's full suite of apps