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