Import table from sql server/webex to vertica

parvesh

Hi,

This is parvesh and I am facing issue while importing a table from sql server to vertica.. I am unable to do it.. please help me how can I import/pull a table from sql server/webex to vertica.

Bryan_H

There are a few options:
Vertica is a support data target in SQL Server Integration Services. This allows use of Microsoft tools to move data to Vertica. Please see https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/ConnectingToVertica/InstallingDrivers/Windows/SSIS.htm
It's also possible to copy data with any ETL tool that can use the Vertica ODBC or JDBC driver. Please see a list of technology partners at https://www.vertica.com/knowledgebase/?category=partner-integration though we can support many other OSS and commercial pipelines not listed here.
Another option is to export the DDL from SQL Server, export data to CSV or Parquet, then create DDL in Vertica, import CSV or Parquet using COPY statement.

parvesh

Thank you Bryan..