By Jeff Vannest, Senior Consultant
In the process of implementing an ERP to LIMS interface, one of the challenges to overcome was how to clearly communication between Oracle E-Business Suite (EBS) and SQL*LIMS v5. In the past, I had been exposed to several methods of interface communication, text files containing single bits of data, records inserted directly into a database, and concatenated strings transmitted over a network. Each of these methods had at least one serious flaw: if the data structure changed the interface stopped working. This article will review how Business To Manufacturing Markup Language (B2MML) was used to robustly transfer data and instructions between an ERP and LIMS system.
By Jeff Vannest, Senior Consultant
Most of this year has been spent designing and writing an interface between SQL*LIMS v5.1 and the new Enterprise Resource Planning (ERP) system being implemented by a global pharmaceutical manufacturing company. The goal was threefold: notify LIMS system administrators of changes made to materials, vendors, and manufactures; automatically create and update lots in the LIMS system; and send lot statuses and results from LIMS back to the ERP when testing was complete. This article will review the decision-making process used to plan and develop the interface.
The Ideal LIMS Solution for the Water, Wastewater Lab is a function of the right company, the right technology and the right features and functions for your needs. All supported by first class training, implementation and maintenance and support services. LABLynx is the Ideal Solution for your lab or enterprise, no matter how large or small, or how you choose to manage your own unique workflows, individual processes and data.
There are many types and sizes of laboratories, as we all well know. Let’s face it though, not many labs are very large, in fact, most have fewer than 25 people. So given this fact, does it really matter what the answer is to the question: “Mirror, Mirror on the wall, what is the largest LIMS of them all?” Well…. you decide.
In today’s world, the idea of building your own LIMS is becoming a thing of the past. There are many good products to choose from; but in case you are thinking of having a LIMS built for your lab, consider this image… A home grown LIMS can sometimes be a pretty good representation of a very large bug.
While surfing the
web this evening and doing a bit of research on using blogs, wikis and other
common tools for scientific data management, I found a number of very
interesting blog articles on an open system for Collaborative Science called
“myExperiment.org”.
The following presentation provides an overview of the Enterprise Software needs of the modern Pharmaceutical Laboratory. Today’s challenge for the diversified pharmaceutical laboratory is to find a comprehensive enterprise software solution that provides not only LIMS functionality but an Electronic Laboratory Notebook, Enterprise Content Management and a wide variety of functions for personnel management, asset management, instrument interfacing and much more, all within the context of being validated and fully compliant with 21 CFR part 11.
The people who implement the LIMS should sell the LIMS.
I was talking to an associate the other day and a strange conversation developed around sausages. Personally, I am rather fond of sausages but that is not the point of this blog. This blog is how LIMS are like sausages.
caTissue Core is caBIG’s tissue bank repository tool for biospecimen inventory, tracking, and basic annotation. Version 1.2.2 of caTissue permits users to track the collection, storage, quality assurance, and distribution of specimens as well as the derivation and aliquotting of new specimens from an existing ones (e.g. for DNA analysis). It also allows users to find and request specimens that may then be used in molecular, correlative studies.
Ardenno Solutions, Inc. (pronounced R-den-O) is a provider of Collaborative Knowledge Management and secure Enterprise Search software solutions for businesses to enable teams and individuals to leverage and utilize existing internal data sources and database content across your entire enterprise. Ardenno is purpose built to deliver benefits without adding to your project workloads.
The following on-line video provides a tutorial primer on ISO 17025 and how a LIMS can help your lab with the issues surrounding compliance with those standards and requirements. Audio speakers are highly recommended when viewing this video.
LIMS software (short for laboratory information management system) refers to a variety of different laboratory software systems which are designed to streamline the workflow of routine tasks and processes in the laboratory, as well as in other environments. These LIMS systems are generally rather versatile and configurable, making them adaptable to a wide variety of different applications in or out of the laboratory environment.
With LIMS, ELN, SDMS and other Laboratory, Scientific and Health Informatics websites and disucssion groups popping up all over the Internet, we all need one place to go to that consolidates and aggregates all of these postings, articles, videos and other such good information. Well here is the first start of that... http://www.limsnews.com. Don't worry, it is not another me too information source. It ONLY aggregates all the stuff that already exists but puts it in one place so you don't have to hunt down information you find useful.
I’m using this post to comment on the most popular Software as a Service (SaaS) myths which seem to be circulating the Web in what I believe is a feverish pitch and last ditch effort by non-SaaS software companies trying to inject FUD (fear, uncertainty and doubt) to slow the most impressive industry movement and technology disruption we have witnessed in at least the last 20 years.
“It’s not what you know, it’s who you know.” The adage still holds true and in a tight economy with jobs at a premium it can be a critical issue for those outside the inner circle. But just like so many other issues in various industries, it’s technology to the rescue; this is especially true in the laboratory, scientific and technical professions.
The following presentation provides a practical application of Internet based social networking sites to enable success of most any complicated project. You can see its uses to LIMS projects or most any type of project.
Washington, DC – Senators Joseph Lieberman (I-CT) and John Cornyn (R-TX) today introduced the Federal Research Public Access Act (FRPAA), a bill to ensure free, timely, online access to the published results of research funded by eleven U.S. federal agencies. The proposed bill is welcomed by the Alliance for Taxpayer Access, a coalition of research institutions, consumers, patients, and others formed to support open public access to publicly funded research.
Centralized Bioinformatics Core Facilities provide shared resources for the computational and IT requirements of the investigators in their department or institution. As such, they must be able to effectively react to new types of experimental technology. Recently faced with an unprecedented flood of data generated by the next generation of DNA sequencers, these groups found it necessary to respond quickly and efficiently to the informatics and infrastructure demands. Centralized Facilities newly facing this challenge need to anticipate time and design considerations of necessary components, including infrastructure upgrades, staffing, and tools for data analyses and management.
A number of years ago, I wrote a blog entitled, "The king is dead, long live the king". You have probably been hearing about the demise of the numerous, old and venerable newspapers. It is clear now, while the print media king is not dead yet, there is not much life left. Now consider the fate of such trade shows as Pittcon and how much life is left for this particular king. Why would the survival of Pittcon be in question? The simple answer is that there are good alternative technologies that make Pittcon redundant.
