Integration with PIMS system .

[Former Member]

Dear Experts,

I am facing the issue to integrate the system which captures the real time data in excel from software which should need too integrate to the SAP .

Thanks and Regards..

Vishnu Ravi.

[salvatore_castro]

Real-time data doesn't exist in Excel but rather a copy of real-time data

You are better off getting it from the location/source that Excel is getting it from.

There are of course other ways to get at Excel data, such as via PCo and OLEDB or ODBC interfaces to Excel or directly with the MII Query Templates:

SAP
Enterprise Manufacturing Intelligence (EMI) Solution for Microsoft Office 365

SAP/Microsoft
Manufacturing Reference Architecture

Sam

[Former Member]

Dear Salvatore ,

yes, you are right according to these interface which could be a better for the immediate Solution. As I am have newbie to this area of concepts. Please Guide me where to Start From.

Thanks and Regards

Vishnu Ravi.

[salvatore_castro]

Here's the PCo documentation on how to setup the OLEDB and ODBC interfaces and to expose Excel to these protocols is just a simple Google search away

OLEDB: OLE DB Source System - SAP Plant Connectivity - SAP Library

ODBC: ODBC Source System - SAP Plant Connectivity - SAP Library

Sam

[Former Member]

Dear Sam ,

Thanks SAM For the Prompt Reply , Would be help full .

Thanks and Regards.

Vishnu Ravi.