The Database Agent imports contacts from a database table. The agent can connect to any relational database, provided the ADO.NET database provider is installed on the system running the agent, an appropriate connection string can be specified, and the database can be queried with a SQL SELECT command. The agent does not have a fixed field mapping. It can import a photo, provided it is specified as a file name having an absolute or relative path, or as a URL.
Use the child pages for connection settings, field mapping, and custom provider configuration.
Configuration topics
Requirements
The following databases are officially supported:
-
SQL Server 2008 R2 and newer
-
Oracle 11g and newer
-
MySQL 5.6 and newer
Other database providers can be used but are not officially supported.
Phone Number Mapping
Phone number mapping is supported by this agent. See chapter Phone Number Mapping for details.