Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Introducing Oracle Data Integrator Cloud Service (ODICS)!

Sandrine Riley
Senior Principle Product Manager

We are pleased to announce and welcome Oracle Data Integrator Cloud

Read the press release:  Oracle Launches Cloud Service to Help Organizations Integrate Disparate Data and Drive Real-Time Analytics.


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.

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.

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.

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.

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.

Join the discussion

Comments ( 2 )
  • Sudheer Chonate Monday, February 20, 2017

    Need to know related ODICS Training and Certifications for ODI Developers

  • guest Tuesday, February 21, 2017

    Hello Sudheer,

    Given how similar ODICS is to ODI, no new/different certification is out there for it at this time. If you have ODI certification, that would be it. For this, reach out to OPN if you are a partner, or Oracle University if you are a customer/individual wishing to certify.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.