Setting up Database Connection
|Top Previous Next|
The HIPAA Claim Payment Master natively treats a payment advice record as a single object. The application extracts the complete payment from an EDI file into its proprietary data object. It can translate and export this data into any ODBC-compliant database such as Microsoft SQL Server, Oracle, etc.
1. Select Data Export 835 Connection and Data Fields in the main menu.
2. You will be confronted with the following screen where you can set up the database connection and enter the names of the database tables.
The ODBC Administration screen in Windows
Define the database connection properties:
To create tables in your database, click on the "You can create the tables through a separate screen" link. For instructions, refer to Creating Tables.
Once the connection parameters have been entered, click "Save Connection Information."
To verify if the entered parameters are correct, click on the "Test Connection" button.
If the test has passed successfully, you will see the following notification:
Once the test has passed successfully, the "Connection not checked" message changes to "Connection chеcked."
Once you have the database connection defined and tested, you can enter the table names. See Selecting Fields to Export.
If you need to create the tables first, then see Creating Tables.