Database Connection Settings

These are the settings for the SQL or Oracle connection strings that are used by Invoice Processing Agility.

Important These options are not available in the Azure cloud environment.

The various database connection strings are entered here and can be used for the various purposes. For example, you can use the database connection strings defined here as follows.

  • Export to database

  • Database lookups

It is possible to add multiple entries for these settings. As a result, the settings are displayed in a table.

You can add additional table rows as necessary.

The following column settings are available.

Connection Group ID

The connection group ID.

Connection String

The connection string for the SQL connection group ID.

Encrypted Password

The encrypted password for the SQL connection group ID.

As you type in a password in the Connection String, the characters are displayed exactly as typed. When you save your changes, the password text is masked with asterisks and the Encrypted Password field is populated with the encrypted password value automatically.