cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying SAP attributes in Part Properties Navigate 1.6 mashup

Displaying SAP attributes in Part Properties Navigate 1.6 mashup

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:

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

 

ValidateConnection.png

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

SAPPArtResourceProvider.png

 

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

 

SAP_DATA_SHAPE.png

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

New Composer.png

 

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:

ptc-SAP-OData-Connector.pngExecute 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:

SAPPArtResourceProvider2.png

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

 

 

 

 

CompositePartResourceProvider.png

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:

View Part Properties.png

 

1 REPLY 1
Highlighted

Re: Displaying SAP attributes in Part Properties Navigate 1.6 mashup

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.