Search This Blog

Wednesday, 14 August 2013

Right Click Problem "Creating New Data Server in ODI 11g"

I have installed Oracle Data Integrator 11g (ODI 11.1.1.7.0) successfully my laptop. But I couldn't create New Data Server for my new project. So here is the problem and solution.

Problem:
when we are trying to create New Data Server on right clicking in Physical Architecture in Topology Manager, We may be surprised because It doesn't respond and problem looks very odd.

Solution:
The solution is simple but weird, Refer Step1 and step2 for the solution below:

Step1:

Open ODI Studio -> Select 'Topology Manager' -> Expand Physical Architecture and select the database type which you want to create new data server

Instead of right clicking on "Oracle", Just click on the "+" symbol which is used to to expand the database type. ( For your reference, I have indicated in the red box in the above screenshot)
                                 
Step2:
After clicking on the "+" symbol, we will get the right click option to create 'New Data Server".
           
 Simple!!! Isn't it??!!

Cheers!
Bose

Tuesday, 13 August 2013

Connecting Essbase with OBIEE 11g - A Complete Step by Step Guide

This post is containing a PDF document which best describes how to create an Essbase Cube that we could use for OBIEE Report.

This simple step by step explanation guide will help us to create the Essbase Cube, Importing the cube in OBIEE Administration Tool and creating the report based on the Base.

To download the document click here

Hope it helps!

Cheers!
Bose

What is Oracle Database Link and How to create database link (DB Link)

 https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/

Recent Posts