SAP Work Manager 6.2 (Agentry) - Integration of multiple Back-end Systems

[Former Member]

Hello Experts,

I have one question and it's important for me 😉 We are still working with the SAP Work Manager.

And for Information: we store our data in multiple Back-end Systems. So the Business Data are stored in the SAP ERP System and the technical Data are stored in a separate System.

So my Question is, is it possible to get data for objekt (i.e for one work order) from multiple Back-end systems and in case of yes, how?

For example in terms of a work order, the operation planning etc is done in the ERP System but the data concerning the functional location for example is stored in another non sap system. The Link between the word order and the functional location is the structure indicator.

So until now my understanding is that i can define various steps and each step could be again various back-end systems but my question is, is it possible to merge or join the both data from the various data sources.Is it possible through the step definitions or in the java classes in the middleware or how and when?

So maybe you have nice ideas. Then let me know.

BG,

Jörg

[mark_pe · Accepted solution]

Hi Jorg,

The out of the box SAP Work Manager 6.2 is implemented in SAP ERP (With ERP Mobile Add on). With this custom question, normally it will be done by SAP Consulting as the SAP Work Manager 6.2 is designed in Agentry. Agentry supports multiple backend (Java, SQL, File, HTTPXML). Depending on your data backend, if it is java or SQL or others it can be done.

In essence the Agentry.ini will have multiple backends as designed in the Eclipse Agentry editor ( [Java-1] and [YourNewBackend-2]). As long as it is based on Java, SQL, HTTPXML or FILE or OpenUI then it may work.  This again is custom and needs to be planned accordingly. Your SMP 3.0 cockpit will then have multiple backends defined when you load this newly custom zip file with multiple backend.  Now the other question you may need to ask is how custom is your other data enterprise? This has to be analyzed by your SAP consultants.

Most likely you will create Java libraries that will do the merging of these two data together. This is how a system integrator company will do it.

The Agentry consulting experts have done this with other companies but it is custom. You may need to reach out with your SAP Sales to get a proposal out.

Again this is not built out of the box and only with special consulting engagement that one can do this. You may either use SAP or SAP partners to do this for you. The key is that they need to be Agentry experts.

If you are currently a customer of SAP and you have MaxAttention status you may avail with the MaxAttention project management planning for designing it (you may talk to your SAP Sales if need be). Talk to your SAP Sales to open a line of discussion with SAP Agentry consulting.

Best Regards,

Mark Pe
SAP Senior Support Engineer (mobility)

[CRVMANISH · Accepted solution]

You can use proxy configuration to use multiple backend in Syclo config panel.

Other option is to use integration gateway of SMP to connect to multiple data sources and consume that in agentry.

Regards

Manish

[chris_gray1]

You could implement the BADIs Work Manager uses to fetch those Work Orders, Notifications, etc and have them fetch functional location and other data via RFC calls to the other systems. Depending on how your data is broken down, this could be much simpler than establishing multiple connections through Agentry as it would allow you to avoid customizing the Agentry and Java side.

[bill_froelich]

Jorg,

Yes you can fetch data from multiple backends into the same object in Agentry.  For example, I have an SAP Work Manager application that fetches the majority of the data from the ERP system using a Java Backend and then supplements that data using a SQL connection to another database to populate some additional properties on the Work Order.

As long as you have the key property reference in both locations Agentry can store data from both back end systems in the same Agentry object.

--Bill