e., insert or update depending
on whether a data item exists), multitable inserts, change data capture, and resumable
statements. Today, OWB can be used to leverage this functionality. Additionally,
OWB can create trickle feeds through the use of Streams and Advanced Queues.
For ETL into both Oracle databases and non-Oracle targets, Oracle offers a product
named Oracle Data Integrator (ODI). This product was acquired in 2007 and was
formerly known as Sunopsis. ODI features Knowledge Modules that define integration
capabilities including extraction with change data capture, loading and
unloading utilities, SQL-based loading and unloading, and transformation logic SQL.
The Knowledge Modules are modifiable. The product architecture includes a development
environment that makes use of the Knowledge Modules as templates in
declarative design processes and an orchestration agent.
In addition to providing heterogeneous ETL, ODI can be used to deploy and integrate
data and transformation services in a Service-Oriented Architecture (SOA)
infrastructure.
Pages:
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532