...
In a Database profile configuration, you can create database profiles for use in various agents and profiles including:
...
The Database profile has two tabs: General and Properties.
General Tab
In the General tab, the two radio buttons Default Connection Setup and Advanced Connection Setup display different connection options.
Default Connection Setup
Select the Default Connection Setup radio button to use a preconfigured connection string.
Setting | Description |
|---|---|
Default Connection Setup | Select this option to configure a default connection. |
Database Type | Select a database type. You may need to make some preparations before attempting to connect to the database for the first time. For information about required preparations, see the section below, Database Types. |
Database Name | Enter a name for the database instance. |
Database Host/Path | Enter the host name. Enter it exactly as when you access it from any other application within the network. This is applicable to all database type except the CSV File. Enter the CSV File path. |
Port Number | Enter the database network port. |
Username | Enter the database user name. |
Password | Enter the database password. |
Try Connection | Click to try the connection to the database, using the configured values. |
| Anchor | ||||
|---|---|---|---|---|
|
The Advanced Connection Setup enables you to specify a customized connection string. You can use this when you need to add additional properties to a connection.
Setting | Description |
|---|---|
Advanced Connection Setup | Select to configure the data source connection using a connection string. |
Database Type | Select a database type. You may need to perform some preparations before attempting to connect to the database for the first time. For information about required preparations, see the section below, Database Types. |
Connection String | Enter a connection string containing information about the database and the means of connecting to it. |
Username | Enter the database user name. |
Password | Enter the database password. |
Try Connection | Click to try the connection to the database, using the configured values. |
Properties Tab
The Properties tab allows you to configure additional properties for certain database types.
...
Database Type | Properties |
|---|---|
Oracle |
|
PostgreSQL |
|
SAP HANA |
|
Database Types
| Anchor | ||||
|---|---|---|---|---|
|
The following table provides information of the database versions supported.
...