OBIEE Resource Configuration

Note: Before you configure your scanner, make sure you meet the prerequisites. Read our guide on OBIEE integration requirements to double-check.

Source System Properties

This configuration can be setup by creating a new connection on Admin UI > Connections tab or editing an existing connection in Admin UI > Connections > Reporting & BI > OBIEE > specific connection. New connection can also be created via Manta Orchestration API General Walkthrough Example.

One IBM Manta Data Lineage connection for OBIEE corresponds to one OBIEE server and its presentation catalog. The reports, data models, analyses, and dashboards that are stored in the presentation catalog will be analyzed.

This automatic extraction requires a connection using OBIEE Web Services, and the OBIEE server needs to be running.

Common Source System Properties

Property name

Description

Example

obiee.extractor.server

Name of a resource representing this OBIEE server also known as the dictionary ID, used as an output subdirectory name for extracted definition files for reports and other objects

Obiee1

obiee.extractor.address

The complete URL address of the OBIEE server

http://192.168.0.23:9502

obiee.extractor.user

User name for connection to the OBIEE server

weblogic

obiee.extractor.password

User password for connection to the OBIEE server

welcome1

obiee.extractor.include

A regular expression for full object names to be extracted in the format /folder/object, or leave blank to ignore this parameter
Use special names for special folders: "Shared Folder" -> "shared", "My Folder" -> "users/YOUR_USERNAME", "Dashboards" -> "_portal"
Use "|" (vertical bar) to select multiple folders

/shared/SomeFolder
/users/weblogic/_portal/MyDashboard
/shared/FirstFolder | /shared/SecondFolder

obiee.extractor.exclude

A regular expression for full object names NOT to be extracted in the format /folder/object, or leave blank to ignore this parameter
Use special names for special folders: "Shared Folder" -> "shared", "My Folder" -> "users/YOUR_USERNAME", "Dashboards" -> "_portal"
Use "|" (vertical bar) to select multiple folders

/shared/SomeFolder
/users/weblogic/_portal/MyDashboard
/shared/FirstFolder | /shared/SecondFolder

obiee.input.encoding

Encoding of the provided OBIEE files; only necessary if an input has been served manually by the client. See Encodings for applicable values.

UTF-8

Common Scanner Properties

This configuration is common for all OBIEE source systems and for all OBIEE scenarios, and is configure in Admin UI > Configuration > CLI > OBIEE > OBIEE Common. It can be overridden on individual connection level.

Property name

Description

Example (default value)

obiee.input.dir

Directory with files automatically extracted from the OBIEE Presentation Catalog

If analysis files are provided, they must contain the extension .anl

${manta.dir.temp}/obiee/${obiee.extractor.server}

obiee.manualInput.dir

Directory for manually extracted OBIEE files, meaning both the repository dump and the Catalog Manager export

${manta.dir.input}/obiee/${obiee.extractor.server}

obiee.odbc.connection.definition.file

Path to the optional ODBC connection definition file

${manta.dir.input}/obiee/${obiee.extractor.server}/odbcConnectionDefinition.ini

obiee.odbc.connection.definition.encoding

Encoding of the ODBC connection definition file. See Encodings for applicable values.

UTF-8

ODBC Connection Definition Settings

The connection settings for OBIEE are automatically exported by Manta Data Lineage during lineage analysis. But to resolve the ODBC connector, Manta Data Lineage needs more information about the source/destination system. The settings can be configured manually as follows.

Example of a section in the configuration file:

[Medical]
Type=MSSQL
Connection_String=jdbc:sqlserver://192.168.0.16:1433
Server_Name=
Database_Name=
Schema_Name=TestSchema
User_Name=user

[DB-HR]
Type=Oracle
Connection_String=jdbc:oracle:thin:@192.123.0.68:1521/orcl
Server_Name=
Database_Name=orcl
Schema_Name=HR
User_Name=