Database type
In the drop-down menu, select your database system. Here it is Oracle.
Timeout
Here you can specify a value for the timeout in seconds for establishing the connection. If the time set here is exceeded, ibaPDA 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.
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. You can also overwrite the connection name.
You can use this name to identify the database connection in the overview table at the interface level. The connection name is there in the DB name column.
Oracle database connection
You have 2 possibilities to configure a connection to the Oracle database. It is recommended to establish the connection via the TNS tab, see Default connection configuration. Establishing the database connection via the Basis tab is recommended for DB administrators and developers, see Advanced connection configuration.
In both cases you have to authenticate yourself:
User name/Password
Enter here the required login data for the database. If necessary, inquire the correct data from 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 with which the ibaPDA server is running on is used. Usually, this is the system account. Please check with your DB administrator whether this method is appropriate or not.
<Test connection>
ibaPDA 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.