Data connections allow
Data can be sourced from a variety of systems and stores and whilst some concepts are generic, specific details differ between technologies. For example a simple CSV file requires a file path, whereas a database requires a server and authentication for a successful connection. Thus when a data connection is added its type will define what connection information is to be provided by the administrator.
A single data connection to a data store might provide access to many different records. For example a CRM system might read/write entities such as customers, locations, groups etc. Whereas a database might provide access to Tables, Views, Functions and Procedures.
As described above data Objects represent specific entities or concepts within a connection. Regardless of the connection type
- The specific entity or technology to target depending on the connection type
- Define caching settings for offline data viewing (mobile apps only where appropriate)
- Define if the object access is read only or read/write where technically possible.
- Fields for which the data can be filtered on, known as key fields (e.g. lookup a customer by customer Id).
- Define fields for which to ignore that are irrelevant or disruptive to business process the data object is required for (known as schema fields).
- Define fields that are appropriate/not appropriate to be shown in a User interface, known as display fields (e.g. show an employees name but not their salary).
Each of the above points together with specific instructions on configuration requirements for specific data connection types can be found in the sub articles below or within the other articles in this category.
Whereas read only data objects are straight forward, writable data object has more to think about for example, whether:
- It is technically possible to write to the data object within the data connection
- It is appropriate to maintain data via the
with regards to the business process and security policy.
To define an individual data as writable, select Read/Write as the option for the data object's access property.
Updated 5 months ago