SAP Fieldglass connection in SAP DWC
This blog lists the detailed steps that have to be performed for successful creation of an SAP Fieldglass type of connection in your SAP Data Warehouse Cloud (DWC) tenant.
- Configuration Manager of SAP Fieldglass
- SAP DWC administrator has connected SAP HANA SDI – Data Provisioning Agent and registered the CloudDataIntegrationAdapter.
Please note that Cloud Connector is not required for Data flows. The above prerequisites are sufficient for enabling remote tables & data flows on SAP Fieldglass connection in SAP DWC
Reference for DP agent installation: Administering SAP DWC
Set-up on SAP Fieldglass:
- Login to SAP Fieldglass tenant using the admin user that has “Configuration manager” linked to it and shift to Self-Service Dashboard, by clicked on linked accounts.
Reference for SAP Fieldglass: Self-Service Dashboard
- Creating a License Key – which will be used as OAuth 2.0 credentials in SAP DWC connection
- Click on “View Integration Connector” tile & open any existing connector
- Edit any integration connector & navigate to the last step – Setup Web Service
- Click on “Create New” & enter an application name & select an existing user from drop down. Change the status to “enabled” and hit save.
- The Web Service created will provide the OAuth 2.0 credentials to be used in SAP DWC connection.
- Username (within brackets) = Client ID
- License = Client Secret
Reference videos: SAP Fieldglass integration
Setting up SAP Fieldglass connection in SAP DWC:
- Logon to SAP DWC & navigate to connection. Click on “Create” (local connections) & choose SAP Fieldglass as connection type.
- Configuring connection parameters
- URL: SAP Fieldglass URL followed by ‘/api/data_hub’ (example: https://partner*.*****.com/api/data_hub)
- OAuth Token Endpoint: SAP Fieldglass URL followed by ‘/api/oauth2/v2.0/token?grant_type=client_credentials&response_type=token‘ (example:https://partner*.*****.com/api/oauth2/v2.0/token?grant_type=client_credentials&response_type=token)
- OAuth response type = token & OAuth token request content type = JSON.
- Client ID & Client Secret from Web Service setup done in SAP Fieldglass tenant above.
- Choose the DP agent (prerequisite) where you have registered CloudDataIntegrationAdapter.
- In final step enter connection name & create connection. Validate the connection. You should get a message:
Connection "******" is valid. - Data flows are enabled. - Remote tables are enabled.
Exposing an SAP Fieldglass report in SAP DWC:
Note that even after successfully setting up SAP Fieldglass connection in SAP DWC, no reports will be available for import. The below steps must be followed for the same.
- Logon to SAP Fieldglass > on the menu bar click on “Analytics” > Create Report
- Choose the module you want to create a report on (example: invoice, job posting etc.,).
- It lets you create a report based on the available fields (on left pane), which can be dragged into selected columns. There are other options like group by & filter conditions.
- Click on “Show More Configurations”:
- Report Access – Public
- API enabled Flag – YES
- Clicking on “Run Now” will download the report in the selected format. SAVE the report to be used in SAP DWC.
After creating the reports in SAP Fieldglass tenant, you will need to send an email to
firstname.lastname@example.org and state that you need the following reports (mention the report names) from https://partner*.*****.com/ to be published in SAP DWC tenant. The development team will make those report available in data hub, which can be imported into SAP DWC via the connection created.
- To import the report into SAP DWC, navigate to data builder & create a new graphical view. The connect you had created earlier will be available under ‘Sources’ > ‘Connections’ > ‘Connection Name’.
- Click on ‘Import from connection’ button next to the connection name > ‘fieldglass.insite’ > Reports that SAP development team have pushed into data hub should be available
- Select the reports > Next > Import
- Post successful import, a remote table will be created for that report. It can be used in views or data flows for further data processing.
To summarize, we have covered the steps to setup web service and create a report on SAP Fieldglass. Created the connection in SAP DWC and successfully imported reports from SAP Fieldglass. I hope this blog will be useful in expediting the connection setup between SAP Fieldglass and SAP Data Warehouse Cloud (DWC).
Knowledge shared is Knowledge squared!