Total Pageviews

Tuesday, October 18, 2016

Oracle Data Integrator (ODI)

                                                  
                                     Oracle Data Integrator (ODI)

ODI is the best Integration tool for one-time Historical Data Migration.

                          
                                  Pros.- ODI
1
Ideal tool for one-time data loads to applications.
2
Transforming large volume of data efficiently.
3
Supports different types of source and target systems.
4
Useful for loading metadata to the Hyperion applications.

                          
                                 Cons.- ODI
1
License cost is high.
2
Great technical tool but not at all user friendly.
3
ODI processes will run in the background.
4
No audit trail support.

No comments:

Post a Comment