Connections to External Databases for Value Lists
You can set M-Files to update value lists to and from an external database.
This section tells you how to set value lists to use an application connection to an external database. To use the legacy database connection, see the section "Using the Legacy Database Connection for Value Lists".
Prerequisites
Take note of this important information before you start the setup:
- Before you set up an application connection to an external database, you must have an
external object type connector installed and enabled.
- The connector must support the application connection. You can use M-Files
OLE DB External Object Type Connector, which is
normally installed to the vault but is disabled.
- To use the connector, a license is not necessary.
- For instructions on adding connectors and managing vault applications, see Adding a Connector and Installing and Managing Vault Applications.
- If you use the Ground Link service, the connector must be enabled on the Ground Link proxy. If you use a local service, the connector must be enabled in the vault.
- The connector must support the application connection. You can use M-Files
OLE DB External Object Type Connector, which is
normally installed to the vault but is disabled.
- If you use replication and application connection to an external database service, you must configure the connection separately for each vault in the replication scheme. Make sure that the necessary configuration changes are also made to each vault. We also recommend that you read the section Replication of External Objects of the document Replication and Archiving - User's Guide.
- It is not possible to include the configuration for External Object Type Connector to replication packages.
To use a connection to external database and to open the service configuration:
To specify the connection settings and to get the source columns:
To map the source columns with M-Files
properties:
To take the configuration into use: