Data Containers
The form "Data Containers" contains a list of registered data containers. A data container is part of a databases and contains the actual data accessible.
List
There is a form in list format:
Data containers can not be added from this form. An initial data container is created when you define a new databases.
Details
There is also a details format:
Buttons
The "Save" button memorises changes made to the changeable fields.
The "Delete" button permanently deletes the data container currently displayed, including memorised log on credentials to the platform.
The "Refresh Authorization" button refreshes the connection credentials on platforms where a refresh token is used, such as Exact Online or Teamleader. The authorisation refresh requires you to log on again on the associated platform.
The "Partitions" button opens the list of partitions registered for the data container currently displayed.
Fields
The following fields are available:
- Connector: the platform this data container connects to.
- Alias: an Invantive UniversalSQL data container alias. It is for use on databases with multiple data containers to qualify object names with a reference to a specific data container.
- Connection String: specification of advanced features for the connection. The connection string is a semi-colon separated list of names and values. The available names and values are listed per connector on https://documentation.invantive.com. For ANSI SQL-based data containers, you can also use connection string parameters provided by the backing ADO.NET connector.
- Allow Connection Pooling: Invantive UniversalSQL provides on ANSI SQL-based data containers a custom algorithm for connection pooling. Enable this setting to activate it. Advanced use only.
- User Log On Code: log on code for use with connectors that use traditional user log on code/password combinations.
- Password: associated password or API token key.
Driver Settings
Below the fields, the settings of the driver of this data container are listed, the same ones the Windows products offer on their log on window. Each setting is shown with the name the driver gives it and with the control that fits it: a choice between the values it accepts, a tick between true and false, a field for a number or a field for text. A setting whose value the driver keeps to itself, such as a password or a token, is shown masked and can not be changed here; it keeps the value it already has. The names of the settings are listed per connector on https://documentation.invantive.com and can also be typed in the connection string.

