SAP Business ByDesign Integration

In this article, we’ll integrate SAP Business ByDesign.

Business ByDesign is a cloud ERP system for the Midmarket.



Authentication: App Credentials with Language Selection
Settings: Historical Date selection, 
Schema type: Fixed
Update Type: Full import and incremental


First, you have to specify the subdomain of your SAP deployment, e.g. "my12345" for an SAP system that runs on the domain ""
The App authentication for SAP uses a user:password combination that you have created within your system. They are strictly isolated to the environment in which they are created and can only be used to access data from the account in which they were created. 
For SAP Business ByDesign, you can additionally choose the language of your data.


Import Settings

By default the historical date will be set to one year ago. Refer to your own datasource to decide from which exact date you would want to retrieve data.


There is no predefined schema for this integration. The integration will dynamically load the tables & columns which are defined within your specific system.

Updating your data

For this integration, you can schedule full imports. Every time the source updates it will fully sync all your data. You have the option of scheduling updates by the month, weeks, days, and even by the hour.

SAP Business ByDesign Setup Guide:

Note: In order to connect Business ByDesign with Y42, you will need to have a Business ByDesign Account.  

  1. On Integrate, click on "Add..." to search for SAP Business ByDesign and select it.

  2. Name your integration.

  3. Input your SAP subdomain and your account information. Also, choose your language settings.

  4. Choose from which point onwards in time to import your data. 
  5. After authentication, you are good to go and start importing your tables.

  6. Select the tables you need and click import. You can start accessing the tables once the status is “Ready”.

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?
0 out of 0 found this helpful