process-mining
2021.10
true
- Release notes
- Getting started
- Installation
- Configuration
- Integrations
- Authentication
- Working with Apps and Discovery Accelerators
- AppOne menus and dashboards
- AppOne setup
- TemplateOne 1.0.0 menus and dashboards
- TemplateOne 1.0.0 setup
- TemplateOne menus and fashboards
- TemplateOne 2021.4.0 setup
- Purchase to Pay Discovery Accelerator menus and dashboards
- Purchase to Pay Discovery Accelerator Setup
- Order to Cash Discovery Accelerator menus and dashboards
- Order to Cash Discovery Accelerator Setup
- Basic Connector for AppOne
- SAP Connectors
- Introduction to SAP Connector
- SAP input
- Checking the data in the SAP Connector
- Adding process specific tags to the SAP Connector for AppOne
- Adding process specific Due dates to the SAP Connector for AppOne
- Adding automation estimates to the SAP Connector for AppOne
- Adding attributes to the SAP Connector for AppOne
- Adding activities to the SAP Connector for AppOne
- Adding entities to the SAP Connector for AppOne
- SAP Order to Cash Connector for AppOne
- SAP Purchase to Pay Connector for AppOne
- SAP Connector for Purchase to Pay Discovery Accelerator
- SAP Connector for Order-to-Cash Discovery Accelerator
- Superadmin
- Dashboards and charts
- Tables and table items
- Application integrity
- How to ....
- Working with SQL connectors
- Introduction to SQL connectors
- Setting up a SQL connector
- CData Sync extractions
- Running a SQL connector
- Editing transformations
- Releasing a SQL Connector
- Scheduling data extraction
- Structure of transformations
- Using SQL connectors for released apps
- Generating a cache with scripts
- Setting up a local test environment
- Separate development and production environments
- Useful resources
Loading data in the SAP Connector for AppOne
Process Mining
Last updated Sep 2, 2024
Loading data in the SAP Connector for AppOne
Note: The information in this guide only applies to the SAP Purchase-to-Pay Connector for AppOne and SAP Order-to-Cash Connector for AppOne.
The input tables are used to load data into the SAP Connector. The following options are available to load data in an SAP Connector.
- Connecting directly to the SAP database using the native SAP connection.
- Loading
.csv
files that contain specific SAP data. - Loading data via an ODBC Connection.
In order to load data correctly you must set the input type in the SAP Connector.
Note: By default the input type is set to ‘CSV’, which means the data is loaded from
.csv
files.
Follow these steps to set the input type to use the native SAP connection or to use an ODBC connection.
Step |
Action |
---|---|
1 |
Open the SAP Connector in your development environment. |
2 |
Go to the Data tab and select the Connector_settings table. |
3 |
Double click on the
Input type expression in the Input folder.
|
4 |
Switch the
Input type to either Const_Input_type_SAP or Const_Input_type_ODBC .
See illustration below for an example. |
5 |
Click on OK. |
In cases where only a subset of the data is needed for analyzing or monitoring, it is recommended to limit the amount of data
loaded, while this may improve the loading times. The number of rows that are extracted from SAP can be limited based on a
date range. You can specify a start date in the
Extraction start date
expression and/or an end date in the Extraction end date
expression in the Output folder in the Connector_settings table. See the illustration below.
Note: By default, the
Extraction start date
expression applies a date filtering to only get data from the current year (starting at January 1st).
See Input Data of the SAP Order-To-Cash Connector for AppOne or Input Data of the SAP Purchase-to-Pay Connector for AppOne. In the Filtering column it is indicated which tables are filtered by the
Extraction start date
and the field that is used to filter (Date: fieldname
).