About Best Practices for Building Resilient Integrations with Oracle Data Integrator

Oracle Data Integrator is a powerful and flexible tool for extracting, transforming, and loading data between disparate sources and targets. But, some customers find that their data integrations are brittle, unable to handle even brief or temporary interruptions. These best practices present the tools and approaches that Oracle recommends for building integrations that are resilient to the realities of the modern networks and infrastructures.

About Resiliency

Before diving into what will make your environment resilient, you first need to define what resiliency means to you and your business.

In other words, what is the cost associated with an outage of your integration processes. For some customers, an outage of a few minutes is perfectly acceptable and will only partially delay a batch process that runs well within its processing window. For others, even a few seconds of outage result in financial losses that have a direct impact on the business.

From that perspective, it is important to look at the following elements:

What is the duration of an acceptable outage in your environment? Here you should define the cost to the business in case of an outage, and outline how that outage evolves with the duration of the outage.
What technologies are used and how can they deliver on the expected SLA? Are you taking a real-time or batch approach? Or a combination of the two? How much data are you processing?

About Required Products and Roles

This best practices solution playbook requires the following products and roles:

Oracle Data Integrator. You can use any version, including on-premises and cloud releases.
Source and target data systems. Oracle Data Integrator can extract and load data from a wide variety of different systems.

Oracle Data Integrator is provided with certain predefined roles, but it is common for customers to create their own roles. The following table lists profiles required to perform various activities described in this Best Practices solution playbook.

Service Name: Profiles	Required to...
Oracle Data Integrator: Supervisor. Or, a combination of Security Admin, Topology Admin, and Release Manager.	Perform administrative tasks such as setting up security, connecting to data sources, and release management.
Oracle Data Integrator: Designer, Metadata Admin, and Operator.	Perform developer tasks such as creating objects, creating data stores, and starting and monitoring run-time objects.
Oracle Data Integrator: Connect.	Allow a user to log in to Oracle Data Integrator.

See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud services you need.