You can specify the following connectivity properties for your Oracle database:
| Property | Description |
|---|---|
| Host | Specifies the hostname or IP address of the database server |
| Port | Specifies the TCP port of the Oracle listener running on the Oracle database server. The default is 1521, which is the Oracle default port number when installing the Oracle database software. |
| User | Specifies the case-insensitive default user name used to connect to your Oracle database. |
| Password | Specifies the case-insensitive password used to connect to your Oracle database. |
| SID | Specifies the Oracle System Identifier that refers to the instance of the Oracle database running on the server. |
| Schema (optional) | Specifies the schema of the oracle database server. |
| URL | Defines the URL used to connect to your database. |
| Property | Description |
|---|---|
| Tablespace | |
| Temporary Tablespace | |
| Profile | |
| Use Timestamp for Date Columns |
You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.
| Property | Description |
|---|---|
| Maximum Pool Size | Determines the maximum number of connections that can be created within the connection pool. |
| Maximum Connections Per User | Determines the maximum number of connections that can be created per user. |
| Connection Idle Time (minutes) | Specifies the maximum time, in minutes, that a database connection can remain idle before it is closed automatically. |
| Minimum Pool Size | Determines the minimum number of connections that can be created within a connection pool. |
| Maximum Opened Cursors | Determines the maximum number of cursors that can be opened at one time. |