Database Setup

Top  Previous  Next

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



The menu under 'Database'


When you click on it the following screen comes up


Database connection and data fields


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



Defining the connection parameters. Note that this image shows the check mark at "Save Responses in database"


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.
Eligibility Header Table Name  ---  The name that you give to your Eligibility header table.  A default name is suggested but can be changed
Eligibility Detail Table Name  ---  The name of the table that contains the line information.  A default name is suggested but can be changed
Eligibility Response table name -- This box shows up if you choose to save the response information.


You can create the tables through a separate screen.

If you select to save the responses in the database, you will see 3 more text fields appear


Checking to save responses reveals 3 more fields


Covered Members
Covered Benefits
Request Validation


These three tables are used to store the manually created responses or they contain the member and benefit data for the creation of the automatic response. In addition to the 3 fields, you will also see another tab showing the fields of these three tables.


The tab with the fields of the response tables


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



Establishing a connection to the database


You cannot export eligibility requests before this connection tests successfully.