Waters Empower 2 Database Question

[christoforadams]

Hello Everyone/anyone.

I'm working with a LIMS group to try to import data from empower to Nautilus LIMS to minimize transcription errors. I know that we can use an export method to store data in a file that excel can read, and then we can parse that report into Nautilus.

I know that Empower 2 uses an oracle database, and I'm wondering if it is possible to simply pull data out of the database using SQL. I have heard that this can be a tall order- has anyone done this and know the whats, hows, and whys?

If it's not possible to querry the empower database directly using SQL, can anyone recommend an alternative strategy or software interface?

Thanks
Chris

[DR]

I suspect that your only (legal) options are 1) Buy the appropriate tools from Waters (Nu Genesis) or 2) use export methods. I'm pretty sure that writing your own code to query the Oracle DB directly is a big-time violation of the Empower EULA.

[aceto_81]

I've been looking a while for SQL queries directly pulling out the data of Empower, but found more cons than pros to do this as a replacement for the export methods we now use.

Our workflow:
Export the chromatographic results to a datafile and read this datafile with our LIMS.

You can create a custom field which holds an ID number to connect the right results to the right samples.
And we also import the Result_ID from the chrom to our LIMS, so we can easily find the used chroms for our samples.

HTH

Ace

[christoforadams]

Hi Ace-

While I personally like this idea (using the export methods) it is currently beyond my jurisdiction, so to speak. As a memeber of the LIMS group, I don't have access to the empower methods to update all of the projects- might be able to get it though.

Thanks so much for your help.

Also, if anyone else has any ideas I'm all ears.

I've been looking a while for SQL queries directly pulling out the data of Empower, but found more cons than pros to do this as a replacement for the export methods we now use.

Our workflow:
Export the chromatographic results to a datafile and read this datafile with our LIMS.

You can create a custom field which holds an ID number to connect the right results to the right samples.
And we also import the Result_ID from the chrom to our LIMS, so we can easily find the used chroms for our samples.

HTH

Ace

[postb8822]

I know this post is old, but we use Labware Lims and we both read and write to the Empower database directly from LIMS all the time.

Empower supplies something called the Tool Kit. The previous user was right when they said its not legal to do it via SQL queries, the Tool Kit gives developers an open door to the database.

Talk to your Waters rep and ask for Toolkit documentation

[aceto_81]

Talk to your Waters rep and ask for Toolkit documentation

You mean: buy the Toolkit documentation....
I did ask this a few years ago to our Waters rep.

Ace

[Klaus I.]

Hello Everyone/anyone.
I know that Empower 2 uses an oracle database, and I'm wondering if it is possible to simply pull data out of the database using SQL. I have heard that this can be a tall order- has anyone done this and know the whats, hows, and whys?

If it's not possible to querry the empower database directly using SQL, can anyone recommend an alternative strategy or software interface?

Of course is it possible to read the empower-database, but it is not supported by Waters.