Connection between SCADA and SAP

[Former Member]

Hi,

I'm totally new to SAP but I've to provide a good solution on connection between a SCADA-Server (WinCC) and SAP. The interaction should be realized on database-level since WinCC is backed by a SQL Server 2005.

So my question is, is LinkedServer a useful technique for this kind of interaction, which may happen "event-driven" or in a time based way? What other techniques could be useful (e.g. OPC, ODBC, ...)?

And how can I automatically check and report, if something went wrong or just log the successful interaction?

Thanks and kind regards

- dAs_2010 -

[Former Member]

You DEFINTATELY want to use OPC to talk to Siemens Win CC. Use either PCo 2.1 or the UDS 4.0 OPC interface.

[Former Member]

Thanks All.

I think I'll take the "OPC-Way", since as Mr. Paul Radulescu mentioned I'd have to build some kind of polling routines within SQL-Server and I'm not sure if SQL Server is made for it!

Unfortunately I have no access to the SAP-Machine yet but I think this will happen soon

Mr Schaefer, is PCo 2.1 or the UDS 4.0 OPC interface part of SAP-environment or do we have to pay for them?

Thank you all for your supports

-dAs-

[Former Member]

PCo 2.1 gives you access to alerts event-based through OPC, without pooling the SCADA/PLC tags at given intervals of time. I also like working with TAG servers instead of always using IDBC.

Else, SQL connectivity is also good, but you still have to POLL, POLL, POLL .. Linked servers work fine, used them in the past, however some clients want to "distribute" the load on the SQL servers to other machines in the system (remember, the best SQL server can do a limited number of SQL transactions per second, way lower than the possible number of tags in the system needing updates).

[sidnooradarsh]

Hello,

In addition to Manoj's suggestion you can also perform something like this,

If your SCADA system is capable of making webservice calls whenever an event is triggered then create a MII BLS transaction which upon webservice call queries the underlying SCADA DB, retrieve desired results then generate report or generate a Pdf or text or xml and send it to SAP system or send to end users via MII email action and so on depending on your requirement.

Hope this helps!!

Regards,

Adarsh

[Former Member]

Hello Adarsh Sidnoor,

thanks for reply.

Your idea sounds good. II will check the options you mentioned. I know that WinCC provides some webservices but I'm not sure, if it is an Add-On or just part of the whole system.

Thanks also to Manoj Bilthare.

Using an OPC-connection was the first thing I thought about too, but the main idea was and still is if I can exchange data just by using some kind of stored procedures on each side to forward data or just to reply if some requests from the partner system are received.

However when I get some results within the next few days, I'll come back to you.

Thans again for your posts and if you find out more useful infos, please remember to post them to me too.

[Former Member]

Hi Das,

I can suggest one option as per my knowledge.

you can use OPC server for SCADA and there is one s/w by SAP called Plant connectivity 2.1.

you can configure your OPC server in SCADA as well as in Plant connectivity 2.1 and you can make RFC call.

one more option you can use SAP MII to make BAPI/RFC/IDOC calls you can configure your SAP MII server in PCo.

following are help links may be helpfull.

for SAP MII 12.1 & 12.2

[http://help.sap.com/saphelp_mii122/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm],

[http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm]

for Plant Connectivity 2.1

[http://help.sap.com/saphelp_pco21/helpdata/en/46/a00344d44852b7e10000000a155369/frameset.htm]

you will find out more details in forum.

Thanks & Regards,

Manoj Bilthare