Extracting data from Oracle database..

Can anyone suggest how to extract data from oracle and load into vertica database..
vgprakash4u's picture
Joined: Jan 30 2008 - 5:12pm
Last seen: 15 years 2 days ago

1 Answer:

JasperETL has supported extracting data out of Oracle since it was first released with components like "tOracleInput". Support for Vertica with components like "tVerticaOutput" and "tVerticaOutputBulk" are new in JasperETL 2.3.0. Of course even with older versions of JasperETL it was possible to load Vertica using a standard JDBC component, but the new tools make it easier.

That's the high-level answer. If you have specific issues using any of these components, please start a new thread and we'll see if we can help out.

mdahlman's picture
Joined: Mar 13 2007 - 2:43am
Last seen: 8 years 2 months ago