Displaying SAP attributes in Part Properties Navigate 1.6 mashup

Yes

Overview:

Navigate 1.6 uses SAP ODataConnector that enables the connection to the SAP Netweaver Gateway through the ODdata specification. It is a specialized implementation of the ODataConnector. See Integration Connectors for documentation

We will use SAP Netweaver Gateway Demo system:

1. Create an account on the Gateway Demo system (credentials to be used on the connector are sent by email)

2. Verify that the account has access to the basic OData sample service : https://sapes4.sapdevcenter.com/sap/opu/odata/IWBEP/GWSAMPLE_BASIC/

Note: ThingWorx can use SSO to access SAP, but in this post we will use fixed authentication.

1. OpenSAPODataConnector and configure connection settings:

2. Save the connector and go to services and execute service ValidateConnection to validate that 200 OK status is returned:

3. Open SAPPArtResourceProvider Thing and then Services and Edit the Service and in the script Enter the

var results=””

Note: This is the Prefix used to get data from SAP which is added before the Part Number

4. Open the Data shape SAP_DATA_SHAPE and create the three Data Fields as below and save the Data Shape

SAPMaterialCost => Type => Number

SAPQuantity => Type => String

SAPCurrency => Type => String

SupplierID => Type => String

Price => Type => String

With => Type => String

Depth => Type => String

Height => Type => String

DimUnit=> Type => String

5. Open the New Composer by setting the below preference from Administrator:

6. In New Composer open Thing ptc-SAP-OData-Connector, Services and edit the service GetProductSet in the Route info Select the End Point getProductSet. Click Done and save the Service:

Execute the service GetProductSet and check that data is fetched from SAP.

7. Open SAPPartResourceProvider and edit Attribute Mapping Configuration and ass attributes defined earlier on SAP_DATA_SHAPE:

8. Open CompositePartResourceProvider and edit Attribute Mapping Configuration and ass attributes defined earlier on SAP_DATA_SHAPE:

9. Open Navigate Tailoring Pages and add the SAP attributes and save the Tailoring pages.

10. Search for some Part and open information page and check that SAP attributes are populated:

OCMutz · ‎Mar 14, 2019

Hi Marek,

do you know how to exchange the SAP_DATA_SHAPE with my own DataShape.

It seems like the DataShape name is hardcoded somewhere in the Navigate execution scripts, but I am not able to find where.