Introduction to SQL

General

SQL datasources can be used to directly connect SQL databases to Mail & Deploy. The following SQL datasources are supported:

• Microsoft SQL Server Databases
• MySQL Databases
• Oracle Databases

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.