Interface Engine Maintenance

An interface engine can act as the heart of dataflow in an enterprise, as it facilitates the transfer of data from one application to another. As with any system, there are certain things to be mindful of in order to keep dataflow moving in a reliable manner 24 hours a day, 7 days a week. After working with numerous interface engines for over 16 years, I have inevitably run across several “best practices” that have withstood the test of time. Among these are: interface and application endpoint documentation, interface contingency alerting, server health monitoring, and high-availability assurance.

DOCUMENTING INTERFACES

Good documentation provides a map of the interfaces in place. The best integration shops have them, unfortunately this is more an exception than the rule. Good documentation does not need to be complicated. While Visio diagrams are ideal, a spreadsheet can be a great start. Each interface can be assigned a row and given a unique id on a spreadsheet; include the interface name, a brief description and a column with a reference (typically a unique identifier) to the interface(s) it feeds, separated by a comma. You can always add other columns later to indicate the interface’s dataflow source and destination address. Keep it simple, then you can go for greater sophistication later.

INTERFACE ENGINE ALERTING

Unless you have a very small number of interfaces, a dedicated 24 x 7 help desk, or adopt a reactive stance by which you depend on your application users to notify you of delayed data updates; having automated alerting is a must. In a nutshell, automated alerting lets key people in your organization (including vendors) become aware of interface problems before your users notice something is wrong with the timely interfacing of data. Automated alerting allows for interface connectivity, message processing or delivery problems to be reported via a dashboard, email or texting medium. Just about every interface engine has these capabilities built into it. Having a dedicated SMTP email account can be a starting point for automated, real-time alerts that will reach key support team members quickly and proactively.

SERVER HEALTH MONITORING

Alerting does not have to stop at the interface engine. The server in which the interface engine resides requires continuous monitoring. If available, the interface engine’s built-in alerting system may monitor important server resources such as disk storage space, CPU, RAM, network or disk resource utilization and alert if any thresholds are crossed. Other interface engine components such as database servers, should also be monitored and alerted. There are also third-party tools, such as The HCI Solution’s Sentry, that can supplement, if not provide full monitoring support for these vital server monitoring and alerting functions.

CONTINUOUS OPERATION BEST PRACTICES

While alerting provides insights into what is happening now, it should still be considered a reactive component of an interface management regime. A “trending approach” should be adopted as a proactive component of best interface engine management practices, as it can help you spot problems BEFORE they exacerbate into a dataflow stoppage or even data loss.

System resource utilization trends will not only indicate when there is trouble brewing (i.e. dwindling disk space or higher than usual network bandwidth utilization) but can also be of use when it comes to long-term planning. Tracking CPU, RAM, and disk usage trends should be placed alongside interface engine utilization metrics on a daily, weekly and monthly basis with message/transactions as a primary source from which to derive overall data usage bandwidth. A calculated average message size multiplied by the number of messages for each interface can provide a more accurate throughput metric (MB/GB’s per 24 hour period) than total message counts, as message sizes can vary greatly. Data mining interface engine databases or message logs are alternate ways of accomplishing this key task.

BECOMING A SUPER-STAR: STRESS TESTS AND HIGH AVAILABILITY

If you really want to be proactive, run periodic “stress” tests by submitting a batch of messages through a test interface, recording the time it takes for that batch to process and trending the “time to delivery” over time. This is a great way to measure the engine’s message processing performance vis-à-vis the engine’s current workload. Other strategies such as virtual machines and high-availability software solutions such as Microsoft Cluster Server can make it easy to keep the interface engine dataflows running 24 x 7 while operating system patches, hardware or any other events that may bring the engine offline.

CONCLUSION

Similar to your own biological heart, an interface engine is the heart of data flowing throughout your enterprise. Just like frequent exercise, good eating habits and routine monitoring of your body’s vital signs throughout your lifetime can keep your cardiovascular system in top shape, the same applies to interface engines. Understanding what those components are, tracking their performance, and utilizing a regime of software tools and best practices, will keep you running 24 x 7 and avoid the nasty surprises that occur several years down the road when you least expect them.

To learn about The HCI Solution’s Interface Engine Services  CLICK HERE.


LinkedIn

Testimonials

ENGINEERING CONCIERGE Peterson Health is a private, 124-bed, not-for-profit community-based healthcare facility located in Kerrville, Texas. Peterson Health has focused on providing patient-centered care for over 65 years, serving the people of Texas Hill Country....

Testimonial- Sturgis Hospital

[row]

[span7]

about

TESTIMONIAL: SyncSolve


[/span7]

[clear]
[/row]

[row]

Sturgis Hospital, Sturgis, MA

November 25, 2013 – Mark Olsen, Clinical I.T. Director
“We had our Go-LIVE date; after we were given the OK to go in and check for issues, I noticed that the MIS Inpatient Discharge dictionary was totally empty and had not been moved as anticipated. We recently had implemented the SyncSolve tool, but I did not think I would need to use it yet. With the Go-LIVE in progress, I decided this would be a good opportunity to test SyncSolve. I opened SyncSolve, entered the necessary DPMs and, within a few minutes, the MIS Inpatient Discharge dictionary was populated completely.

“The entire process could not have taken more than five minutes. The SyncSolve tool provided the perfect answer to what would have been a very time-consuming manual dictionary build, allowing us to bring the EHR live without an extensive delay.

“I am now using the SyncSolve system to monitor changes in our dictionaries. With the Computerized Physician Order Management (CPOM) system, it is critical to know if there have been changes made in the Laboratory or Radiology procedure dictionaries to ensure appropriate function of CPOM. Any changes to the mnemonics will cause the order to be cancelled without notification to the person ordering the test. This has caused issues in the past that will now be detected very easily.

“We will be using the SyncSolve tool in the future to move the Intelligent Medical Objects (IMO) mapping into the LIVE system that is currently being done in the TEST system.”

December 27th, 2013 – Mark Olsen, Clinical I.T. Director
“I was ‘kicked to desktop’ when attempting to move an OE Order Set for an Admission that has 83 orders. Then I attempted to manually build in LIVE and I got ‘timed out’ and lost it when I was over halfway done. THEN I REMEMBERED SYNCSOLVE!!!! Within a minute, I had both order sets moved to LIVE. It was a great feeling.”

March 14th, 2014 – Mark Olsen, Clinical I.T. Director
“In the past, Meditech allowed the moving of a CDS, and it would ‘overwrite’ the CDS in the destination dictionary. First, it would ask if that is really what you want to do.

“Now, if I have a CDS in TEST and LIVE that is ‘waiting’ to be implemented, and a change is required at the last minute, the change does not always get moved. Spelling errors that are found and corrected in TEST have to be made in LIVE manually. Basically, the queries that exist on the CDS in the destination dictionary are not altered by the move. SyncSolve makes the changes to these queries. Meditech is making SyncSolve become more of a necessity.”

[span3]

[/span3]

[clear]

[/row]

Testimonial- Heywood Hospital

[row]

[span7]

about

TESTIMONIAL: SyncSolve


[/span7]

[clear]
[/row]

[row]

Heywood Hospital, Gardner, MA

September 24th, 2014 – Sandi Wiltshire, MT(ASCP), MBA, IS Applications Manager
“SyncSolve has been a great help to us! We have always struggled, like so many others, with making sure all TEST and LIVE dictionaries match. SyncSolve can help with the monitoring and maintenance of the many modules.

“We spent months revising our Provider dictionary and it only took minutes to sync all that work, saving time and money.

“The Lab installed new Chemistry analyzers which meant the editing of dictionaries such as analyzer, lab tests, worksheets, departments, quality control, and rules. Most of this could not be changed in LIVE until the moment we went LIVE with the new instruments. SyncSolve allowed us to rapidly move everything from TEST to LIVE with no downtime and without spending hours inputting data.

“When I first saw SyncSolve, I knew exactly why we needed it, and it has paid off! We needed to put Meditech into our sister hospital, Athol Hospital, which meant all Meditech modules needed editing. We were able to use SyncSolve to move all the new ORM procedures, Scheduling Resources, and Appointment Types, Access groups, Users, Menus, Reports, and Procedures to name a few. We could build everything in TEST and sync to LIVE. SyncSolve has proven over and over that we can save time and money while improving the maintenance of our applications.

“We did have another product previously that we bought, but it was per license and not user friendly. It would take hours and days to run a sync and you basically had to build the script yourself. This product is not limited to users and is very user friendly, making it easy to run. We tell everyone about SyncSolve and highly recommend it!”

[span3]

[/span3]

[clear]

[/row]

Testimonials


[row]
[span7]

about

TESTIMONIALS

[/span7]

[clear]
[/row]


[row]
[span10]

Engineering Concierge

Peterson Health is a private, 124-bed, not-for-profit community-based healthcare facility located in Kerrville, Texas. Peterson Health has focused on providing patient-centered care for over 65 years, serving the people of Texas Hill Country. Peterson Health recently converted to MEDITECH Expanse from MEDITECH 6.07 as of March 1st, 2019.

“I can confidently say that our experience with HCI consistently exceeds our expectations.”

read more

Conversion

Halifax Health is the largest healthcare provider in East Central Florida providing a continuum of care through multiple organizations including a tertiary hospital and community hospital consisting of 678 licensed beds. Halifax Health is a Meditech Expanse health system that recently converted from Client Server..

“Having a single vendor with 27+ years’ experience in the Meditech space to handle all our engineering needs was the ultimate key to our success.”

read more

SyncSolve® as a Service

Cascade Valley Hospital and Clinics has recently become affiliated with Skagit Regional Health. Skagit Regional Health will now operate two hospitals (Cascade Valley Hospital and Skagit Regional Health), 18 clinics and offer 25 specialties in the North Snohomish, Skagit and Island counties of Washington. Cascade Valley Hospital is a MEDITECH Magic facility with version 5.67, while Skagit Regional Health is MEDITECH Client Server 5.67. They are integrating their databases and in the process of converting to the EPIC EHR.

“I would estimate this saved 120+ hours of building and data entry work.”

read more

SyncSolve®

Nexus Health System is a multi-facility system consisting of 3 specialty hospitals as well as a rehabilitation center and residential housing center throughout Texas and California. Nexus Health System is a MEDITECH Client Server health system with version 5.67.

“SyncSolve® is easily the best product we have purchased.”

read more

Data Conversion

Skagit Regional Health operates two hospitals (Cascade Valley Hospital and Skagit Regional Health), 16 clinics and offers 25 specialties in the North Snohomish, Skagit and Island counties of Washington. They have integrated their databases from different platforms and are in the process of converting to a new EHR.

“HCI has proven to be smart, effective and tremendously timely.”

read more

Cole Memorial logo

SyncSolve®

Cole Memorial is a 25-bed hospital committed to providing a comprehensive range of health care services, using the latest technology and treatments available. Our services include; prevention and wellness, diagnosis, inpatient and outpatient treatment, rehabilitation, home health care, and education.

“There are four pharmacists building in the TEST Pharmacy module for CPOE. All of the affected Pharmacy dictionaries will be moved to LIVE. Also, for the CPOE Project, we did a sync for the Nursing Dictionaries: Intervention, Intervention Set, Intervention Header, Diagnosis, Plan of Care, and Goal.

We had a new withholding in the Payroll Module. We did a Sync for the Payroll Withholding dictionaries, Earning dictionary, and the Table and Table Value dictionaries from LIVE to TEST. We built the new withholding in TEST and did the testing there.

The synchronization of the NMI Value Mapping dictionaries and the HL7 Administrative Site Entry dictionary was the best use of SyncSolve® with SyncIT to date. SyncSolve® saved me at least 40 hours of work.”

read more

Heywood Hospital logo

SyncSolve®

Heywood Hospital is part of Heywood Healthcare, an independent, community-owned healthcare system located in the North Central region of Massachusetts. It is comprised of Heywood Hospital, a non-profit, 134-bed acute-care hospital in Gardner, MA; Athol Hospital, a 25 bed not-for-profit, Critical Access Hospital in Athol, MA; Heywood Medical Group, a center with primary care physicians and specialists located throughout the region; and four satellite facilities -Winchendon Health Center and Murdock School-based Health Center in Winchendon, West River Health Center in Orange and Heywood Rehabilitation Center in Gardner.

“SyncSolve® has been a great help to us! We have always struggled, like so many others, with making sure all TEST and LIVE dictionaries match. SyncSolve® can help with the monitoring and maintenance of the many modules.

We spent months revising our Provider dictionary, and it only took minutes to sync all that work, saving time and money.”

read more

Sturgis Hospital logo

SyncSolve®

Sturgis Hospital is an 84-bed licensed, acute care facility. Nearly 40 active Medical Staff members, available within the Sturgis and surrounding communities, represent a wide variety of specialties including Anesthesiology, Family Practice, General Surgery, Gynecology, Internal Medicine, Obstetrics, Ophthalmology, Orthopaedics, Pathology, Pediatrics, Podiatry, Radiology, Urology, and Vascular Surgery. Additional specialties are offered through the Hospital’s Courtesy, Consulting, and Affiliate Medical Staff members. These services include Cardiology, Neurology, Neurosurgery, Oncology, and Pulmonary medicine.

“In the past, Meditech allowed the moving of a CDS, and it would ‘overwrite’ the CDS in the destination dictionary. First, it would ask if that is really what you want to do.

Now, if I have a CDS in TEST and LIVE that is ‘waiting’ to be implemented, and a change is required at the last minute, the change does not always get moved. Spelling errors that are found and corrected in TEST have to be made in LIVE manually. Basically, the queries that exist on the CDS in the destination dictionary are not altered by the move. SyncSolve® makes the changes to these queries. Meditech is making SyncSolve® become more of a necessity.”

read more

Southern Illinois Healthcare logo

SyncSolve®

Southern Illinois Healthcare Services is a not-for-profit health care system consisting of three hospitals: Memorial Hospital of Carbondale, a 140-bed tertiary care hospital; Herrin Hospital, a 114-bed acute inpatient and outpatient hospital; and St. Joseph Memorial Hospital, a 25-bed critical access hospital. Southern Illinois Healthcare hospitals are MEDITECH Client Server facilities with Version 5.66.

Jeffery Boomer and other staff at Southern Illinois Healthcare Services installed and began using SyncSolve® in March, 2015. Jeffery admits that using the product has been a “big eye opener in making us aware of all the discrepancies out there. The Pharmacy is very happy that their strings can be moved by the SyncSolve® application rather than having to be rebuilt manually. Those are very complicated. This is really the only product I have seen that takes the background work out of it.”

When asked if the SyncSolve® application was more difficult to use or more work than anticipated, he responded, “It’s not more work than I anticipated, and it’s more comprehensive than I would have given it credit for. I made the assumption that this product would do what other products do, which is have you develop your own scripting and then perform the synchronization. We tried working with another product to help us keep the rings synched. Two of us tried to figure out how to script for Pharmacy and we couldn’t do it.” “This is not a pure scripting tool. It opens up the background and works with the information there. Without a tool such as this, you could easily have a FTE (full time equivalent) involved to keep the rings synched,” Jeffery says.

read more

war_memorial_logo

Valco Replacement

War Memorial Hospital (WMH) is home to an 82-bed acute care hospital, a 51-bed Long Term Care unit, a 20-bed Behavioral health center, a 30,000-square foot Rehabilitation Center, and several satellite clinics located throughout the Eastern Upper Peninsula of Michigan. WMH is a MEDITECH Magic facility with Version 5.66 currently, moving to 5.67 this June 2105.

Cindy Dodds shares, “We began speaking with The HCISolution, Inc. was because they said it could be done. We sent them the specifications for the project and they confirmed it could be done. The sales and programming staff there seemed like they wanted to help us and wanted to partner with us. One of the main reasons we decided to go with The HCISolution is because they said they would give us all the functionality we wanted. We liked the clinical and business functions, and frankly we were surprised when they told us the clinical could be done as well.”

read more

SyncSolve®

Golden Valley Memorial Hospital (GVMH) is a not-for-profit, modern healthcare organization consisting of an 84 bed hospital, a home health service, and physician and outpatient clinics located in West Central Missouri. Multi-specialty physician clinics located in Clinton, Windsor, Warsaw and Osceola offer 30 providers, 11 specialties, walk-in clinics with extended hours, laboratory, radiology, diagnostic ultrasound and mammography services. GVMH is a MEDITECH Client Server facility with Version 5.66, PP6.

“SyncSolve® is a real asset for IT and the departments that we serve. It is the best time saving tool we have ever purchased for IT analysts.”

read more

[/span10]
[/row]