Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Srver and DB Server related queries

Received Response
2
Views
4
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics Lead

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • 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
    Sangeeta Pandey Rank 6 - Analytics Lead

    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

  • 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.