odiRef and snpRef object instances are synonymous. snpRef syntax are legacy syntax which are now deprecated as you all know oracle didn't build ODI from scratch it acquired from Sunopsis and during enhancement oracle changed snpRef to odiRef.
Wednesday, 2 October 2013
Sunday, 25 August 2013
What are Knowledge Modules?
Knowledge Modules:
KM are referred as Code Template which helps in overall Data Integration Process with the help of the Metadata from Interface and Models Km Executes Relevent Code Generated by ODI .
There are predefined set of KM which covers almost all the DB types and scenario in ODI .KM are Customizable so no need to fear if there is any KM Missing for DB or Scenario.
KM are classified in following types
KM are referred as Code Template which helps in overall Data Integration Process with the help of the Metadata from Interface and Models Km Executes Relevent Code Generated by ODI .
There are predefined set of KM which covers almost all the DB types and scenario in ODI .KM are Customizable so no need to fear if there is any KM Missing for DB or Scenario.
KM are classified in following types
What systems can ODI extract and load data into?
Types Of System ODI can Extract:
Man ODI can handle a lot of system which you would have never thought of.
As the Matter of Fact ODI has ability to connect to More than 30+ DB.
Its True ODI has out of Box Heterogeneous Connectivity to Many Important DB listed below..
Man ODI can handle a lot of system which you would have never thought of.
As the Matter of Fact ODI has ability to connect to More than 30+ DB.
Its True ODI has out of Box Heterogeneous Connectivity to Many Important DB listed below..
Wednesday, 21 August 2013
What is Oracle Data Integration Suite?
Oracle Data Integration Suite (ODI Suite) is a collection of
Oracle's Best data integration technologies. ODI Suite enables enterprise data architects to unify, manage,
and distribute data into enterprise applications.
Important data integration services are:
For Further Reference:
ODI SUITE PDF :
www.oracle.com/us/products/middleware/059491.pdf
Important data integration services are:
- Data distribution and delivery
- Data transformation and migration
- Master data management, work-flow and governance
Components
ODI Suite has the following components:- Oracle Data Integrator (ODI)
- Oracle Data Relationship Management
- Oracle Data Quality and Data Profilerfor Data Integrator
- Oracle BPEL Process Manager
- Oracle Service Bus(OSB)
- Oracle Application Server Enterprise Edition
- Oracle Coherence In-Memory Data Grid
- Oracle Integration Adapters
For Further Reference:
ODI SUITE PDF :
www.oracle.com/us/products/middleware/059491.pdf
ETL VS ELT
what is the difference between ETL and ELT ?
ETL
The transformations are processed by the ETL tools (Informatica , Datastage etc) while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
So the important thing to remember is the side where the transformations are processed.
I made the following schema to help remember the difference :
ELT
ETL
The transformations are processed by the ETL tools (Informatica , Datastage etc) while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
So the important thing to remember is the side where the transformations are processed.
I made the following schema to help remember the difference :
ELT
What Is Oracle Data Integrator (ODI) ?
Oracle Data Integrator (ODI):
Oracle’s ELT tool, is a unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs even across heterogeneous systems. It can be used to extract data from a variety of data sources (relational databases, flat files, etc.), perform complex data transformations, and load data into a variety of target data stores (data warehouses, application databases, flat files, etc.). ODI can be used to support a variety of data integration projects, including the following:
Oracle Data Integrator Download
ODI can be downloaded directly from Oracle’s website. Follow the link below for a free trial download of ODI. Be cautious these available links below are not to be used in Production Environment.
ODI Resources
Oracle’s ODI page is the first page where u can find Loads of DATA on ODI features, Getting started guides, and ODI documentation.
If you have a any doubts about ODI, or if you want to acquaintance with other fellow ODI developers, check out the Oracle forums.
Another good resource is the official Oracle Data Integrator Blog.
Oracle’s ELT tool, is a unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs even across heterogeneous systems. It can be used to extract data from a variety of data sources (relational databases, flat files, etc.), perform complex data transformations, and load data into a variety of target data stores (data warehouses, application databases, flat files, etc.). ODI can be used to support a variety of data integration projects, including the following:
- Business Intelligence and Data Warehousing
- Data Migrations and Data Consolidations
- Master Data Management
Oracle Data Integrator Download
ODI can be downloaded directly from Oracle’s website. Follow the link below for a free trial download of ODI. Be cautious these available links below are not to be used in Production Environment.
ODI Resources
Oracle’s ODI page is the first page where u can find Loads of DATA on ODI features, Getting started guides, and ODI documentation.
If you have a any doubts about ODI, or if you want to acquaintance with other fellow ODI developers, check out the Oracle forums.
Another good resource is the official Oracle Data Integrator Blog.
Subscribe to:
Posts (Atom)