Articles in this section

See more

SAP ByDesign Connector

  • Updated
Follow
  • Starter
  • Business
  • Enterprise
  • On-Premise
  • Add-on

Overview

Etlworks SAP ByDesign connector allows the fastest and easiest way to connect to real-time SAP Business One data. The connector works just like any other connector for connected app.

Etlworks partnered with CData to provide access to SAP Business One using industry-standard JDBC protocol. Read about CData SAP ByDesign JDBC connector.

When to use SAP ByDesign connector

Use this connector to create Flows that extract data and load data into SAP ByDesign.

Prerequisites

Enable the SAP ByDesign connector for your Etlworks account. Contact support@etlworks.com to enable the connector.

Create a Connection

Here's how you can connect a Connection in two easy steps:

Step 1. In the Connections window, click +, and type in sap bydesign.

mceclip0.png

Step 2. Enter Connection parameters:

  • URL: the server URL.
  • User: the user name.
  • Password: the password.

mceclip0.png

Use Other parameters to specify the Connection string options. Read about available Connection string options.

mceclip1.png

Work with SAP ByDesign

SAP ByDesign Data Model

Key features

  • The connector models SAP ByDesign Analytics Services as relational views. Entities defined on a Custom Service are modeled using a combination of tables and views, allowing you to write SQL to query SAP ByDesign data.
  • Live connectivity to these objects means any changes to your SAP ByDesign account are immediately reflected when using the driver.

Read about the data model.

SQL Compliance

The connector supports several operations on data, including querying, deleting, modifying, and inserting.

Read about SQL Compliance.

Extract data from SAP ByDesign

Note: Extracting data from SAP ByDesign is similar toextracting data from the relational database.

Here's how you can do this:

Step 1. Create SAP ByDesign Connection which will be used as a source (FROM).

Step 2. Create a destination Connection, for example, a Connection to the relational database, and if needed, a Format (Format is not needed if the destination is a database or well-known API).

Step 3. Create a Flow where the source is a connected app, and the destination is a Connection created in step 2, for example, a relational database.

Step 4. Add a new source-to-destination transformation.

Step 5. Select the SAP ByDesign Connection created in step 1 as a source Connection and select the data object you are extracting data from.

Step 6. Select TO Connection, Format (if needed), and object (for example, database table) to load data into.

Step 7. Click MAPPING and optionally enter Source query (you don't need a query if you are extracting data from the SAP ByDesign data object unconditionally).

Step 8. Optionally define the per-field Mapping.

salesforce-mapping.png

Step 9. Add more transformations if needed.

Load data in SAP ByDesign

Note: Loading data in SAP ByDesign is similar toloading data into a relational database.

Here's how you can do this:

Step 1. Create a source Connection and a Format (if needed).

Step 2. Create a destination SAP ByDesign Connection.

Step 3. Create a Flow where the destination is a connected app.

Step 4. Add new source-to-destination transformation.

Step 5. Select FROM and TO Connections and objects (also a FROM Format if needed).

Step 6. Optionally define the per-field Mapping.

Step 7. Add more transformations if needed.

Browse data in SAP ByDesign

You must have SAP ByDesign Connection to browse objects and run SQL queries.

Use the Etlworks Explorer to browse data and metadata in SAP ByDesign as well as execute DML and SELECT queries against the SAP ByDesign Connection.

Related articles