A widely used data integration
software product, Oracle data Integrator provides a latest declarative layout
method to defining data transformation and integration techniques, resulting in
quicker and much less complicated development and maintenance. primarily based
on a completely unique E-LT structure (Extract - Load transform), Oracle data
Integrator now not simplest ensures the great degree of usual performance
feasible for the execution of data transformation and validation methods
however is also the most price-powerful solution to be had in recent times.
Some of the important issue abilities and
advantages of ODI:
Declarative format data
first-rate firewall
ELT shape
• Higher execution usual overall performance
• Simpler and greater efficient architecture
• Rate-economic savings
Hot Pluggable - data
Connectivity
Real-Time data Warehousing -
lively Integration Platform
Information Modules architecture
Declarative format
Traditional “Extract, redesign
and load” (ETL) tools carefully intermix data transformation hints with the
integration process method, requiring the improvement of each:
• Data transformation
• And data go along with the flow
 |
| Oracle ODI Online Training |
ODI-EE take an extraordinary
method to integration through truly preserving apart the declarative rules (the
“what”) from the data flows (the “how”). With ODI-EE, declarative regulations
describing mappings and differences are defined graphically and stored
independently from the implementation.
Data integration designers
describe supply and goal information formats and data integration strategies. The
commercial corporation individual or the developers can recognition on
describing what to do, no longer the manner to do it. ODI EE then generates,
deploys and manages the code required to put into effect those methods at some
stage in the numerous supply and goal systems.
Oracle data Integrator organization
model moreover offers superior ETL abilities which encompass:
• loading slowly changing dimensions,
• Complicated data integration method flow right judgment,
• Re-usable mappings,
• And format-time automation through scripting.
Oracle data Integrator
enterprise version includes incorporated dimensional modeling gear to simplify
Oracle data Warehouse integration implementations.
Data first-class firewall:
Oracle information Integrator ensures that faulty data is mechanically detected
and recycled earlier than insertion in the aim software. this is finished without
the want for programming, following the data integrity policies and constraints
described every at the target utility and in Oracle data Integrator.
ELT shape:
Higher execution performance:
conventional ETL software is based totally on proprietary engines that perform data
alterations row via row, consequently restricting overall performance. by
imposing ETL structure, based totally for your modern RDBMS engines and square,
you're able to executing data differences at the goal server at set based
degree supplying you with a fantastic deal better standard overall performance.
Simpler and greener architecture:
ETL structure removes the want for an ETL hub server sitting among the sources
and the goal server. It uses the target server and its RDBMS to carry out
complex changes, most of which take area in batch mode at the same time as the
server is not busy processing give up-customer queries. Platform Independence:
Oracle data Integrator supports all structures, hardware and OSs with the same
software.
Cost-economic financial savings:
The elimination of the ETL hub server and ETL engine reduces both the
preliminary hardware and software program acquisition and preservation costs.
The reduced reading curve and multiplied developer productivity extensively
reduce the overall hard paintings expenses of the undertaking, in addition to
the fee of ongoing upgrades.
Hot Pluggable-data Connectivity:
Oracle data Integrator corporation model gives heterogeneous help for 3rd party structures, information assets, and information
warehousing home system. Even as Oracle information Integrator organization
model leverages optimizations for Oracle Database to carry out EL-T data
motion, transformation, data exceptional and standardization operations, Oracle
data Integrator corporation edition is nicely matched with combined targets,
sources and application.
Oracle data Integrator helps all
RDBMSs which encompass all leading data Warehousing systems including Teradata,
IBM DB2, Netezza, Oracle, Sybase IQ and severe other technologies along with
flat documents, ERPs, LDAP, XML.
