Intro

This article covers the unique setup steps required for installing the Site Connect agent on a Windows server that hosts Office Practicum EHR.

If you have requested an install service with Datavant Site Connect team, we recommend you complete the General and ODBC Config sections prior to the scheduled install call.

If you chose to do self install, please complete the steps in all sections below.

General

1. Office Practicum requires Firebird ODBC driver. This driver allows an ODBC connection to interbase file types, which is what Office Practicum uses. Install either the 32 bit or 64 bit driver here: https://www.firebirdsql.org/en/odbc-driver/
2. Once installed navigate to ODBC Manager by searching windows for 'ODBC', choose the bit version that matches the server you are on.

3. Go to 'User DSN' and click add, when prompted for a driver choose the Firebird driver you just installed. The below menu will then pop-up.

   

ODBC Config

1. You will now see a screen like above, (NOTE: 'Driver' section will not be there, it uses iscDbc by default now) Fill in the configuration similar to how it is pictured above.
   1. Data Source Name: This is what will be put in as db_database in the Jump Agent.
   2. Description: Anything the practice wants
   3. Database: Search the server for their Gdbmed directory and find the MEDICAL.GDB file and use that.
   4. Client: Differs based on 32 bit & 64 bit, 32 bit will be C:\Windows\SysWOW64\gds32.dll and 64 bit will be C:\Windows\System32\fbclient.dll this can vary depending on where Firebird was installed at, poke around and try different gds32.dll files if you run into architecture mismatch error
   5. Username/PW: If Office Practicum has created a DB account for the practice before it will likely be READ_ONLY and R3AD0NLY . If these credentials do not work then the practice will have to ask Office Practicum to create a read-only database account for them.
2. Test the ODBC configuration by hitting "test connection" if it succeeds proceed to fill out the Site Connect agent GUI.

Site Connect Agent

1. In the Site Connect agent GUI, choose 'FileODBC' as the db_driver and then enter the data source name of the ODBC you just configured.
2. No other fields are used because the Site Connect Agent will utilize the ODBC that was created. Nevertheless, we recommend you enter the Username and Password for future reference.