ENTERPRISE EDITION Oracle Data Integrator Enterprise Edition delivers high-performance data movement and transformation among enterprise platforms with its open and integrated E-LT architecture. Oracle Data Integrator Enterprise Edition is critical to leveraging data integration initiatives on-premises or in the cloud, Service Oriented Architecture and Business Intelligence. An easy-to-use user interface combined with a rich extensibility framework helps Oracle Data Integrator Enterprise Edition improve productivity, reduce development costs, and lower total cost of ownership among data-centric architectures. Oracle Data Integrator Enterprise Edition is fully integrated with Oracle Fusion Middleware, Oracle GoldenGate, Oracle Database and Exadata to put data at the centre of your enterprise. Oracle Data Integrator Enterprise Edition is open and standards-based to work with 3rd party applications as well as Oracle’s applications.
About Oracle’s Data Integration Solutions
Oracle is a leader in the Data Integration market, with the industry’s most comprehensive fully integrated offering for data integration, including Oracle Data Integrator Enterprise Edition, Oracle Data Transforms, Oracle GoldenGate and Oracle Enterprise Data Quality. Oracle’s Data Integration solutions provide continuous access to timely, trusted, and heterogeneous data across the enterprise to support both analytical and operational data integration.
Key Features • Out-of-box integration with 100+ databases and applications, flat files, XML, JSON, LDAP, JDBC.
• Knowledge module framework for extensibility.
• Powerful data transformation for heterogeneous databases and applications. Both on premises and on multi- cloud.
• Rich ETL for Oracle databases including Oracle Exadata, with complex dimension and cube loading support.
• Integrates with Oracle GoldenGate for real-time data warehousing.
• Integrates with Oracle Enterprise Data Quality for advanced profiling, cleansing, matching and data governance needs.
• Easy deployment on OCI and a migration path to cloud native service Data Transforms.
1 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
What’s new in 14c? These are the new features included in Oracle Data Integrator Enterprise Edition 14c.
• Lots of new connectors (100+) are included in 14c for databases and applications. ODI 14.1.2.0.0 includes support for many new technologies that work with Progress JDBC drivers.
• Oracle WebLogic Server now uses the secured production mode by default. Version 14.1.2.0.0 onwards ODI configurations that rely on WebLogic Server such as the agents now run in secured mode.
• Oracle Data Integrator (ODI) version 14.1.2.0.0 onwards the use of Jython scripting is deprecated and only used for backward compatibility. ODI uses Graal VM Python as the replacement for Jython. The set of KMs that ODI provides are all converted to use Python scripting. Oracle recommends that you move all existing KMs that were written in Jython to Python. Use Python scripting to write any new custom procedures.
• Edition-based redefinition (EBR) is an Oracle Database feature that allows you to upgrade components with zero downtime. Oracle Data Integrator (ODI) 14.1.2.0.0 supports the use of EBR for upgrading database objects.
Data Integration Use Cases
Oracle Data Integrator Enterprise Edition addresses multiple enterprise data integration needs.
• Data Warehousing and Business Intelligence—by executing high-volume, high- performance loading of data warehouses, data marts, Online Analytical Processing (OLAP) cubes, and analytical applications, Oracle Data Integrator transparently handles incremental loads and slowly changing dimensions, manages data integrity and consistency, and analyses data lineage. • Service-Oriented Architecture (SOA)—by calling on external services for data integration and by deploying data services and transformation services that can be seamlessly integrated within an SOA infrastructure. Oracle Data Integrator’s architecture additionally provides support for high-volume, high-performance bulk data processing to an existing service-oriented architecture. • Master Data Management (MDM)—by providing a comprehensive data synchronization infrastructure for customers who build their own data hubs, work with packaged MDM solutions, or coordinate hybrid MDM systems with integrated SOA process analytics and Business Process Execution Language (BPEL) compositions. • Migration—by providing efficient bulk load of historical data (including complex transformations) from existing systems to new ones. Oracle GoldenGate then seamlessly synchronizes data for as long as the two systems coexist, and Oracle Data Integrator continues to complement as needed for transformations.
E-LT Architecture for High Performance
Oracle Data Integrator Enterprise Edition’s Extract, Load, Transform (E-LT) architecture leverages disparate relational database management systems (RDBMS) to process and transform the data. This approach optimizes performance and scalability and lowers overall solution costs.
Instead of relying on a separate, conventional ETL transformation server, Oracle Data Integrator Enterprise Edition’s E-LT architecture generates native code for disparate RDBMS. The E-LT architecture extracts data from the disparate sources, loads it into a target, and executes transformations using the power of the database. By leveraging existing databases, Oracle Data Integrator Enterprise Edition provides unparalleled efficiency and lower cost of ownership. By reducing network traffic and transforming data in the server containing the target data, the E-LT architecture delivers the highest possible performance.
2 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
Heterogeneous Support Oracle Data Integrator Enterprise Edition provides heterogeneous support for 3rd party database and applications. While Oracle Data Integrator Enterprise Edition leverages optimizations for Oracle Database to perform E-LT data movement, transformation, data quality and standardization operations, Oracle Data Integrator Enterprise Edition is fully optimized for mixed technologies including sources, targets, and applications, etc.
Figure 1 - Oracle Data Integrator Enterprise Edition Studio
High-Productivity Designer Paradigm for Data Integration
Oracle Data Integrator Enterprise Edition 12c introduces a new declarative flow-based user interface for enhanced user experience and productivity. The new user interface combines the simplicity and ease-of-use of the declarative approach with the flexibility and extensibility of configurable flows. This blend simplifies common data integration design and deployment use cases, shortening implementation times. Data integration designers describe source and target data formats and data integration processes. The business user or the developer can focus on describing what to do, not how to do it. Oracle Data Integrator Enterprise Edition generates, deploys, and manages the code required to implement those processes across the various source and target systems.
The paradigm is also enriched with the ability to seamlessly reuse mapping logic during development, giving developers a simpler and more efficient technique for providing solutions to their completion.
Knowledge Modules Provide Flexibility and Extensibility
Knowledge Modules are at the core of the Oracle Data Integrator Enterprise Edition’s architecture. They make all Oracle Data Integrator Enterprise Edition processes modular, flexible, and extensible.
Knowledge Modules implement the actual data flows and define the templates for generating code across the multiple systems involved in each data integration process. Knowledge Modules are generic, because they allow data flows to be generated regardless of the transformation rules. At the same time, they are highly specific, because the code they generate and the integration strategy they implement are explicitly tuned for a given technology. Oracle Data Integrator Enterprise Edition provides a comprehensive library of Knowledge Modules, which can be tailored to implement existing best practices ranging from leveraging heterogeneous source and/or
3 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
target systems, to methodologies for highest performance, for adhering to corporate standards, or for specific vertical know-how. By helping companies capture and reuse technical expertise and best practices, Oracle Data Integrator Enterprise Edition’s Knowledge Module framework reduces the cost of ownership. It also enables metadata-driven extensibility of product functionality to meet the most demanding data integration challenges.
Enterprise Deployment for High Availability and Scalability
Oracle Data Integrator Enterprise Edition integrates to Oracle Fusion Middleware as a platform. Oracle Data Integrator Enterprise Edition provides its run-time components as Java EE applications, enhanced to fully leverage the capabilities of the Oracle WebLogic and Oracle Coherence. Oracle Data Integrator Enterprise Edition components include exclusive features for Enterprise-Scale Deployments, high availability, scalability, and hardened security.
High-Availability (HA) and Scalability is fully supported via clustered deployments for Java EE components. Oracle Data Integrator Enterprise Edition components deployed in WebLogic Server benefits from the capabilities of clustering for scalability, including JDBC connection pooling and load balancing. In addition to the cluster- inherited HA capabilities, the run-time agent also supports a connection retry mechanism to transparently recover sessions running in repositories that are stored in HA-capable database engines such as Oracle RAC.
Unified Administration and Management
Oracle Data Integrator Enterprise Edition simplifies complex data-centric deployments by improving visibility and control for with a unified set of management interfaces. The Oracle Data Integrator Enterprise Edition Console leverages the Oracle Application Development Framework (ADF) and Ajax Framework for a rich user experience. Using this console, production users can set up an environment, export and import the repositories, manage run- time operations, monitor the sessions, diagnose the errors, browse design-time artifacts, and generate lineage reports.
In addition, this interface integrates seamlessly with the Oracle Enterprise Manager Fusion Middleware Control Console and allows administrators to monitor from a single screen not only their data integration components but their other Fusion Middleware components as well.
Deployment on OCI Cloud and a Path to Cloud Native
Service Oracle Data Integrator Enterprise Edition is available on OCI Marketplace for easy deployment on OCI Cloud.
It is also evolved as a cloud data integration product with modern UI. Data Transforms is the latest evolution of Oracle Data Integrator for data integration. It is a native service on OCI and available in Autonomous Database Serverless and OCI GoldenGate service, making it easy to start using it immediately. Current customers also have the option to modernize and migrate to Data Transforms. Refer to Data Transforms guide to learn more about Data Transforms.
4 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
Related products Oracle Data Integrator Enterprise Edition integrates with Oracle GoldenGate for real-time data warehousing, with Oracle Enterprise Data Quality for advanced data profiling, cleansing, matching, and data governance needs and with Oracle Enterprise Manager for improved IT productivity in monitoring Oracle technology and applications from one central location. It is also available as native cloud service in Data Transforms. • Oracle Data Transforms • Oracle GoldenGate • Oracle Enterprise Data Quality • Oracle Enterprise Manager • Oracle Database • Oracle Autonomous Database
Call +1.800.ORACLE1 or visit oracle.com. Outside North America, find your local office at: oracle.com/contact.
Oracle, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Some regulatory certifications or registrations to products or services referenced on this website are held by Cerner Corporation. Cerner Corporation is a wholly-owned subsidiary of Oracle. Cerner Corporation is an ONC-certified health IT developer and a registered medical device manufacturer in the United States and other jurisdictions worldwide.
This document may include some forward-looking content for illustrative purposes only. Some products and features discussed are indicative of the products and features of a prospective future launch in the United States only or elsewhere. Not all products and features discussed are currently offered for sale in the United States or elsewhere. Products and features of the actual offering may differ from those discussed in this document and may vary from country to country. Any timelines contained in this document are indicative only. Timelines and product features may depend on regulatory approvals or certification for individual products or features in the applicable country or region.
5 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
