Skip to Content
avatar image
Former Member

SAP MII General

Hello,

My company has a LIMS system that works with an Oracle or a SQL Database, and one of my clients starts to use SAP MII and ask me to do the communication between SAP MII and my system. So, my question is, how does it work? Should I need to develop anything else, or I just need to use the Data connectors that MII already has and acquire the data directly from my database?

I never did something like that, so, what is the steps should I do to make this interface to my client?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 10, 2008 at 09:55 AM

    Hi,

    Even i never tried of configuring an SQL database into an xMII system.

    In either 11.5 or 12.0 version of xMII you can configure an SQL server through "Data Services" tab. Under this there is one link named "Data Servers" where you can configure any data server other than SAP server.

    While creating a new data server we have to provide following details.

    Connector = IDBC

    ConnectorType = SQL

    DatePrefix

    DateSuffix

    Description

    Enabled = True

    InitCommand

    InternalDateFormat = yyyy-MM-dd HH:mm:ss

    JDBCDriver

    Name

    PoolMax = 256 (Maximum connection)

    PoolSize

    ServerPackage

    ServerURL

    Timeout

    UseCount

    UserName

    ValidationQuery

    WaitTime

    Just try and let me know it works.

    Thanks,

    Rajesh Sivaprakasam

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2008 at 05:56 AM

    Hi Felippe,

    Mostly, you will create an IDBC type data connector to the database of LIMS system. Depending on SQL and Oracle database, the connector configurations would be different. MII could then query the database and fetch LIMS data. With the same connector MII can update the database as well. You will need to create SQL query in MII with respective SQL statement.

    Edited by: Sameel Baker on Sep 11, 2008 7:57 AM

    Add comment
    10|10000 characters needed characters exceeded