back to the main page
New Product Integrates Data Faster, at Lower Cost—Even Across Heterogeneous Systems
Oracle has announced the general availability of Oracle Data Integrator—a high-performance data integration solution that enables organizations to quickly integrate massive volumes of data dispersed across mixed IT environments.
Oracle Data Integrator, a new component of the
Oracle Fusion Middleware, product family, is a key enabler for mission-critical business initiatives, including business intelligence and data warehousing; master data management; service-oriented architecture and business activity monitoring; and application migration and consolidation.
Based on technology from the recent Sunopsis acquisition, Oracle Data Integrator supports a heterogeneous technology environment and is natively optimized for interoperability with database, data warehouse, and packaged applications software from vendors that include IBM, Microsoft, Netezza, Sybase, Teradata, and Trillium.
From ETL to ELT for Better Performance and Lower Cost
Oracle Data Integrator eliminates the need for separate extract, transform, and load (ETL) servers by executing the transformation operations within the source system or target data warehouse. “You no longer have to install separate ETL servers to connect your various datasources,” says Ashish Mohindroo, director of product marketing at Oracle, “because now the capability in right there in the database.”
Oracle Data Integrator changes the ETL equation by using an innovative extract, load, and transform (ELT) technology. “Once Oracle Data Integrator is installed on the source database, you can decide whether you want to do the transformations within the source system or pull the data into the target system and do the transformations there,” says Mohindroo. This has several benefits. “There’s less chance of data corruption because you’re only moving the data once—you’re not moving it into an ETL server and then moving it again into the target system.”
Another benefit, says Mohindroo, is that you’ve saved money by not installing extra servers. “Those servers can become bottlenecks, so a company is forced to add more servers and the licenses that go with them. Oracle Data Integrator helps you avoid all of that cost.”
Knowledge Modules for Faster Development and Deployment
Oracle Data Integrator’s ELT technology comes with declarative, set-based modeling tools and more than 100 prepackaged code libraries called Knowledge Modules, which are reusable code libraries that capture highly optimized source for creating flows between major databases and packaged applications.
“You don’t have to start from scratch,” says Mohindroo. “If, for example, you’re pulling customer data out of IBM DB/2 as part of an order entry process and need to flow that data into Oracle, or Microsoft or others, you can use one of our prebuilt flows,” he says. “Think of them as building blocks. You can quickly build your flow to speed the process of development and deployment.”
Another benefit for developers is that Oracle Data Integrator is based on open technology such as SQL and Java. “Developers don’t have to learn the language of their ETL servers, they can reuse skills they already have,” says Mohindroo.
Batch Mode Speed, Real-Time Performance
Customers can continue to run gigabyte and terabyte batch synchronizations with no loss of performance. However, Oracle Data Integrator dramatically improves real-time data synchronization via its change data capture technology.
“Oracle Data Integrator lets you set a trigger that automatically captures a change to the database and pushes that change over to the source or target system,” say Mohindroo. “So let’s say an order gets entered into your system, you can quickly push that information to your partner system and look up the part in real time. Now you are able to make better decisions using totally up-to-date information.”
Customer Success Stories
Oracle customers, such as
Blue Cross Blue Shield, NCR, and Accenture Technologies, are realizing tremendous value with Oracle Data Integrator.
“We use Oracle Data Integrator for a variety of data integration tasks including real-time and batch operations that comprise several different RDBMS [relational database management system] technologies and a variety of file formats,” says Dan Vnuk of Nielsen Media Research. “The high-performance ELT architecture provides us with incredible scalability that seamlessly handles our 4TB data warehouse containing local and regional TV program ratings. ODI’s [Oracle Data Integrator’s] flexibility and extensibility are unique among vendors we evaluated, we are especially happy with our ability to extend packaged [Oracle Data Integrator] Knowledge Modules for automated code generation.”
Oracle Data Integrator is optimized to work with Oracle’s own database, application server, SOA suite, and business activity monitoring software.
Download
Oracle Data Integrator.
Learn more about
Oracle Data Integrator. |
