Database Configurations options
On the Database Configurations tab, you can add, update, and delete database connection settings.
The
menu lists all stored database connection configurations. Changing a selection updates all other component values according to the selected connection.This table shows the available options when a database connection is selected and
or is clicked.The remainder of the fields are populated from the Add New Database Connection or Edit Database Connection dialog box.
When configuration is completed, clicking $HCISITE\dbconfiguration.ini.
stores the connection properties inOption | Description |
---|---|
Database Connection | Specify a unique name for the connection. A duplicate name prompts an error message. |
Database Connection Timeout | Sets the maximum time in seconds that a driver waits when attempting to connect to a database after the driver has been identified. |
Select a database type from the menu. | |
Database URL | This defines the JDBC URL for the current
connection. When a new database connection is added, Database URL
must be in the same format as URL Format. Default values are shown in this field. Values in red must be configured. |
URL Format | This shows an example of the JDBC connection URL
for the selected database. You can refer to this when specifying the
Database
URL. The default port for Oracle is 1521 and for SQL Server is 1433. These are used when specifying the Database URL. |
User Name/Password | These defines the valid user name/password with which to connect to the database. |
Schema | This sets the database schema for the current
connection. This setting indicates that all the SQL Statements
running in the current connection should be available under this
schema. Click Schema selection dialog box, from which you select an available database schema for the current connection. to open theThis field is optional. For the oracle database, if schema is not set, the IDE uses User Name as the default schema. When configuring a Database Inbound/Outbound protocol in Network Configurator, the schema must be listed for the table/view name in the SQL statement. This is only if the selected schema does not belong to the selected user. If the listed schema in dbconnection.ini does not match the default schema in Schema, then this schema name must be used as the table name prefix in the SQL statement. This is the statement that is used in the Database Inbound/Outbound protocol. For example, if the default schema that is shown on the Database Configurations tab for user1 is schema2, then the dbconnection.ini configuration is:
On the SQL statement
of the Database Inbound/Outbound protocol,
Note:
tablename is under the schema
schema1 in the external
database. If |
SQL Statement |
Specify SQL statements in this field. This field is optional. The default value is empty. You can use multiple lines. These values are saved in the $HCISITE/dbconfiguration.ini file. Database Connection must have a selection before this can be saved. |
This property ( Options are:
The default value for uncertified databases is
This option is only useful if it is another database, not Oracle, SQLServer, SQLite, or PostgreSQL. If the database is one of these, then the option is not available, and is not required. Other databases are configurable. |