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!
HP Vertica Connectivity with IBM Infosphere Datastage
I was creating a proposal for one of the potential clients. The ETL tool currently being used by the client is IBM Infosphere Datastage which is a leading integration tool. I was looking at various forum on connectivity of HP Vertica with Data Stage; and found a few posts that specify odbc connectivity.
I believe odbc connectivity is always slower than jdbc and have several constraints attached. Is there any possibility of connecting using JDBC and do Vertica have any specific components for connectivity in IBM Infosphere Datastage.
Syed Asif Tanveer
I'm with the same team as OP is.
Just to help others who havn't figured it out yet;
Here is the document that will help you connect Datastage to Vertica.