Topbar versions higher then 2.7 are compatible with Zedmed v31+. However due to high frequency of database polling to detect changes, the Zedmed server consumes lot of resources. The CPU consumption of FireBird (database used by Zedmed) service can reach up to 75%. This slows down the Zedmed server. Despite enhancements to the Zedmed database structure, the performance issues were not resolved.
In Zedmed versions prior to v31, Topbar used SYSDBA default password to monitor database changes. But from Zedmed version 31, Zedmed team has removed the SYSDBA default password. So Topbar had to use the user INTEGRATOR to monitor database changes. The INTEGRATOR user doesn't have access to FireBird Trace, which means that using the INTEGRATOR user Topbar doesn't receive updates when data in the Zedmed database changes.
Solution
Working together with the Zedmed development manager it was agreed to use the SYSDBA user, provided the clinic is willing to share the SYSDBA password with Topbar. In Topbar version 2.8.3, we have added a text-box in the Application Settings Tab to accept the SYSDBA password. Once a clinic administrator enters the SYSDBA password in Topbar, Topbar will encrypt it and save it in Topbar's database. The password doesn't leave practice. Topbar will use the SYSDBA password to read changes in the database. This is the same way the older Topbar versions were able to access the events in Zedmed.
Topbar Setup
Clinic administrators should know the SYSDBA password. If they don't know they can request it from Zedmed support team. Email: support@zedmed.com.au
Clinic administrators can add the SYSDBA password on the Application Settings Tab in the Settings. The SYSDBA password text-box will only appear for clinics using Zedmed v31 or above.
The SYSDBA password is not mandatory to use Topbar, but it will improve performance considerably and address issues you might have experienced. Clinic administrators can choose not to enter SYSDBA password and continue using Topbar with INTEGRATOR. Using Topbar with INTEGRATOR user may slow down the Zedmed clinic server for the reasons explained above.
Once the connection test is successful, Topbar will request to restart the PCS Clinic server. The message in green in the above screen shot. If the connection test fails, the entered password won't be saved in the Topbar database. Once the SYSDBA password is saved in the Topbar database and after the service restart, Topbar will use SYSDBA user to read the database.
Possible Error
If the clinic administrator has neither added an INTEGRATOR nor SYSDBA password, Topbar will show the following error message.
This message will only appear for clinics using Zedmed version 30 or above. Topbar will work fine without INTEGRATOR or SYSDBA password for clinics using Zedmed version below 30.