In a centralized Oracle multiuser DB environment, it is recommended to create a dedicated user, scheme and disk space (tablespace). Give this user the necessary rights for the loading process in ibaAnalyzer ("create session", "create table" ...).

For interactive database queries from different people, it is recommended to create a single shared or multiple dedicated database users with corresponding rights ("grant select on" ...). This applies to large installations where the iba data is not to be mixed with data from existing applications. Configure the database in such a way that the user has read and/or write rights thus preventing, for example, the deletion of existing data using the Create default tables option of ibaAnalyzer.

An Oracle client is not needed to establish a connection from ibaAnalyzer to an Oracle database. The configuration of the database connection to Oracle has become easier compared to previous ibaAnalyzer versions.

Note
	ibaAnalyzer v8.0.0 or higher no longer supports any database connections via ODBC. Databases that have been configured in older PDO files via ODBC must be converted to the actual database provider in ibaAnalyzer and directly connected to the database.

From the Data source drop-down list, select Create database connection. In the Database connection dialog box, select the required database provider under Database type.

To edit an existing connection, select the connection from the Data source drop-down list. Then click on the editing button.

It is recommended to configure the connection via the TNS tab, see Default connection configuration. Configuring the database connection via the Basis tab is recommended for DB administrators and developers, see Advanced connection configuration.

Connection name

This line contains the name of the database connection. The name is automatically formed and entered according to the scheme username@database as soon as you have filled in the fields below. Alternatively, you can enter and overwrite the connection name manually.

Timeout

Here you can specify a value for the timeout in seconds for establishing the connection. If the time set here is exceeded, ibaAnalyzer aborts the connection attempt and displays an error message.

Note that once the connection is made, each command sent to the database has an additional timeout, which can be set by the application that makes use of it. There is no generic configuration for the command timeout.

Username/Password

Enter here the required login data for the database. If uncertain, ask your DB administrator.

These fields are only available if the option OS-Authentication is disabled.

Use OS authentication

If you enable this option, the user account is used under which ibaAnalyzer runs. Usually, this is the system account. Contact your DB administrator to find out if this setting is suitable.

<Test connection>

ibaAnalyzer checks the access to the selected database on the set DB server. If the connection is successful, the message includes the version of the database.