Does DataStage works well with Vertica?

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

Thanks Navin. Will check Syncsort, never knew before

Take away ... Vertica understands ODBC, JDBC, OLEDB, ADO.NET, etc

See:

https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ConnectingToVertica/ClientDriverMisc/HPVerticaClientLibraryOverview.htm

We offer the best platform.

Here's an article on our Knowledge Base about connecting to DataStage:

https://my.vertica.com/kb/DataStageCG_HTML/Content/Partner/DataStageCG_HTML.htm