...
Item | Description |
|---|---|
External References  | Select this menu item to Enable External References in an agent profile field. Refer to Enabling External References in an Agent Profile Field in 8.12 11 External Reference Profile for further information. |
...
| Setting | Description | |||||
|---|---|---|---|---|---|---|
Default Connection Setup | Select this option to configure a default connection. | |||||
Advanced Connection Setup | Select this option to configure the data source connection using a connection string. For further information, see the section below, Advanced Connection Setup. | |||||
Database Type | Select any of the available database types. 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. | |||||
Database Name | Enter a name that identifies the database instance. For example, when you configure the profile for an Oracle database, this field should contain the SID. | |||||
Database Host | Enter the host name or IP address of the host on which the database is running. Type it exactly as when accessing it from any other application within the network. | |||||
Port Number | Enter the database network port. | |||||
Username | Enter the database user name. | |||||
Password | Enter the database password. | |||||
| Enable TLS Truststore | Enable TLS/SSL for connection to a SAP HANA Database. This option will be enabled by default. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. For information about advanced connection for SAP HANA with TLS/SSL enabled, you an refer to 8.6.10 9 SAP HANA.
| |||||
| TLS Truststore | Enter the path and filename to the TLS/SSL trust store file that contains the SAP HANA hosting server's certificate. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. | |||||
| TLS Truststore Password | Enter the password for the TLS/SSL trust store file. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. | |||||
Try Connection | Click to try the connection to the database, using the configured values. |
...
| Setting | Description |
|---|---|
Default Connection Setup | Select to configure a default connection. For further information, see the section above, Default Connection Setup. |
Advanced Connection Setup | Select to configure the data source connection using a connection string. |
Database Type | Select any of the available database types. 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. |
Notification Service | This field is used when the selected Database Type is Oracle. For more information, see 8.6.7 6 Oracle. |
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. |
...
| Database | Version |
|---|---|
| Cassandra | 3.11.3 |
| CSV | - |
| DB2 | 10 |
| Derby | 10 |
| MS SQL Server | 2008, 2008R2, 2012, 2014, 2016, Azure SQL Database, Azure SQL Data Warehouse/Parallel Data Warehouse |
| MySQL | 5.x 8.x (only for PCC storage) |
| Netezza | - |
| Oracle | 11.2/12.1/12.2 |
| PostgreSQL | 9.6/10/11 |
| Redshift | - |
| SAP Hana | - |
| Snowflake | - |
| Sybase IQ | Version of Sybase IQ support through the use of the JCONN4 driver |
| Teradata | 16.20 |
| TimesTen | 11.2 |
| Vertica | 8.1 |
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
This section includes the following subsections: |