1 Getting Started with Oracle Data Integrator Cloud

Learn about Oracle Data Integrator Cloud, what it is and how to use it.

What is Oracle Data Integrator Cloud

Data integration ensures that information is timely, accurate, and consistent across complex systems. This section provides an introduction to data integration and describes how Oracle Data Integrator Cloud provides support for data integration.

About Oracle Data Integrator Cloud

Oracle Data Integrator Cloud provides a fully unified cloud-based solution for building, deploying, and managing complex data warehouses or as part of data-centric architectures in a SOA or business intelligence environment.

It combines all the elements of data integration — data movement, data synchronization, data quality, data management, and data services—to ensure that information is timely, accurate, and consistent across complex systems.

Oracle Data Integrator Cloud features an active integration platform that includes all styles of data integration: data-based, event-based and service-based. It unifies silos of integration by transforming large volumes of data efficiently, processing events in real time through its advanced Changed Data Capture (CDC) framework, and providing data services to the Oracle SOA Suite. It also provides robust data integrity control features, assuring the consistency and correctness of data. With powerful core differentiators - heterogeneous E-LT, Declarative Design and Knowledge Modules - Oracle Data Integrator Cloud meets the performance, flexibility, productivity, modularity and hot-pluggability requirements of an integration platform.

Before you Begin with Oracle Data Integrator Cloud

There are a few prerequisites you need before you can use Oracle Data Integrator Cloud.

Before you begin with Oracle Data Integrator Cloud, you should have:
  1. An Oracle Cloud account.
  2. Your Oracle Cloud user name, password, and identity domain. You can locate your account details in the post-activation mail that you received from Oracle Cloud. For additional information, see Getting Started with Oracle Cloud.
  3. Service Administrator role for your Oracle Cloud services. When the service is activated, Oracle sends the sign-in credentials and URL to the designated Account Administrator. The Account Administrator then creates an account for each user who needs access to the service.
  4. A supported browser, such as:
    • Microsoft Internet Explorer 11.x+

    • Mozilla Firefox ESR 38+

    • Google Chrome 42+

    • Apple Safari 8.x and 7.x

How to Begin with Oracle Data Integrator Cloud

Here’s how to get started with free Oracle Data Integrator Cloud promotions and subscriptions:

  1. Sign up for a free credit promotion or purchase a subscription.

    See Requesting and Managing Free Oracle Cloud Promotions or Buying an Oracle Cloud Subscription in Getting Started with Oracle Cloud

  2. Access the Oracle Data Integrator Cloud service.

    See Accessing Oracle Data Integrator Cloud.

To grant access to others:

Accessing Oracle Data Integrator Cloud

You can access Oracle Data Integrator Cloud through emails that you receive after subscribing or through the service web console.

To access Oracle Data Integrator Cloud:

  1. Open your web browser and go to http://cloud.oracle.com.

  2. Click Sign In.

  3. From the Cloud Account menu, select Cloud Account with Identity Cloud Service.

  4. Enter the name of your Cloud Account in the Cloud Account Name field.

  5. Click My Services.

  6. On the Sign In to Oracle Cloud page, enter your sign-in credentials.

If you don’t have your welcome mail to the My Services application, then contact your administrator.

Users

Administrators, Developers and Operators use the Oracle Data Integrator Studio to access the repositories. This Fusion Client Platform (FCP) based UI is used for administering the infrastructure (security and topology), reverse-engineering the metadata, developing projects, scheduling, operating and monitoring executions.

Business users (as well as developers, administrators and operators), can have read access to the repository, perform topology configuration and production operations through a web based UI called Oracle Data Integrator Console. This Web application can be deployed in a Java EE application server such as Oracle WebLogic.

ODI Studio provides four Navigators for managing the different aspects and steps of an ODI integration project:

Topology Navigator

Topology Navigator is used to manage the data describing the information system's physical and logical architecture. Through Topology Navigator you can manage the topology of your information system, the technologies and their datatypes, the data servers linked to these technologies and the schemas they contain, the contexts, the language and the agents, as well as the repositories. The site, machine, and data server descriptions will enable Oracle Data Integrator to execute the same mappings in different environments.

Designer Navigator

Designer Navigator is used to design data integrity checks and to build transformations such as for example:

  • Automatic reverse-engineering of existing applications or databases

  • Graphical development and maintenance of transformations and mappings

  • Visualization of data flows in the mappings

  • Automatic documentation generation

  • Customization of the generated code

The main objects you handle through Designer Navigator are Models and Projects.

Operator Navigator

Operator Navigator is the production management and monitoring tool. It is designed for IT production operators. Through Operator Navigator, you can manage your executions in the sessions, as well as the scenarios in production.

Security Navigator

Security Navigator is the tool for managing the security information in Oracle Data Integrator. Through Security Navigator you can create users and profiles and assign user rights for methods (edit, delete, etc) on generic objects (data server, datatypes, etc), and fine-tune these rights on the object instances (Server 1, Server 2, etc).