ODI 11g and BIAPPS DW migration to Vertica

ashwinmalgaonkarashwinmalgaonkar
edited June 2019 in General Discussion

Hi,
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.

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...