Oracle Data Integrator Enterprise Edition
provides efficient data transfer and transformation
between enterprise platforms
thanks to open integrated E-LT architecture
and extended support for Big Data.
Oracle is a leader in the data integration market, offering the industry’s most comprehensive solution in this domain, including Oracle Data Integrator Enterprise Edition, Oracle GoldenGate, Oracle Enterprise Data Quality, Oracle Big Data Preparation Cloud Service, and Oracle Enterprise Metadata Management. Oracle data integration solutions provide continuous access to current, trusted, and heterogeneous data from the entire enterprise, supporting integration of both analytical and operational data.
New features in Oracle Data Integrator Enterprise Edition 12c:
PERFECT PERFORMANCE thanks to a declarative flow-based user interface. The user receives a simple, yet comprehensive and powerful tool. The ability to seamlessly reuse data mapping logic speeds up development and reduces total solution execution time.
STREAMLINED PARALLELISM CAPABILITY further improves high performance of the tool’s architecture.
BROAD ELT CAPABILITIES,, integrated with Oracle GoldenGate to speed up and improve the performance of loading and transforming data in real time into a data warehouse or a Big Data system. Customers can easily configure and deploy real-time data warehousing solutions without a negative impact on source systems or batch window dependencies. The migration tool and improved interoperability with Oracle Warehouse Builder, providing customers with tools and a platform for migrating to the Oracle Data Integrator strategic platform.
MIGRATION TOOL and improved interoperability with Oracle Warehouse Builder, providing customers with tools and a platform for migrating to the Oracle Data Integrator strategic platform.
DIRECT INTEGRATION with Oracle Enterprise Manager Cloud Control 12c for improving IT efficiency by monitoring Oracle technologies and applications from a single central location.
EXTENDED BIG DATA SUPPORT by unifying integration tools through industry standards for unstructured/partially structured and structured data.
VERSION MANAGEMENT FEATURES, that enable customers to better manage code, as well as development, testing, and production environments. This also includes deep integration with Apache Subversion.
Oracle Data Integrator Enterprise Edition ensures meeting varied needs of an enterprise with respect to data integration.
E-LT architecture (extract, load, transform) of Oracle Data Integrator Enterprise Edition uses separate relational database management systems (RDBMS) or Big Data engines to process and transform data. This optimizes performance and scalability while reducing total costs of the solution.
Instead of depending on a separate, conventional ETL transformation server, Oracle Data Integrator Enterprise Edition’s E-LT architecture generates native code for separate RDBMS or Big Data engines (e.g. SQL, HiveQL, PySpark, Pig Latin, or bulk loader scripts). The E-LT architecture extracts data from separate sources and loads them into the target system and performs transformations using the database itself or the Hadoop system. By using an existing database and Big Data infrastructure, Oracle Data Integrator Enterprise Edition provides the highest performance and low maintenance costs. By limiting network traffic and transforming data on the server containing target data, the E-LT architecture guarantees the highest possible performance.
Oracle Data Integrator Enterprise Edition supports heterogeneous external platforms, data sources, and data warehousing tools. Oracle Data Integrator Enterprise Edition is optimized for Oracle Database for the purpose of data transfer operations as part of E-LT, transformation, data quality, and standardization operations. It is also fully optimized for mixed technologies, including mixed source and target systems, applications, etc.
Oracle Data Integrator Enterprise Edition 12c introduces a new declarative user interface based on network flows to streamline and improve the user’s work efficiency. The new user interface combines the simplicity and ease of use of a declarative approach with extensibility of configurable flows. This combination ensures simplification of use cases for common integration and data deployment, shortening implementation time. Data integration designers describe source and target data formats and data integration processes. Business users and developers can therefore focus on what data to integrate, and not how to do it. Oracle Data Integrator Enterprise Edition generates, deploys, and manages code required to implement these processes in different source and target systems.
The paradigm is also extended with the ability to seamlessly reuse data mapping logic during development, providing developers with an easier and more efficient technique for preparing integration solutions.
Knowledge modules constitute the core of the Oracle Data Integrator Enterprise Edition architecture. They make all processes in Oracle Data Integrator Enterprise Edition modular, flexible, and extensible.
Knowledge modules implement actual data flows and define templates for generating code for various systems participating in each data integration process.
Knowledge modules are generic, because they allow generating data flows regardless of transformation rules. At the same time, they have a very specific nature, because the code they generate and the implemented integration strategy are accurately tailored for a given technology. Oracle Data Integrator Enterprise Edition provides an extensive library of Knowledge Modules that can be tailored for the purpose of implementing existing best practices, from using heterogeneous source and/or target system, to methodologies for obtaining the best performance, to maintain compatibility with corporate standards, or for knowledge bases in hierarchical organizations.
By enabling enterprises to capture and reuse technical knowledge and best practices, Oracle Data Integrator Enterprise Edition Knowledge Modules reduce maintenance costs. Thanks to them, extensibility of metadata-based product features can meet even the most demanding data integration challenges.
Oracle Data Integrator Enterprise Edition integrates with Oracle Fusion Middleware as a platform. Oracle Data Integrator Enterprise Edition provides runtime environment components as Java EE applications, appropriately extended to fully utilize the capabilities of Oracle WebLogic and Oracle Coherence. Components of Oracle Data Integrator Enterprise Edition have unique properties for enterprise-wide deployments, high availability, scalability, and high level of security.
High availability (HA) and scalability are fully supported by clustered deployments of Java EE components. Components of Oracle Data Integrator Enterprise Edition deployed on Oracle WebLogic Server take advantage of clustering capabilities for the purpose of scalability, including the creation of JDBC connection pool and load balancing. Moreover, in addition to HA capabilities inherited by clusters, the runtime environment agent also supports a connection retry mechanism for the purpose of transparent recovery of sessions running in repositories, stored in database engines with HA capability, e.g. Oracle RAC.
Oracle Data Integrator Enterprise Edition simplifies complex data-oriented deployments by improving visibility and control features for a unified set of management interfaces.
The Edition Console of Oracle Application Development Framework utilizes the Oracle Application Development Framework (ADF) and Ajax to streamline user experience. Using the console, users in production departments can configure the environment, export and import repositories, manage runtime operations, monitor sessions, diagnose errors, view design mode artefacts, and create data origins reports.
Furthermore, this interface seamlessly integrates with the console of Oracle Enterprise Manager Fusion Middleware Control and allows the administrator to use a single screen to monitor not only data integration components, but also other Fusion Middleware components.
To provide the highest value of Oracle Data Integrator, Oracle also offers a Management Pack plug-in for Oracle Data Integrator. It utilizes advanced management capabilities of Oracle Enterprise Manager Cloud Control to provide integrated, comprehensive solutions for Oracle Data Integrator environments, ensuring consolidated view of the entire Oracle Data Integrator infrastructure, and allowing the user to centrally monitor and manage all components from Oracle Enterprise Manager Cloud Control.