EPM SYSTEMFDMEE

ODI Studio installation for FDMEE

ODI Studio installation for FDMEE

Starting Oracle EPM 11.1.2.3+, ODI is automatically installed with FDMEE. In addition to installing the FDMEE UI, it creates ODI repositories, installs the agent, sets it up as a service and configures it all to work together out of the box. The only thing missing is the installation of the ODI Studio.

In this blog, we will describe the steps to install Oracle ODI Studio.

First of all, binaries must be downloaded from the link bellow: (you must download ODI 11.1.1.7 since FDMEE uses ODI 11.1.1.7 engine)

https://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

Once you downloaded, unzip the files:

Run the setup.exe file using the following command : >setup.exe -jreLoc E:\Oracle\Middleware\jdk160_35

Once setup is launched, the Welcome screen will appear. Click Next:

click on Skip Software Update then click Next:

During FDMEE installation, Agent and all other ODI components are already installed, so tick only ODI Studio then click Next:

Click Next:

Click Browse to locate the ODI Home, we will use the same Oracle Middleware as EPM:

Select The ODI Home then click Open, then click Next:

Click Skip Repository Configuration then click Next and then Install to finish:

Once the installation is finished, click Finish.

Now we can start ODI Studio to connect to FDMEE repositories:

Click the (+) to add new login:

ODI_Studio_3.png

Insert the information bellow then specify work repository:

ODI_Studio_4.png

Choose FDMEE then click OK and finally connect:

ODI_Studio_5.png

The installation is done, you can now modify ODI settings, access the operator, etc… using the ODI Studio.

 

Some functionalities offered by ODI Studio:

 

  • Connect FDMEE to a SQL table (It will be detailled in a new post)
  • Connect FDMEE to EBS
  • Manage Interfaces schedules
  • Manage Maintenance schedules

 

Previous article #SCRIPT vs #SQL mapping

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Comment

Your data will be safe! Your e-mail address will not be published. Also other data will not be shared with third person. Required fields marked as *

ten + seventeen =