- 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 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
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
.
Step 2. Enter Connection parameters:
URL
: the server URL.User
: the user name.Password
: the password.
Use Other parameters
to specify the Connection string options. Read about available Connection string options.
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
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 (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 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 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.
Comments
0 comments
Please sign in to leave a comment.