Plug and play LIMS – did it become a reality? Even though more things can connect to more other things, plug-and-play still isn’t reality.
In the Last Week-and-a-Half
Just in the last week, this is a partial list of a few of the tools I’ve had to download and/or use. It doesn’t even include the LIMS products and their proprietary tools:
- Chrome Browser
- Safari Browser
- Firefox Browser
- AEM (Adobe Experience Manager)
- SSMS (SQL Server Management Studio)
- MS Excel
- Google Sheets
- MS Word
- Google Docs
- MS Azure
- AWS (Amazon Web Services)
- A wiki
Does your life look like this? I hope not. And if you’re wondering how many different logins I now have for everything, just don’t ask…
Have Things Changed? Not That Much
In the old days, many things did not work together. To get anything to work with anything else took programming.
Ummm…it sounds just like right now, doesn’t it?
So, every LIMS-to-SAP or LIMS-to-MES or any other something-to-something interface is a lot of programming, for starters.
Plug and Play LIMS – a Turnkey System
Just like the concept of the “turnkey” system, which still is just something sales people talk about and none of us actually have, a plug and play LIMS doesn’t seem to be a reality, either.
There are always more tools. Professional-level tools tend to need some work to get them to work with other tools. Here in 2020, anyone that believes these marketing terms really hasn’t been paying attention to the world around them.
Back to Plug and Play LIMS
In any case, as I go from project-to-project, people are using a wide variety of different tools. Today, while more tools can be used with more different situations, they don’t necessarily entirely integrate.
Even as the most simple example, with many LIMS, we tend to create database queries that we can run from inside the LIMS but that are in the native query language. One traditional example is that, with something like the LabWare LIMS / ELN, we often write the more complex queries using SQL. Most people think of SQL (Structured Query Language) as something so standard that we can port it from machine-to-machine. However, anyone who has ported their LabWare LIMS / ELN to their desktop to use with a database besides the one they are using at a network level might find that their queries won’t necessarily run. That is because there are slight differences between different databases. A command that works in SQL Server might not work in Oracle and vice versa.
So, even within something we think to be pretty standard, such as SQL, it doesn’t just port from one database to another.
Here’s another example – if you’ve worked with any mobile applications, you’ll see that screens render differently between different models of what is the same brand and type of device. Programming for mobile devices has gotten more standardized but there are still individual program blocks that have to be created specifically for various devices.
A Note on Interfaces
For all the LIMS-to-ERP, LIMS-to-MES, LIMS-to-etcetera interfaces we’ve created, each one has slightly different issues. Granted, each time there is a new combination, a new set of people are assigned as if it’s a 100% brand new concept, to do everything as if it has never before been done. While I find that ridiculous and frustrating that few services companies know how to leverage the experience that’s out there, I’ll admit that there is always some aspect that is different. Each customer does have their own custom tables and fields, for example. That is NOT the same as being 100% brand new – I just want to stress this point! However, let’s admit these are never plug-and-play, either.
No matter how time marches on and how much things change, in some sense, they remain the same. We still have a multitude of different tools. Things don’t “just work” together. Thus, there is always a lot of money to be made in any tasks that pull data out of the system. That’s true whether that data is pulled out for something like knowledge management or to interface with other systems.
Unfortunately, this means that many companies will remain without as many interfaces as they’d like. There’s limited money to make all this happen and that’s just the bottom line. Companies might dream of more automation but, in the end, are limited by their budgets for these types of projects.
With that said, it’s as if they all got together and made a secret plan to purposely use all entirely different tools. Yes, it’s a LIMS conspiracy and I’m a LIMS conspiracy-theorist! 😉