General
SQL datasources can be used to directly connect SQL databases to Mail & Deploy. The following SQL datasources are supported:
Considerations
When rebuilding the cache of an SQL datasource, Mail & Deploy will collect all tables, views, and their columns. When filtering the data model (i.e. using a Filter Datasource Field Action) the filter will only be applied to the view or table to which to the filtered field belongs. Mail & Deploy will not automatically filter related (i.e. by foreign keys) tables or views.
Whitelist IP addresses and Ports
Please contact us to get the IP address that should be whitelisted if this is required.
Please let us know if you need us to open an outgoing port.