October 05, 2009
Upgrade Web Services in Oracle Application Server 10g
The OracleAS 10g software is, among other things, a robust application container for web services. It has integrated performance monitoring, web service clients, and several other add-ons that make it a pleasure to work with. However, all of this is built on top of a somewhat dated web service technology,
Posted by Jeff Vannest at 09:29 AM | Comments (0) | TrackBack (0)
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)
September 25, 2007
I Like Your Mousetrap, Really!
I’ve reflected on more than one occasion that independent consulting is a strange business. We’re neither vendor nor customer, although obviously, it’s in our best interest to be very friendly with both. It is, therefore, really problematic when an independent consultant gives opinions like “I wish customers acted like this,” or, “I wish vendors built things this way,” since the risk is that no matter what is said, it might be...
Posted by Jeff Vannest at 08:58 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)
March 09, 2006
Oracle Technology Day 2005
A day off work is always welcome – especially when it comes under the guise of "professional training."
Posted by Jeff Vannest at 04:55 PM | 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 20, 2005
The "S" Reality
Good consulting is based on good decision-making. Good decision-making is supported by knowledge, experience, and the quality ideal. Because I have a particular interest in the formation and expression of quality, I was fascinated by a certain book I am reading about the "S" reality.
Posted by Jeff Vannest at 07:48 PM | 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)
