OBIEE Srver and DB Server related queries

Sangeeta Pandey

Hello Experts,

When we perform import metadata through Connection point at physical layer of RPD, I guess it brings the object from DB server to OBIEE server?

Does OBIEE sever also has a inbuilt DB for storage to accommodate objects imported from DB server?

Thanks,

Sangeeta

[Deleted User]

Not sure what you mean by that. The repository is metadata. It holds descriptive information on models and connections.

Sangeeta Pandey wrote:Does OBIEE sever also has a inbuilt DB for storage to accommodate objects imported from DB server?

The repository IS the storage.

Gianni Ceresa

Sangeeta Pandey wrote:import metadata through Connection point at physical layer of RPD, I guess it brings the object from DB server to OBIEE server?

It's called "import metadata", therefore the only thing which will be retrieved is metadata, no data will be moved.

Sangeeta Pandey

Thank you Gianni and Chris for help !!!

Ok, only metadata will be imported and no data. This OBIEE repository will be part of DB server and can be different than OBIEE server. OBIEE server will connect with DB server to access metadata reps to refer these metadata?

Regards,

Sangeeta

Gianni Ceresa

Sangeeta Pandey wrote:This OBIEE repository will be part of DB server and can be different than OBIEE server. OBIEE server will connect with DB server to access metadata reps to refer these metadata?

No, the import is a real import. But only an import of metadata. More than an import you can see it as looking what the DB objects look like and create their representation in the RPD. But the metadata is stored into the RPD, which isn't in the database (to keep it simple as technical implementations in the OBIEE/OAC/OAS line keeps changing).

The RPD is, for now, just a file. Into that file you have all the metadata.