33 Oracle Marketing Cloud
It is important to understand how to work with Oracle Marketing Cloud in Oracle Data Integrator.
This chapter includes the following sections:
Introduction
Oracle Marketing Cloud simplifies digital marketing by providing one place for marketing teams to connect data, orchestrate experiences, and optimize interactions for each individual customer.
Oracle Data Integrator (ODI) seamlessly integrates with Oracle Marketing Cloud. Oracle Data Integrator features are designed to work best with Oracle Marketing Cloud, including reverse-engineering and mappings.
Concepts
The Oracle Marketing Cloud technology concepts map the Oracle Data Integrator concepts as follows: An Oracle Marketing Cloud Instance corresponds to a data server in Oracle Data Integrator. Within this instance, a schema maps to an Oracle Data Integrator physical schema.
Knowledge Modules
Oracle Data Integrator provides no Knowledge Module (KM) specific to the Oracle Marketing Cloud technology. You can use the generic SQL KMs to perform the data integration and transformation operations of Oracle Marketing Cloud data. See Generic SQL for more information.
Installation and Configuration
Make sure you have read the information in this section before you start working with the Oracle Marketing Cloud technology:
System Requirements and Certifications
Before performing any installation, you should read the system requirements and certification documentation to ensure that your environment meets the minimum installation requirements for the products you are installing.
The list of supported platforms and versions is available on Oracle Technical Network (OTN):
http://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html
Setting up the Topology
Setting up the topology consists of:
Creating an Oracle Marketing Cloud Data Server
- Duplicate the Oracle technology with the name "Oracle Marketing (Eloqua)".
- In the Definition tab, enter the following fields:
- Name : Name of the data server that will appear in Oracle Data Integrator.
- User: User name for connecting to the data server.
- Password: Password for connecting to the data server.
- In the JDBC tab, enter the following values:
- JDBC Driver:
weblogic.jdbc.eloqua.EloquaDriver
- JDBC URL :
jdbc:weblogic:eloqua://login.elqqa01.com;Company=PaasDi;User=<user>;Password=<password>;
- JDBC Driver:
- Click Test Connection, to test the established connection.
- Delete all the data types under Oracle Marketing (Eloqua)/Data Types node in Topology Navigator.
- Reverse-engineer the Oracle Marketing Cloud (Eloqua) data types by right-clicking Oracle Marketing (Eloqua) and selecting Datatypes Reverse-Engineering from the popup menu. In the Reverse Engineer Datatypes dialog, select the Data Server name from the drop-down menu.
Creating an Oracle Marketing Cloud Physical Schema
Creating and Reverse-Engineering an Oracle Marketing Cloud Model
This section contains the following topics:
Creating an Oracle Marketing Cloud Model
Reverse-engineer an Oracle Marketing Cloud Model
Oracle Marketing Cloud supports Standard reverse-engineering - which uses only the abilities of the JDBC driver.
To perform a Standard reverse-engineering on an Oracle Marketing Cloud model, use the usual procedure, as described in Reverse-engineering a Model of Developing Integration Projects with Oracle Data Integrator.
Designing a Mapping
You can use Oracle Marketing Cloud as a source or a target of a mapping. The KM choice for a mapping determines the abilities and performance of this mapping.
Oracle Data Integrator does not provide specific knowledge modules for Oracle Marketing Cloud. Use the Generic SQL KMs or the KMs specific to the technology used as the staging area.