- 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
How to use AppOne connectors with TemplateOne
It is possible to use an existing AppOne connector to create an output dataset that can be loaded into TemplateOne. Since the data model of TemplateOne differs from the data model of AppOne you must either:
- rename the input tables of TemplateOne according to the names of output tables in the connector, or
- rename the output tables in the connector to fit the exact names of the input tables of TemplateOne.
Global settings and Reference models tables, as well as other tables that are not part of the TemplateOne data model.
Follow these steps to disable the output of a table.
|
Step |
Action |
|---|---|
|
1 |
Open the connector in your development environment and go to the Data tab. |
|
2 |
Right-click on the table you want to exclude from the output. |
|
3 |
Select Advanced - Options... from the context menu. |
|
4 |
Unselect the Output in dataserver update option and click on OK. |
See the illustration below for an example.
Case department and Customer are not part of the data model of TemplateOne, but can easily be added. See Adding new attributes to an app or discovery accelerator. If desired, you can also add additional attributes to TemplateOne in the same way.
Case value to Amount. See Mapping Attributes.
Case value to Amount afterwards.
Case status attribute is part of the data model of TemplateOne, it is expected as an input attribute for TemplateOne. In AppOne Case status is calculated in the app and not in the connector. This implies that if you want to use Case status in TemplateOne, you must configure this in the connector and make sure that it is included in the output dataset.
Event processing time attribute is in TemplateOne expected as an Integer, representing the amount of time actually spent working for the event given in milliseconds. If you want to use the Event processing time in TemplateOne, you must configure this in the connector and make sure that it is included in the output dataset.
Default period on the Globals table. The default value is using the maximum Case start date, but you can change it to a different value according to your needs.
If you have configured this in an existing connector, you must now configure this directly in TemplateOne.
By default, TemplateOne does not provide a welcome screen. If you want to show a welcome screen to end-users, you must build this in TemplateOne.
