Introduction to Oracle Data Integrator:
1.ODI(Oracle Data Integrator) is a Widely used data integration software product.
2.ODI Provides a new design approach to Defining data transformation and integration process and provide results with faster and simpler development and maintenance.
3.ODI is based on unique E-LT architecture (Extract - Load Transform),
4.It Provides high performance for execution of data transformation and validation process and it is very cost effective.
Why to choose ODI:
•Faster and simpler development and maintenance: The declarative rules driven approach to data integration greatly reduces the learning curve of the product and increases developer productivity while facilitating ongoing maintenance.
•Data quality firewall: Oracle Data Integrator ensures that faulty data is automatically detected and recycled before insertion in the target application. This is performed without the need for programming, following the data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.
•Better execution performance: traditional data integration software (ETL) is based on proprietary engines that perform data transformations row by row, thus limiting performance. By implementing an E-LT architecture, based on your existing RDBMS engines and SQL, you are capable of executing data transformations on the target server at a set-based level, giving you much higher performance.
Simpler and more efficient architecture: The E-LT architecture removes the need for an ETL Server sitting between the sources and the target server. It utilizes the source and target servers to perform complex transformations, most of which happen in batch mode when the server is not busy processing end-user queries.
•Platform Independence: Oracle Data Integrator supports all platforms, hardware and OSs with the same software.
Data Connectivity: Oracle Data Integrator supports all RDBMSs including all leading Data warehousing platforms such as Oracle, Exadata, Teradata, IBM DB2, Netezza, Sybase IQ and numerous other technologies such as flat files, ERPs, LDAP, XML.
• Cost-savings: the elimination of the ETL Server and ETL engine reduces both the initial hardware and software acquisition and maintenance costs. The reduced learning curve and increased developer productivity significantly reduce the overall labor costs of the project, as well as the cost of ongoing enhancements.
2.ODI Provides a new design approach to Defining data transformation and integration process and provide results with faster and simpler development and maintenance.
3.ODI is based on unique E-LT architecture (Extract - Load Transform),
4.It Provides high performance for execution of data transformation and validation process and it is very cost effective.
Why to choose ODI:
•Faster and simpler development and maintenance: The declarative rules driven approach to data integration greatly reduces the learning curve of the product and increases developer productivity while facilitating ongoing maintenance.
•Data quality firewall: Oracle Data Integrator ensures that faulty data is automatically detected and recycled before insertion in the target application. This is performed without the need for programming, following the data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.
•Better execution performance: traditional data integration software (ETL) is based on proprietary engines that perform data transformations row by row, thus limiting performance. By implementing an E-LT architecture, based on your existing RDBMS engines and SQL, you are capable of executing data transformations on the target server at a set-based level, giving you much higher performance.
Simpler and more efficient architecture: The E-LT architecture removes the need for an ETL Server sitting between the sources and the target server. It utilizes the source and target servers to perform complex transformations, most of which happen in batch mode when the server is not busy processing end-user queries.
•Platform Independence: Oracle Data Integrator supports all platforms, hardware and OSs with the same software.
Data Connectivity: Oracle Data Integrator supports all RDBMSs including all leading Data warehousing platforms such as Oracle, Exadata, Teradata, IBM DB2, Netezza, Sybase IQ and numerous other technologies such as flat files, ERPs, LDAP, XML.
• Cost-savings: the elimination of the ETL Server and ETL engine reduces both the initial hardware and software acquisition and maintenance costs. The reduced learning curve and increased developer productivity significantly reduce the overall labor costs of the project, as well as the cost of ongoing enhancements.
No comments:
Post a Comment