Skip to main content

Import table from sql server/webex to vertica

  • April 17, 2022
  • 2 replies
  • 6 views

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.

2 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • April 17, 2022

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
  • Author
  • New Participant
  • April 18, 2022

Thank you Bryan..