Connected but database schemas are not appearing - OBI Developer Client Tool (12.2.1.0.0)

wikki26

Hi,

I have created one virtual machine, for OBIEE 12c on Windows 2012 Server. It is installed and working fine.

I have an issue with OBI Administration tool,

Datasource View is showing the default schema only like, Sample App.

Database schemas are not showing there.

What should I do?

Regards,

Waqas

[Deleted User]

Import the schemas from the database / data sources. An OBI RPD by default is empty and I would not suggest starting with the demo SampleApp.

wikki26

Kindly, i would like to ask, how can i import schemas from data source or database using OBIEE 12c Client Tool/Administration Tool.

?

[Deleted User]

Let me google that for you

First result: https://docs.oracle.com/cd/E23943_01/bi.1111/e10540/datasource.htm#BIEMG1212

Leads to: https://docs.oracle.com/cd/E23943_01/bi.1111/e10540/datasource.htm#BIEMG1231

Technology can be amazing

wikki26

Hi,

I have already done this task, via ODBC, it was connected and working fine.

I think my question wasn't clear.

Actually, like OBIEE 11g, all schemas are shown under one datasource connection, here OBIEE 12c, only 1 schema and its tables can show using datasource. To get access for 2nd schema, we have to create another datasource in OBIEE 12c.

This was confusing. Is this a change in OBIEE 12c?

Regards,

Gianni Ceresa

It didn't change and you can have multiple DB schemas in the same data source (as long as all the schemas are from the same server / instance).

Nothing new there ...

[Deleted User]

Ok so that's a totally different question then and one which Gianni answered in the meantime but to make it visible - it's still perfectly possible as you can see from this 12c RPD:

wikki26

I have one ODBC.

1. I am creating a new repository,

2. Select Connection Type ODBC 3.5 under Select Data Source

3. Select DSN, which I have created using ODBC

4. User Name and Passwords are given for weblogic user

5. Select Metadata Objects, (only for weblogic user is appearing)

6. In 11g, I believe all users are shown there and there tables also.

This is what i want to ask, how we can see all users under Metadata Objects.

If we cannot, then do we need to create each data source for each user.

wikki26

Thanks to all, I have fixed this issue, this was due OCI related error.

I have installed Database client with OCI checked. Now it is working fine.

Regards,

Waqas