The OBIEE Sample Application is a fully functioning OBIEE environment available on a VM. It is self-contained in that demo applications can be run against data stored on the VM. It is possible to modify the VM so that external data can also be accessed and shown in a demo or used for testing. This article shows how to modify the VM to access a Teradata database. Almost any Teradata database version will work with OBIEE, but see the certification matrix for supported versions.
Install and Configure
For V406: /app/oracle/biee/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup
For V511: /app/oracle/biee/user_projects/domains/bi/config/fmwconfig/bienv/core
[ODBC Data Sources]
AnalyticsWeb=Oracle BI Server
opss_datasource=DataDirect 7.1.4 Oracle Wire Protocol
biplatform_datasource=DataDirect 7.1.4 Oracle Wire Protocol
Start up the OBIEE stack as per the Oracle directions. Once up and running this completes the VM modifications.
Modifying the OBIEE Metadata
In order to access data from Teradata, the OBIEE metadata needs to be updated. This is done with the “OBIEE Administration” tool. Following are instructions on where to get the install files in order to run the configuration.
Install the client tool
To modify the sample app metadata a client tool is required. This is a windows based tool call OBIEE Administration. This section shows how to install the client and open the metadata on the sample application for modification. The following steps need to be done on a windows machine that is on the same network as the Sample Application VM and the Teradata database.
OBIEE 12c has a new homepage. For the V511 version this is what is displayed:
Add the ODBC DNS entries
Two ODBC entries are needed. The first will be used to access the OBIEE repository. The second will be used to access the Teradata Database
Running the client
Building out the business and presentation models as usual will allow you to query the data using Analysis, Visual Analyzer and the other BI components.
It should. I haven't tried it yet. The paths and ports may have changed, so it make take a little effort to configure.