- 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
Checking the data in the SAP Connector
Before you export the output data set to use it in AppOne or a Discovery Accelerator it is advised that you check if the data from the input data files is properly connected in the SAP Connector. The SAP Connector contains pre-defined dashboards to validate the data.
Connecting your database ends with validating if all necessary data is available and in the right format. The Data validation menu contains dashboards that validate if all necessary data is available and in the right format.
The Data validation - Invariants dashboard provides multiple checks. See the illustration below for an example.
-
, otherwise the result is false
. To check what the issue is, search the name of the issue in the table list on the left of the HTML panel. Each invariant may contain one or more checks. You can open the corresponding invariant to check why a check fails.
Input checks
Input checks check all key field attributes for the following properties:
- The field contains values;
- The field does not contain
NULL
values; - The field has a specified length (where possible).
Next to the Invariants dashboard, the dashboards are available to analyze the different sub-processes.
These dashboards contain information on the number of records loaded from the different tables. This enables you to check the number of records. Furthermore, the number of headers and items that are excluded are reported.
The Output menu in the SAP Connectors for AppOne contains dashboards to check the output data for use in AppOne.
The numbers on the top right in the Cases output and Events output tabs show how many cases and events there are in the input and output.
You can also use the Process graph dashboard to check if the data is properly connected.