The first relational database connection wizard panel, Connection, requires you to configure a JDBC driver by specifying a supported relational database, editing the database connection string, and providing database login credentials.
Text box or Control | Description |
|---|---|
Driver Type | Selects one of the supported relational databases:
|
JDBC Driver | Displays the Java Database Connectivity Driver. |
Database Connection String | Provides a sample database connection string syntax. Edit the string until it specifies the RDBMS computer name and database name. |
Username | Indicate a user name for the relational database. Important! You cannot create relational database connections without a user name and password. |
Password | Indicate a password for the user name. Important! You cannot create relational database connections without a user name and password. |
Test Connection | Click to test the relational connection before proceeding. |
Important notes on JDBC drivers:
The JDBC driver connects the application server hosting Web Analysis Studio and the relational database, not the client computer. You must ensure that the application server is able to connect.
Web Analysis Studio currently supplies all drivers that Oracle | Hyperion supports.
IBM DB2 is release specific. Oracle | Hyperion provides the JDBC driver for IBM DB2 7. The DB2java.zip client drivers must match the DB2java.zip archive on the IBM DB2 database server. Caution: Be extremely careful when copying files from the RDBMS server to the Web Analysis Studio installation directory! There are extreme consequences if you overwrite the application server local DB2 files used to access configuration information.
The Teradata 4.1 Connection string features four bracketed JDBC connection string parameters. Brackets and parameter names must be replaced with values.
Parameters | Description |
|---|---|
{host-name} | Server domain name |
{port} | TCP/IP port number |
{DSN} | Data source name |
{database name} | A database name |