Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with LinkedIn Log In with Google      Sign In   
  • Create Account

Photo

the product roadmap for the data exchange with SAP

roadmap sap

  • Please log in to reply
10 replies to this topic

#1 charles

charles

    Teacher

  • Member - L6
  • 39 posts
1 upvotes
Silver

Posted 05 September 2012 - 10:15 PM

Serveral years ago, we had raised the discussion of a topic on the data exchange between SAP and PI system. We also have a look on the RLINK-SAP presentation. However, as a petrochemical process plant, there are many constraints in the SAP and PI system. Finally, we adopt the roadmap to manually load the data to SAP PP module.

I'd like to know what is the furture of the product roadmap for the intergration with SAP and BI. Currently, I saw the RtBM business package for SAP EP.

By the way, how about the layer product about OLEDB enterprise? What is the difference with the OLEDB provider?
  • 0

#2 Dave

Dave

    Beginner

  • Member - L2
  • 2 posts
0 upvotes
Bronze
  • LocationTownsville, QLD, Australia
  • Company:Queensland Nickel

Posted 05 September 2012 - 10:39 PM

Charles, we have been using SAP MII for several years to exchange production, maintenance & inventory data between PI and SAP ERP. This SAP product is fairly simple to use and quite robust, if you are licensed for it :)
If you like coding then you could possibly use PI-ACE with the SAP Connector for Microsoft .NET :(

PI-OLEDB Enterprise allows querying on PI-AF, which the standard PI-OLEDB provider does not. PI-OLEDB Enterprise is also a new product, not an upgrade to the standard PI-OLEDB provider :angry:
  • 0

#3 myDorazio

myDorazio

    Master

  • OSIsoft (opinion) L8
  • 400 posts
87 upvotes
Rhodium
  • LocationUSA
  • Contact info:nick@osisoft.com
  • Company:OSIsoft, LLC

Posted 06 September 2012 - 02:42 AM

PI-OLEDB Enterprise allows querying on PI-AF, which the standard PI-OLEDB provider does not. PI-OLEDB Enterprise is also a new product, not an upgrade to the standard PI-OLEDB provider :angry:


Thanks. Here are links to each if anyone wants to find the details and the docs. (You can navigate to these and related data access products by going to OSIsoft.com > Products > Layered products.)
Click here for more on PI-OLEDB Provider
Click here for more on PI OLEDB Enterprise
  • 0

#4 charles

charles

    Teacher

  • Member - L6
  • 39 posts
1 upvotes
Silver

Posted 06 September 2012 - 05:10 AM

Mostly, we regard the Rtwebpart has some functions overlap with SAP XMII,especially talking about production KPI. Do you also use RtWebparts as the presentation platform?
As talking XMII, could this one act as MES platform? What about the product data stored there? Or you may have some ref link or material?

Thanks a lot.
  • 0

#5 Gopal/OSIsoft

Gopal/OSIsoft

    Expert

  • OSIsoft (opinion) L5
  • 12 posts
1 upvotes
Silver
  • LocationPhilly Office
  • Contact info:gopal@osisoft.com
  • Company:OSIsoft

Posted 06 September 2012 - 01:18 PM

Charles, are you looking for integration with SAP modules - PM, PP etc. or is you requirement more about business intelligence/reporting type uses, i.e. BusinessObjects, CrystalReports etc.
  • 0

#6 bmcmorrow

bmcmorrow

    Beginner

  • OSIsoft (opinion) L2
  • 2 posts
1 upvotes
Silver

Posted 06 September 2012 - 06:51 PM

Hello Charles,

I would invite you to review the presentation that Gopal and I gave at this year's UC: http://www.osisoft.c...ct.aspx?id=8190

We are interested in discussing further your specific implementation details and requirements in order to narrow down all the options, some of which are outlined in our presentation.

To answer one of your questions: MII can be used as a middleware layer for MES systems to communicate with SAP ERP modules and the PI System; however, it is not itself an MES system. You would have to custom-build an MES system if leveraging MII, or use it in conjuction with a 3rd party MES system. There is a good thread on this topic in the SAP community site: http://scn.sap.com/thread/1902221
  • 1

#7 charles

charles

    Teacher

  • Member - L6
  • 39 posts
1 upvotes
Silver

Posted 06 September 2012 - 09:25 PM

Charles, are you looking for integration with SAP modules - PM, PP etc. or is you requirement more about business intelligence/reporting type uses, i.e. BusinessObjects, CrystalReports etc.

Yes. We are really looking for the solution to intergrate the SAP with the MES platform, PI and etc. As you know, the PI raw data should be verified and then could be presented with BI data. The purpose is to set up a decesion support platform, which could show the production cost ( main about the utility comsuption, raw material comsuption), production planning, product marketing price and the rough profit.

From the presentation of 2012 seminar, I saw Johnson adopted the PAS as the MES platform and exchanged the data with PI real time data. It mostly like the requirements we have.
  • 1

#8 charles

charles

    Teacher

  • Member - L6
  • 39 posts
1 upvotes
Silver

Posted 06 September 2012 - 09:47 PM

Hello Charles,

I would invite you to review the presentation that Gopal and I gave at this year's UC: http://www.osisoft.c...ct.aspx?id=8190

We are interested in discussing further your specific implementation details and requirements in order to narrow down all the options, some of which are outlined in our presentation.

To answer one of your questions: MII can be used as a middleware layer for MES systems to communicate with SAP ERP modules and the PI System; however, it is not itself an MES system. You would have to custom-build an MES system if leveraging MII, or use it in conjuction with a 3rd party MES system. There is a good thread on this topic in the SAP community site: http://scn.sap.com/thread/1902221


Thanks! It is really a good reference material for our understanding the MII and PI system. Actually, the XMII proposal was rasied a few months ago. It is difficult to evaluate the risk to set up the platform and the requirements to the ability of each department. Especially, it involves much works related coding and programming. We may visits the customer of SAP which adopted the MII platform to understand the possible impact to the business operation.
  • 0

#9 myDorazio

myDorazio

    Master

  • OSIsoft (opinion) L8
  • 400 posts
87 upvotes
Rhodium
  • LocationUSA
  • Contact info:nick@osisoft.com
  • Company:OSIsoft, LLC

Posted 07 September 2012 - 01:39 AM

From the presentation of 2012 seminar, I saw Johnson adopted the PAS as the MES platform and exchanged the data with PI real time data. It mostly like the requirements we have.


Here is a replay of the Users Conference presentation about the Johnson&Johnson project Charles is referring to, in which "data coming from the MES system integrated with PI System data is changing the way people visualize the production process" according to the description. The presenter is Barry Higgins, an Automation/MES Engineer at Janssen Biologics, a subsidiary of Johnson&Johnson.

Click here for MES Integration with the PI System presented by Barry Higgins at the 2012 OSIsoft Users Conference.

Note: here is a replay of what I believe is an earlier version of the same presentation. It is called Integration Approach Werum PAS|X to OSIsoft’s PI System and Process Systems and it was presented by Barry Higgins at the 2011 OSIsoft EMEA Regional Seminar.
  • 0

#10 myDorazio

myDorazio

    Master

  • OSIsoft (opinion) L8
  • 400 posts
87 upvotes
Rhodium
  • LocationUSA
  • Contact info:nick@osisoft.com
  • Company:OSIsoft, LLC

Posted 12 September 2012 - 11:18 AM

Charles continued the discussion with Brian and Gopal and with his permission I am copying their email thread below.


Charles wrote:
From the OSIsoft community, you give me a great link for the integration PI with SAP. That’s really the need we are researching. We may want to have more information about this topic. Currently, we run on SAP of version Net weaver. We also have the plan to upgrade PI to the latest version, comes with PI AF.

Here is the topic I need your help,
1. On terms of integration SAP with PI, from your slides, the SAP uses the PPPI function, which mapping via the Microsoft Biz talk server. For our petrochemical industry, we are the mixed process-based industry. We may not have the PPPI function in SAP system. To realize the daily revenue report, how about the outline of the integration? Say integrated with the SAP BI module via BizTalk server?

Gopal wrote:
Charles, if you are only using SAP PP (production planning), you can still send production confirmations. How many PI values will you be sending daily to SAP? Will it be just aggregated values for daily totals for say, Naphtha, Kerosene etc.? The integration is similar to what’s shown in the talk – except that you’ll be using a different SAP RFC for production confirmation.

PI_SAP_WebServices.png

Charles wrote:

2. From your slides, “HANA as a unified analytical platform to bridge data from PI System, SAP ERP, and other sources”. Does HANA provide the interface to AF or PI system? Or OSIsoft provide some interface to export calculated data to HANA database? Certainly, from the discussion in the OSIsoft community, this function could realize by ACE.

Brian wrote:
The options for connecting between HANA and the PI System (including AF) are the PI JDBC for programmatic access, or using BusinessObjects Data Services for an ETL-type load of data, which interfaces to PI using PI Web Services, PI JDBC, or PI OLEDB via linked SQL server. To my knowledge, there is no .NET library for accessing HANA that has been released by SAP.

Charles wrote:
3. For the solution integrated with SAP HANA and PI, it looks like a future solution. As consider a practical solution, what is the data infrastructure of the best practice from our OSIsoft customer? As you know, the PI system acts as a real-time data store; we also need somewhere to store the summary data. Is that possible to store them into BW via a third party tool?

Brian wrote:
Yes, an architecture with PI System data in SAP HANA has not been implemented in production by any current customers yet—it continues to be a future solution for now; however, this is not the only option today for merging PI System data and SAP data for analysis or reporting—a data warehouse, such as BW can be used. Before loading data in BW, you should consider that the PI System has several options for making summary calculations—PI Performance Equations, Totalizers, and ACE. So you have the option of doing heavy numerical calculations and storing the summary values in the PI System. Then load them in either BW or just call the data from BOBJ directly by creating a Universe—it depends on the volume of data and frequency of the call to determine which option is preferred. You can interface with SAP BW using Data Services and the interfaces listed above. SAP MII can also be used, but if this is the only purpose for MII, then it may be overkill. If you decide to use MII for ERP integration, then this may be a good option.

Charles wrote:
4. The topic on integration SAP with PI has some presentation before. Can you please give a link as the below, or give me some reference to find this videos,
Enterprise Business System Integration Using PI Data Access
Hands on Lab - SAP and Maximo integration using Web Services and PI Notifications

Brian wrote:
Do you have an account on vCampus?

[vCampus is where you will find the most detailed discussions on using PI Data Access tools, but the two links below are publicly available and do not require a vCampus subscription. --Nick]

PI Data Access and Enterprise Integration

Using PI System Data and Events in Your Enterprise and Line of Business Systems
  • 0

#11 Gopal/OSIsoft

Gopal/OSIsoft

    Expert

  • OSIsoft (opinion) L5
  • 12 posts
1 upvotes
Silver
  • LocationPhilly Office
  • Contact info:gopal@osisoft.com
  • Company:OSIsoft

Posted 14 November 2012 - 10:44 PM

At vCampusLive 2012, there is a hands-on lab session on "Integration with Business Systems Using PI Event Frames"
In this lab, you will learn to leverage PI Event Frames and PI Web Services to integrate the PI System with line-of-business systems. Several business integration use cases are transaction-oriented and PI Event Frames provides the appropriate infrastructure to present time-series data in a transactional context. Attend this hands-on session for step-by-step instructions on using the PI System data and events for integration with SAP ERP. This lab includes live access to SAP for an end-to-end experience...
Full agenda here:http://www.osisoft.c...puslive/agenda/
  • 0





Topics related to roadmap, sap

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users