nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Oracle BI Administrator Tool

CRX

Hello everyone.

How to Import Metadata from an External Source into the Oracle BI Administrator Tool.

I have option only for localhost.

Thank you.

Find more posts tagged with

Accepted answers

All comments

CRX

A connection pool has no option to populate the IP Adress of my external database.

Sherry George

Read the documentation https://docs.oracle.com/middleware/1221/biee/BIEMG/datasource.htm#BIEMG3833

"Metadata imports to an Oracle BI repository must occur through an ODBC or native database connection to the underlying data source. Metadata can also be imported from software such as Microsoft Excel through an ODBC connection."

You create a connection to your source using a connection object and then use that connection to import the metadata. You can see below a list of available connection type in OBIEE rpd.

Gianni Ceresa

What is your "External Source" ?

CRX

Hello everyone, I made the correction with the windows ODBC DRIVER configuration.

CRX

Data base not localhost.

Gianni Ceresa

The question was more about what kind of source you wanted to use to point you in the best direction (like OCI instead of ODBC if Oracle etc.).

But you fixed, so enjoy

Upcoming Event

Oracle Webinar OCI AI Foundations Certification
Prepare-se para sua certificação em OCI AI Foundations Inteligência Artificial está transformando a forma como empresas desenvolvem aplicações, automatizam processos e utilizam seus dados. Para aproveitar esse potencial, é essencial compreender os principais conceitos de IA e como essas tecnologias se conectam aos serviços…