cancel
Showing results for 
Search instead for 
Did you mean: 

SAP PCO: How to load data from AspenTech Info Plus 21 to Hana Database using SAP Plant Connectivity

0 Kudos

Hi experts,

We are working in a new Project where we have to load information from AspenTech Info Plus 21 to Hana database using PCO.

We defined the follow steps:

- Source System as "IP21 Source System". We defined one Tag from IP21 as a Alias, using the browse hierarchy

sourcesystem1.png

sourcesystem2.png

sourcesystem3.png

- Destination System as "ODBC Destination System'. Here we defined a table as "Create table"

destinationsystem1.png

- Agent Intance

agentinstance1.png

--- In the Tag Query tab, we defined Cache Mode as "Access using Aliases Only" and in the Alias field we used the alias defined on Source System

agentinstance2.png

--- In the Servers tab, we tried two possibilities. One using Server type OPCUA Server and other using Server type Pco Wer berver (did not work in both cases)

servermethoddefinition1.png

agentinstance3.png

Notification

methodnotification2.png

methodnotification4.png

In general, we followed all the suggested steps on SAP documentation, but it is not working. The hana database is not saving information from IP21 system

Our questions:

1 - How should we do the transfer from the source field to the destination field? How can we access the Tag values on the Expression Editor?

2 - What we are missing to our flow work worked?

Follows in attached the screenshots.

Thank you in advances

Accepted Solutions (0)

Answers (7)

Answers (7)

ReinerE
Explorer
0 Kudos

Hi Kevin,

thank you for the quick information.

PCo licence would not be a problem but the IP21 data access and mapping to MQTT destination.

OPC UA was not an option till now. We will discuss internally about further steps.

BR

Reiner

Kevin_Hunter
Employee
Employee
0 Kudos

No problem. Our test server is IP21 V16 and has OPC UA as part of it. Here is a screenshot of UAExpert connecting to it and showing the server details.

Thanks
Kevin

0 Kudos

Hi Kevin,

Thank you very much!

Leticia

ReinerE
Explorer
0 Kudos

Hello Kevin,

we have a similar problem. We want to use PCo with IP21 source system and sent the Tag data with MQTT to SAP Cloud IoT Service. For this mapping to MQTT message structure is needed. Is this possible with the following:

IP21 source system + agent + MQTT destination system

or

IP21 source system + Agent + Multiple Call destination system + Query destination system + MQTT destination system

Thanks

Reiner

Kevin_Hunter
Employee
Employee
0 Kudos

Hi Reiner,

Correct your situation is very similar.

The IP21 source system is limited due to limitations in the IP21 SDK (the DLL files you have to copy into PCo from your IP21 install).

The best way around this is to use an OPC UA source system which IP21 supports, this allows you to use notifications.

Unfortunately using a multiple call destination and using the query destination doesn't work either as you cant define the query 😞 , it is really looking for the query to be created in MII. Its much easier just to use OPC UA 😉

One other thing to point out is that using PCo to sent data to the IoT Cloud is against the usage rights of PCo unless you own an MII licence.

Thanks

Kevin

0 Kudos

Hi Kevin,

Does this mean that we should use OPC UA as the Source System or on the Server tab of the Instance Agent?

Kevin_Hunter
Employee
Employee
0 Kudos

You should use OPC UA as the Source System.

You should not be using any server on the server tab. Servers provide data to a client , in your use case the IP21 Historian is your server and PCo is the client. Therefore there is no need to set up another server.

Thanks

Kevin

Kevin_Hunter
Employee
Employee
0 Kudos

Hi Leticia,

The IP21 Source system uses the IP21 SDK and this does not support notifications (limitation of IP21 not PCo), it only supports queries hence why you cannot see the notifications.

You have to use OPC UA instead.

Thanks

Kevin

Kevin_Hunter
Employee
Employee
0 Kudos

Also take a look here https://help.sap.com/viewer/c90214be0d934ebdb6f3bce29c63c0ff/15.4.1/en-US/32ecfef7a0f0423f81da24d31c...

And you will see that the IP21 Source system doesnt support notifications or destination calls.

Thanks

Kevin

0 Kudos

Hi Kevin,

Thank you very much for your support, but, if I do not use OPC UA server or PCo Webserver, I am not able to create a notification, as you can see in the image.

static-notification-1.jpg

What should be the procedure to create the static notification?

Regards, Leticia

Kevin_Hunter
Employee
Employee
0 Kudos

Hi Leticia,

You do not need to use the OPC UA server or PCo Webserver and you should not be using method notifications.

In your agent instance you need to add a static notification, define the trigger criteria, the output message and map it to you destination.

In addition, please note that the IP21 source system does not support notifications so you should use OPC UA as the source system.

Hope this helps.

Kevin