Thursday, January 24, 2008

Data Integrator

We are presently working on integration of heterogeneous systems. I was searching for a tool which will meet our requirements. Of course, the entire work can be done in SQLLoader too. But still I had to satisfy myself that SQLLOADER is THE answer.
One of the tools I came across was the Oracle Data Integrator.
This appears to be a regular ETL tool with oracle-specific features built-in. I have decided to explore further about this product.
Features I like about this product (of course I would probably find many of the features in the competitors too, But still it is worth exploring):
  • Automatic code generation (reduces learning curve)
  • User/Developer specifies the rules to apply to the integration processes.
  • Hooks to SOA
  • Library of Knowledge Modules (including one for Salesforce.com)
Getting the right data in the right place at the right time is the key to a successful data integration strategy. Are I going have a hourly/periodic updates from the source; if so, how complex will it be to maintain the program generated?
Will be posting more details later.

Friday, January 11, 2008

Thought of the day

"If you want to be irreplaceable, you have to be different."
Gabrielle 'Coco' Chanel