About SAP ByDesign connector
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 database connector.
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
Enable the SAP ByDesign connector for your Etlworks Integrator account. Contact
firstname.lastname@example.org 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
Step 2. Enter Connection parameters:
URL: the server URL.
User: the user name.
Password: the password.
Other parameters to specify the Connection string options. Read about available Connection string options.
Work with SAP ByDesign
SAP ByDesign Data Model
- 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.
The connector supports several operations on data, including querying, deleting, modifying, and inserting.
Read about SQL Compliance.
Extract data from SAP ByDesign
Extracting data from SAP ByDesign is similar to extracting 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 (
Step 3. Create a Flow where the
source is a database 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.
Step 9. Add more transformations if needed.
Load data in SAP ByDesign
Loading data in SAP ByDesign is similar to loading 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 database.
Step 4. Add new source-to-destination transformation.
Step 5. Select
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
SELECT queries against the SAP ByDesign Connection.