ODI 11g and BIAPPS DW migration to Vertica
I am trying a POC to migrate our Oracle BIAPPS DW to Vertica.
So I want to point our existing ODI BIAPPS ELT to-
1) read from vertica (from replicated EBS tables)
2) and write to vertica.
I have been able to create Vertica connection but I want to change technology of BIAPPS DW model to Vertica, so that existing ELT interfaces can be pointed to Vertica with minimal development.
Can someone please provides some inputs , if this has been tried out and what would be the steps to do it. Also if it is not possible with ODI11g would upgrading ODI to 12C help in achieving this.