Integration LIMS and MII

[Former Member]

Hi,

What are the possible ways integrating LIMS with MII and how we can do this. Is there any examples or someone make me understand how this is accomplished.And i would also like to know how MES is placed here, any recommendations with regards to the best practise available.

Thanks,

Raveen

Edited by: raveensap on Mar 22, 2011 1:08 PM

[agentry_src · Accepted solution]

In my past experience, there were straight database connections as an option and there were also web services (if I remember right) available between MII and LIMS. There may also have been transfer tables used.

Regards,

Mike

[Former Member]

Thanks for the comments

[Former Member]

LIMS information is collected typically collected in a relational database (ORACLE). The information that most users are interested in are divided amongst three tables: SAMPLES, TASKS, & RESULTS. You can either build materialized views, or you can just use straight views into these three tables.

The real trick is that the information is fairly complicated, and unless your LIMS coordinators are very strict about changes in there assay strategies, these data tables can be an absolute bear to map against. This basically means, that I highly encourage you to suggest using a data warehouse or data store for the parameters of interest.

[Former Member]

Normally LIMS data is just stored in a relational database and you can directly connect to it from MII with the IDBC SQL connector using the installed oracle JDBC driver. For us, both LIMS and MES are in relational databases (Oracle) so we have a separate connection to each database and then combine the data as needed in the BLS for whatever the business purpose is.

Nothing special was needed at all.

Thanks,

Kerby

[Former Member]

Hi Kerby,

Can SAP QM can be replaced with LIMS and integrate with MII?

Thanks,

Raveen

[Former Member]

Hi Raveensap,

I'm not familiar with SAP QM. I would assume so since MII can connect to SAP and get data from it to use for normal MII manipulation but you would want to check with someone from SAP directly about that.

Thanks,

Kerby

[subramaniyan_thangavel]

Yes, SAP QM can be replaced LIMS, But you need to do more customization in SAP Part, Here SAP MII involve in Lab Instrument (Including Chromatography ) and also with other sub-systems integration. I have involved in this kind of project

Subramaniyan Thangavel

[Former Member]

Hi,

Is it possible to share any document what kind of customization or configurations need to be done.

Thanks,

Raveen