Hidden Gems: Accelerating Oracle Data Integrator with SOA, Groovy, SDK, and XML
- by Alex Kotopoulis
On the last day of Oracle OpenWorld, we had a final advanced session on getting the most out of Oracle Data
Integrator through the use of various advanced techniques.
The primary way to improve your ODI processes is to choose
the optimal knowledge modules for your load and take advantage of the optimized
tools of your database, such as OracleDataPump and similar mechanisms in other
databases. Knowledge modules also allow you to customize tasks, allowing you to
codify best practices that are consistently applied by all integration
developers.
ODI SDK is another very powerful means to automate and speed
up your integration development process. This allows you to automate Life Cycle
Management, code comparison, repetitive code generation and change of your
integration projects. The SDK is easily accessible through Java or scripting
languages such as Groovy and Jython.
Finally, all Oracle Data Integration products provide services
that can be integrated into a larger Service Oriented Architecture. This moved
data integration from an isolated environment into an agile part of a larger
business process environment. All Oracle data integration products can play a
part in thisracle GoldenGate can integrate into business
event streams by processing JMS queues or publishing new events based on
database transactions.
Oracle GoldenGate can integrate into business event streams
by processing JMS queues or publishing new events based on database
transactions.
Oracle Data Integrator allows full control of its runtime
sessions through web services, so that integration jobs can become part of
business processes.
Oracle Data Service Integrator provides a data
virtualization layer over your distributed sources, allowing unified reading
and updating for heterogeneous data without replicating and moving data.
Oracle Enterprise Data Quality provides data quality
services to cleanse and deduplicate your records through web services.
