IMan Data Concepts
IMan has extensive functionality for manipulating or transforming data. In this section, the key concepts necessary for these transformations are explored.
The API process used by IMan to access external applications.
The auditing log records the results of each transform (e.g. reporting as successful, or highlighting errors), which can be configured using the Email task transform to be sent to the relevant end-user in summary form
IMan processes data in a specific pattern, which can effect the result of parent or child records that are dependent on other transactions.
Some applications require data to be in a certain structure in order to receive them correctly.
Pay attention to Destination Defined Data Structure when exporting to system applications.
An expando field is a statement using VBScript that references a particular segment of information within a dataset (e.g. item codes for an 'Orders' dataset, which when expanded show the individual entries for that section of data).
In the case of the Audit Log, Expando Fields could be configured to pull details of specific transform results.
Whether it is text, decimal or Boolean, the field type assigned to data tells IMan how to treat it.
Correct Field Types are important for avoiding erroneous results.
IMan uses formulae in a number of situations, to create field names and evaluate values.
These formulae are written using VBScript syntax.
Hierarchical data is comprised of repeating parent and child transactions. IMan is able to read, create and flatten this structure.
The process of importing, transforming/manipulating, and writing or exporting data.
The type and complexity of an integration can vary greatly, due to the flexibility of the IMan platform.
Transforms execute in a specific sequence, where the resultant data from the initial transform will become the input data for the following transform in the sequence. Hence data 'flowing' from one transform to the next.
A wildcard is a character used to refer to one or more undefined characters in a search.