Configuring Oracle Data Integrator for Cloudera

This article describes how to combine ODI with Hadoop. Before doing so, make sure you have the ODI software installed and build a Hadoop environment, or you can refer to my other blog posts to build the environment.

1. Create a Directory

[[email protected] ~]# hdfs dfs -mkdir -p /user/oracle/odi_home[[email protected] ~]# hdfs dfs -chown oracle:oinstall /user/oracle/odi_home[[email protected] ~]# hdfs dfs -ls /user/oracle/drwxr-xr-x   - oracle oinstall          0 2018-03-06 13:59 /user/oracle/odi_home

This directory is the root of the ODI HDFs, and if you do not create this directory, you will encounter ODI-26039 errors in subsequent steps.

2. Big Data Wizard

File->new., choose big Data configurations

3. General Settings

Prefix：前缀，默认即可。Distribution：根据CDH版本进行选择。Distribution Type：使用默认Normal即可。Base Directory：/opt/cloudera/parcels/CDHTechnologies：根据实际环境选择相关组件

The results are as follows:

4. Hadoop settings

5. HDFs Settings

6. Hive Settings

7. Oozie setting

8. Verification Settings

Configuring Oracle Data Integrator for Cloudera