ECC-MES integration

[Former Member]

Hi,

In a typical ECC-MES architecture are there any set best practices regarding whihc system needs to be the system of record for all master data ? Is master data maintained in ECC or MES or both ? Also do you need to do any data mapping between ECC master data and xMII and then xMII and MES ? and any data transformations ? If so what sort of activity is needed ?

Thanks

[agentry_src]

Master data is usually maintained in ECC and frequently a copy is kept in your MES systems. However some Master Data, like routings, may be maintained in the MES system as the MES may be more granular (more sub operations, etc.) than the routing maintained in ECC. Having said that, some companies maintain master data outside of ECC, but I do not recall whether the engineering system or ECC was the official system of record.

Regards,

Mike

[sidnooradarsh]

Hello,

As Mike said there is no such hard and fast rule but,

Keeping a copy of ECC Master Data into some DB would make system more efficient because IO hits made to ECC is more costlier and heavier than making calls to a DB with a simple query.

Plus the data like order details, confirmation details can be more effectively analyzed and viewed by drill down to sub-levels easily.

And I can schedule some transactions to re-fresh the copy of Master Data weekly once/fortnight and transaction data daily.

Regards,

Adarsh

[Former Member]

Hi,

It all depends on how we create application architecture.

Creating application database always helps.

1. Efficiency: As mentioned by Adarsh, DB would minimize costlier calls. (By minimizing time and processing)

2. Independent: Even if the connection is lost with ECC then application DB would still be used.

3. Real Time Data Processing: Creating big schedulers and fetching huge data from ECC would take more time and application may not be monitored on minutes level. By using separate DB, we can make application more real time.

Regarding data transformations, it again depends on your requirements. MII provides many data transformation options while connecting to Historian, DCS, etc.

Hope it helps.

Best Regards,

Kedar

[Former Member]

ok by DB you mean the one residing in the MES right ? As far as I know xMII does not have a database right ? Also where can I see the transformations for historians, SCADA system, PLCs etc etc.

[sidnooradarsh]

Hello,

The DB could be either of these,

1) As you told one residing in MES/Shopfloor system

2) A separate DB (MSSQL/Oracle etc) used by customer for other legacy applications

3) Can even go for new one too

Post 12.x versions MII has its own internal DB(could be MaxDB, Oracle, MSSQL depends of installation) to store MII config, customizations, typically its meant for MII and netweaver objects storage, you can connect to this underlying DB but not recommended anytime.

Transformations:

You can use reference documents to perform B2MML - XMII - B2MML etc...

You can use XSL transformations (MII provides few readymade xsl files too)

last but not least can build a BLS transaction to perform any kind of data transformation you desire

Hope this helps!!

Regards,

Adarsh