Does DataStage works well with Vertica?

12 years ago
Sep 16, 2014 3:26 AM UTC
7 replies
23 views

Oleg_Savkin
Participating Frequently

Does anyone use DataStage to load data in Vertica? What connection has been used? How fast is the load comparing with Vertica's COPY?
What other ETL tool would you suggest to use with Vertica?

Navin_C
Participating Frequently
12 years ago
Sep 16, 2014 1:43 PM UTC

Hi Oleg,

>>Does anyone use DataStage to load data in Vertica
DataStage works good with Vertica.
Any ETL works good with Vertica.

>>What connection has been used?
Connections that can be used are JDBC or ODBC.
I prefer JDBC over ODBC when it comes to ETL talking with databases.

>> How fast is the load comparing with Vertica's COPY?
In any case, Vertica's COPY command is the fastest way to load data.
COPY is meant for bulk loading and it is file to db loading, whereas ETL can help you with Source to Target Loading.
But for sure in both case COPY will be ahead in terms of time.

>>What other ETL tool would you suggest to use with Vertica?
Two good options.
1. Informatica :
Vertica provides a native connector for informatica tool.
A native connector means special support for the ETL tool which is always above the ODBC or JDBC connection and is faster.
2. Syncsort: (Don't get surprised)
Syncsort holds a world record for loading maximum data with Vertica.
Syncsort and Vertica

Hope this helps.
NC

Oleg_Savkin
Author
Participating Frequently
12 years ago
Sep 17, 2014 6:29 AM UTC

Thanks Navin. Will check Syncsort, never knew before

Arun_s
New Participant
10 years ago
May 23, 2016 1:25 AM UTC

Hi ,

I used Datastage to insert and select data from vertica using ODBC driver and connector. But when i started performing update / delete for 100 records its taking 2 minutes. The same is taking seconds in VSQL. Please help.