Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question