Oracle Data Integrator Cloud

Oracle Data Integrator Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.

Description

Oracle Data Integrator Cloud Service (ODICS) delivers high-performance data movement and transformation capabilities with its open and integrated E-LT architecture and extended support for Cloud and Big Data solutions. Oracle Data Integrator Cloud Service provides all of the functionality included in Oracle Data Integrator Enterprise Edition in a single heterogeneous Cloud Service integrated with the Oracle Public Cloud. Providing an easy-to-use user interface combined with a rich extensibility framework, Oracle Data Integrator Cloud Service improves productivity, reduces development costs and lowers total cost of ownership among data-centric architectures. Oracle Data Integrator Cloud Service is fully integrated with Oracle Platform as a Service (PaaS) offerings such Oracle Database Cloud Service, Oracle Database Exadata Cloud Service and/or Oracle Big Data Cloud Service to put data and value at the center of the enterprise. Oracle Data Integrator Cloud Service is open and standards-based such that it can work with 3rd party systems as well as Oracle’s solutions. Cloud E-LT Architecture for High Performance Oracle Data Integrator Cloud Service's E-LT architecture leverages disparate relational database management systems (RDBMS) or Big Data engines 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 Cloud Service’s E-LT architecture generates native code for disparate RDBMS or big data engines (SQL, HiveQL, or bulk loader scripts, for example). The E-LT architecture extracts data from the disparate sources, loads it into a target, and executes transformations using the power of the database or Hadoop. By leveraging existing databases and big data infrastructures, Oracle Data Integrator Cloud Service 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 for Cloud environments. Heterogeneous Cloud Support Oracle Data Integrator Cloud Service provides heterogeneous support for 3rd party platforms, data-sources, data warehousing appliances and Big Data systems. While Oracle Data Integrator Cloud Service leverages optimizations for Oracle Database and Big Data Cloud Services to perform E-LT data movement, transformation, data quality and standardization operations, Oracle Data Integrator Cloud Service is fully optimized for mixed technologies including: sources, targets and applications, etc. Knowledge Modules Provide Flexibility and Extensibility Knowledge Modules are at the core of the Oracle Data Integrator Cloud Service’s architecture. They make all Oracle Data Integrator 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 Cloud Service provides a comprehensive library of Knowledge Modules, which can be tailored to implement existing best practices ranging from leveraging heterogeneous source and/or 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 Cloud Service’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. 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. We look forward to hearing how you might use Oracle Data Integrator Cloud Service within your enterprise.

Scheme of work

 Scheme of work