Database Setup

Top  Previous  Next

Under the main menu item 'Database' the first option is "Connection and Data Fields"

 

DatabasebaseMenu

The menu under 'Database'

 

When you click on it the following screen comes up

DBSetup

Database connection and data fields

 

On the left side of the screen you see the connection setup, here again in detail

 

Connection

Defining the connection parameters

 

Database Type ---  is either ODBC or Microsoft SQL Server either with Windows Authentication or with explicit credentials (If you need other types, please contact us for customizations)
Database Server Name or DSN  ---  In case of SQL server this is the IP address or the name of the database server, for ODBC this is the Data Source Name (DSN) that is defined through the ODBC setup in the Control Panel of Windows
Database --- This is the database under the above connection, usually not needed in ODBC setup.
Username  ---  A defined user that has privileges to the database, usually not needed in ODBC setup
Password --- Usually not needed in ODBC setup.
Claim Status Header Table Name  ---  The name that you give to your Claim Status header table.  A default name is suggested but can be changed
Claim Status Detail Table Name  ---  The name of the table that contains the line information.  A default name is suggested but can be changed

 

You can create the tables through a separate screen.

 

 

 

After filling in all the information, save the information and test the connection by clicking on the "Test Connection" button.

 

After establishing a connection and the existence of your tables is verified, you will see a message

 

DatabaseSuccess

Establishing a connection to the database

 

 

 

 

 

You cannot export Claim Status requests before this connection tests successfully.