Configuring Oracle RPAS ODBC Data Sources on AIX UNIX

You can access Oracle RPAS ODBC data sources when the Oracle BI Server is running on an AIX UNIX platform.

To configure this database connection, first update the odbc.ini file to configure the Oracle RPAS ODBC data source, then use the rdaadmin tool to define dimension tables as not normalized at run time.

See Setting Up Oracle RPAS Data Sources for information about configuring Oracle RPAS ODBC data sources on Windows.

To configure Oracle RPAS ODBC as a data source on AIX UNIX:

Log on as a separate telnet session.
Open the odbc.ini file. You can find this file at:

BI_DOMAIN/config/fmwconfig/bienv/core
In the RPAS data source section, edit the values. For example:
```
[RPAS Sample]
Data Source Name=RPAS Sample
Driver=[client RPASClient/lib/raix/oaodbc.so
DriverUnicodeType=1
Description=OpenRDA DSN
```
The Data Source Name you provide must match the value entered for DATABASE: in Step 3 of the following procedure. Also, you must add the line DriverUnicodeType=1 as shown in the preceding example.

To use the rdaadmin client tool to define dimension tables as not normalized at run time:

Locate the rdaadmin client tool in the following location:

/bin/rdaadmin
Run the rdaadmin client tool by typing the following command:

rdaadmin
Enter appropriate text when prompted, as follows:

DATABASE: [Oracle_RPAS_database_name]

The database name must match the name given for the Data Source Name in the previous task (for example, RPAS Sample).

ADDRESS: [ip_address]

PORT: [port_number]

An example port number value is 1707.

CONNECT_STRING: [NORMALIZE_DIM_TABLES=NO]

This value treats dimension tables as not normalized at run time.

TYPE: []

SCHEMA_PATH: []

REMARKS: []
The RPAS environment variable OPENRDA should be declared in the Oracle BI Server session on UNIX. For example, declare the variable as follows using the 64 bit rdaadmin client tool:
```
OPENRDA_INI=/rpasclient64/config/raix/openrda.ini export OPENRDA_INI
```