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.
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.