Database Connection Settings - IAConnect - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

IAConnect

Platform
OnBase
Product
IAConnect
Release
Foundation 23.1
License

The Database Connection Settings tab is used to configure the connection to the ERP database, so that IAConnect can communicate with it using SQL calls.

Note:

The Database Connection Settings tab is replaced with the Costpoint Connection Settings tab when Use WIC-Based Calls for Costpoint Lookups is enabled under Administrator Settings.

Enter the information in the Costpoint Settings section on the left to configure the connection to the Costpoint database.

If you are using Costpoint 7, you must also configure the connection to the Costpoint Admin database. Select the Is CP7 option to enable the Costpoint Admin Settings section on the right and configure the connection.

Both areas include the following fields:

Option

Description

Host Name

Enter the database system name.

Login Name

Enter the name used to log in to the database.

Password

Enter the corresponding password used to log in to the database.

Port Number

Enter the port number used to connect to the database. Standard ports include 1433 for SQL Server and 1521 for Oracle databases.

Database Type

Select the type of the database, either SQL Server or Oracle.

Database Name

Enter the name of the database.

You can use the Test CP Connection and Test Admin Connection buttons to test the configured connection settings for the respective databases.