USB4SAP (Preview)

  • Reference

Universal Synch Bridge for SAP: One access point for all SAP integration, analytics and UI needs. Simplify modern analytics, apps and automations. Provision SAP data, insights and automation On-demand.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Ecoservity
URL https://www.ecoservity.com/#contact
Email hello@ecoservity.com
Connector Metadata
Publisher Ecoservity
Website https://www.ecoservity.com
Privacy policy https://www.ecoservity.com
Categories Business Intelligence

Universal Synch Bridge for SAP is one API for all SAP integration, analytics and UI needs of data provisioning It simplifies modern analytics, apps and automations by on-demand provision of SAP data such as table/view, reports, queries, cds, alv, bapi etc It is ready to be consumed instantly in MS Excel/ Power BI or choice of visualization tool It can be automated seamlessly using cloud (eg, Azure Logic Apps ) or Power Automate and used directly in AI / ML predictions (as REST interface or MS Excel plugin)

Prerequisites

User must have backend agent installed on the SAP system as described in the Deployment instructions below User must enter a valid SAP user ID & password For REST based access, a NetWeaver Gateway or equivalent REST API provider should be connected to backend SAP system Follow this guide for prerequisites

How to get credentials

Users can request their credentials by sending an email to usb4sap@ecoservity.com Currently, we support Basic Authentication

Get started with your connector

Follow this link for the installation of ODDI for SAP

Known issues and limitations

REST API supports data limits as specified under REST API protocols Large datasets extraction may result in time outs as configured in the REST API systems. In such cases, we recommend using the batch extraction method as supported by the solution

Common errors and remedies

Highlight any errors that might commonly occur when using the connector (such as HTTP status code errors), and what the user should do to resolve the error

Error code "400": "Bad Request" -> Please check the input data "404": "Not Found" -> URL not found. Please correct and try again "500":"Application Error" -> Application error occured on SAP backend. Please check the logs with SAP team

FAQ

Q1. What are the HTTP protocols supported? A1. Currently, we support both HTTP and HTTPS (preferred)

Q2. What are the API access protocols supported? A2. We support REST as well as RFC protocols

Q3. How is my monthly volume usage measured? A3. We meter the data being egressed from your SAP solutions for monthly usage

Creating a connection

The connector supports the following authentication types:
Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
Username securestring Please enter your username True
password securestring Please entre your passward True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

GET call to extract metadata and data from SAP data objects

The GET call extracts data along with its metadata from SAP, based on the selection criteria by user or background scheduled job.

GET call to extract metadata and data from SAP data objects

Operation ID:
GetCallExtractMetadata

The GET call extracts data along with its metadata from SAP, based on the selection criteria by user or background scheduled job.

Parameters

Name Key Required Type Description
Filter criteria specified by user
 $filter True string

Filter criteria is used by code to extract data from SAP.
Format of data to be returned from SAP
 $format string

Data format in response.