- 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
Datasource attributes
Initially the table only contains datasource attributes. Each datasource attribute corresponds to one of the columns in your data file. You can see the attribute details in the Edit Datasource Attribute window.
You can open the Edit Datasource Attribute window in the following ways:
- Double-click on the datasource attribute table item;
-
Right-click on the datasource attribute table item and select Edit... from the context menu.
Note: This also applies to table items of the other table item types.
The Edit Datasource Attribute window shows the following information:
- The Name in data source and the Attribute type.
- The Number of unique values and the Total number of records.
- A preview of the values Value (Integer) and their Frequency.
See illustration below.
Below is an overview of the different attribute types and their default format settings.
Attribute type |
Specification |
---|---|
Boolean |
N/A |
Date |
Format: YYYY-M-D |
DateTime |
Date format: YYYY-M-D Time format: h:mm[:ss[[.zzz]]] |
Double |
Decimal separator: . (dot) Thousand separator: none |
Integer |
Thousand separator: none |
Text |
N/A |
For attributes of type Date a Date format and attributes of type DateTime a Date format and a Time format are specified. You can select a different format from a list of predefined formats. See the illustration below.
Custom date format
If the datasource attribute you want to load uses a format that is not predefined, you can select the option custom date format. A popup dialog is displayed where you can enter the desired format. See the illustration below.
Below is an overview of the characters that you can use to specify a custom date or a time format.
Character(s) |
Description |
---|---|
y or yy |
Years |
m or mm |
Months |
w or ww |
Weeks |
d or dd |
Days |
h , hh , or hhh |
Hours, where
hh includes a leading zero.
|
n , nn , or nnn |
Minutes, where
nn includes a leading zero.
|
s , ss , or sss |
Seconds, where
ss includes a leading zero.
|
z or zzz |
Milliseconds, where
zzz includes a leading zero.
|
{ |
An optional string that is only printed if the preceding value is not null. |
yy{y }mm{m }ww{w }dd{d }hhh{h }nn{n }sss{s }
. See the illustration below.