The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Import table from sql server/webex to vertica
parvesh
Community Edition User
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.
Tagged:
0
Comments
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.
Thank you Bryan..