We have discussed each product in detail and provided use cases to help guide you as you move towards a more current information integration architecture. Before we end this chapter, we believe that providing you with a matrix will help in your decision making.
Product |
Data or App-centric |
SQL, CLI or Java-based API |
Data replication |
Trans formations |
DB or Fusion family |
Initial data load capable |
When to use |
---|---|---|---|---|---|---|---|
SQL Loader |
Data |
SQL, CLI |
No |
Yes |
DB |
Yes |
Data migration |
OWB |
Data |
SQL, PL/SQL |
Yes |
Yes |
DB |
Yes |
Data migration |
Migration Workbench |
Data |
SQL, CLI |
No |
Yes |
DB |
Yes |
Data migration |
ODI |
Data |
SQL |
Yes |
Yes |
Fusion |
Yes |
Data migration, Data integration |
Performance and Tuning Packs |
Data |
SQL |
n/a |
n/a |
DB |
n/a |
Data migration |
GoldenGate |
Data |
CLI |
Yes |
Yes |
Fusion |
Yes |
Data integration |
CDC Adapters |
Data |
Java |
Yes |
No |
Fusion |
No |
Data integration |
MDM |
Data |
Java |
Yes |
Yes |
DB |
Yes |
Information federation |
Data Quality & Profiling... |