Connecting to SAP ByDesign

Concept Information


SAP Business ByDesign is a cloud enterprise resource planning (ERP) software that enables customers to match supply-demand better and manage inventory. You can use the SAP ByDesign data connector to import your organization's SAP ByDesign data.


The SAP ByDesign data connector is provided by our data partner, CData. For information on any of the connection fields, refer the documentation available at the CData website.

Before you start

To connect to SAP ByDesign, you must gather the following:

  • the URL to your system host name
  • credentials to connect to the SAP ByDesign account

For help gathering the connection prerequisites, contact the SAP ByDesign administrator in your organization. If your administrator cannot help you, you or your administrator should contact SAP ByDesign Support.

Create a SAP ByDesign connection

  1. From the Analytics main menu, select Import > Database and application.
  2. From the New Connections tab, in the ACL DSN Connectors (Bundled) section, select SAP ByDesign.


    You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

    The DSN Configuration dialog box appears.

  3. In the DSN Configuration dialog box, click Show Required.
  4. Provide values for the required fields, if any.
  5. Click Test Connection.


    When you click the Test Connection button, it validates whether the connection and authentication details provided are correct. If you click OK without clicking Test Connection, the connection details are saved without any validation and may not work later if the values provided are incorrect.

    The log in page for SAP ByDesign appears.

  6. Provide the connection details and authenticate your login.

    When the connection is successful, a dialog box opens displaying the success message.

  7. Click OK in the connection successful dialog box that appears.

    The connection to SAP ByDesign is established successfully.

  8. In the DSN Configuration dialog box, click OK.

The connection for SAP ByDesign is saved to the Existing Connections tab. In the future, you can reconnect to SAP ByDesign from the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from SAP ByDesign, see Working with the Data Access window.

Rename the connection

When you create the SAP ByDesign data connector, you cannot provide a Connection name of your choice and the connection is saved to the Existing Connections tab with the same name as your data source. If you want to rename it, navigate to the Existing Connections tab, expand the ACL Connectors (DSN) section, click the ellipsis icon corresponding to SAP ByDesign and select Rename connection.