September 29, 2009
Implementing B2MML In LIMS
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...
Posted by Jeff Vannest at 11:27 AM | Comments (0) | TrackBack (0)
September 24, 2009
Interfacing SQL*LIMS v5 to a Global ERP
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...
Posted by Jeff Vannest at 06:59 PM | Comments (0) | TrackBack (0)
December 08, 2008
Completing a PDF Form using SQL*LIMS v5
I am intrigued with the possibilities offered by the Applied Biosystems SQL*LIMS v5 architecture, which relies on the Oracle Application Server software for the on-screen forms and printed reports. Like the article, “XML Reporting in SQL*LIMS”, this article will use the Oracle AS...
Posted by Jeff Vannest at 03:44 PM | Comments (0) | TrackBack (0)
May 05, 2007
XML Reporting in SQL*LIMS
For several years my boss, Brian, has been telling me that the perfect solution for a LIMS Certificate of Analysis report would use a solid data extraction algorithm and a flexible XML output. The idea has always sounded interesting to me, except for the fact that the SQL*LIMS product doesn’t include the technology to do such a thing…until now. Today’s article describes how...
Posted by Jeff Vannest at 10:14 AM | Comments (0) | TrackBack (0)
November 02, 2005
How to create an FTP Interface in SQL*LIMS
I've demonstrated the creation of two types of custom interfaces in SQL*LIMS version 4.1: email and memo. The final interface type I'd like to demonstrate is FTP. First, let me qualify that I don't believe the creation of a custom FTP interface using PL/SQL is the best solution. However, I can certainly see advantages and simplicity in transferring data directly from a programmatic procedure without needing to write it to the sending...
Posted by Jeff Vannest at 09:04 AM | Comments (0) | TrackBack (0)
October 12, 2005
How to create a Memo Interface in SQL*LIMS
In my last article, I demonstrated how to create an email interface in SQL*LIMS version 4.1. Such an interface provides robust functionality but there is a catch: using email for CFR 11-related communication is difficult to validate, and in many companies, may function as the sole method of notification. To get around these concerns, SQL*LIMS offers the memo, which is an application-specific notification stored in the Oracle database....
Posted by Jeff Vannest at 03:44 PM | Comments (0) | TrackBack (0)
September 17, 2005
How to create an Email Interface in SQL*LIMS
In SQL*LIMS, a PL/SQL package can be installed as an event and attached as a status action in any template or instance object level. This offers the LIMS developer a robust environment in which to execute a wide variety of custom actions. For example, most versions of SQL*LIMS come with an example PL/SQL procedure for executing cross-task calculations. However, in order to make this example code robust enough for regular use, a developer...
Posted by Jeff Vannest at 09:40 PM | Comments (0) | TrackBack (0)
June 09, 2005
Java Monitors in SQL*LIMS 4.1
Java is a language that has gained much popularity. This is partially due to its ability to run on most computing platforms. However, if you try to run a java program as a Windows monitor on the application tier of a SQL*LIMS version 4.1 installation, you will notice that it doesn't seem to work. In this article, I'll demonstrate how to run a java program as a Windows service using a helper program already delivered with the SQL*LIMS...
Posted by Jeff Vannest at 05:53 PM | Comments (0) | TrackBack (0)
April 08, 2005
Validating Email
In the past several years the email client has become central to the user desktop, and for good reason. My email program (Outlook) contains more than just electronic correspondence; it has contact information for co-workers and customers, work and project calendars, personal reminders, and lots of other mumbo-jumbo I usually can't recall without some kind of help (like my mom's birthday). However, while LIMS users clamber to receive system...
Posted by Jeff Vannest at 10:35 AM | Comments (0) | TrackBack (0)
March 12, 2005
Pittcon 2005
Our goal was simple: visit every LIMS software vendor at Pittcon 2005 and take a full day to do it. Unfortunately, it turned out to be more difficult than we anticipated.
Posted by Jeff Vannest at 09:26 AM
