Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How do I stream data using ODBC?

Am trying to get my data into Vertica database and am unclear on steps to do so.


  • You can use batch inserts from ODBC to stream data, as with COPY statements.Or, if your data is already in a file on the client, use COPY LOCAL. COPY and COPY LOCAL are described in the HP Vertica documentation, in the SQL Reference Manual. Also, see the HP Vertica Programmer's Guide section: Programming ODBC Client Applications > Loading Data through ODBC

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.