How to Migrate Oracle tables to Vertica DB

Siva_Ram

Prasanta_Pal

There are posts on this, you may check http://community.vertica.com/vertica/topics/how_to_migrate_oracle_tables_to_vertica_db

Prasanta_Pal

Anotherway, in vertica create a external Stored Procedure ( which is nothing but a .sh ( shell scripts)). This shell script can connect to Oracle and pull the records and use COPY command in the script to load to Vertica.

abira

is there any way to migrate oracle data to vertica using squirrel or any other tool?? plz 

Adrian_Oprea_1

Your question is very generic ! 

I think you should choose one tool and ask how you can migrate using that tool ! ? 

Give it a try first on your own then start asking ! 

Eg : some etl tool(Pentaho,Talend,Syncsort DMExpress)