ODBC Datasources

This is available in version 3.5.11 and later.
We do not offer support for specific ODBC drivers or data sources.
If you are using Mail & Deploy SaaS please contact us if you would like to discuss installing an ODBC driver on your instance.

Name	Description
Connection String	Connection string to the ODBC data source. Examples: DSN=my_db_dsn;PWD=password123; DSN=my_other_db_dsn Driver={MyDbDriver};Server=yourdbserver.com;Database=SAMPLE_DATA;Schema=SCHEMA1;Uid=USERA;Pwd=password123;
Field Query SQL	A SQL query which returns a table containing TABLE_NAME and COLUMN_NAME columns and rows for all combinations of tables and column names. This is optional, if it is set it will be used to populate the 'Fields' entries in the Datasource Browser in the Mail & Deploy Designer. Example: SELECT tableName As TABLE_NAME, columnName As COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='MY_SCHEMA' AND TABLE_CATALOG='MY_DATABASE_NAME'
Table Query SQL	A SQL query which returns a table containing a TABLE_NAME column and rows for all of the tables in the datasource. This is optional, if it is set it will be used to populate the 'Fields' entries in the Datasource Browser in the Mail & Deploy Designer. Example: SELECT distinct TableName as TABLE_NAME FROM system_tables
View Query SQL	A SQL query which returns a table containing a TABLE_NAME column and rows for all of the views in the datasource. This is optional, if it is set it will be used to populate the 'Fields' entries in the Datasource Browser in the Mail & Deploy Designer. Example: SELECT TABLE_NAME FROM sys_views

Name

Description

Connection String

Connection string to the ODBC data source.

Examples:
DSN=my_db_dsn;PWD=password123;
DSN=my_other_db_dsn
Driver={MyDbDriver};Server=yourdbserver.com;Database=SAMPLE_DATA;Schema=SCHEMA1;Uid=USERA;Pwd=password123;

Field Query SQL

A SQL query which returns a table containing TABLE_NAME and COLUMN_NAME columns and rows for all combinations of tables and column names.

This is optional, if it is set it will be used to populate the 'Fields' entries in the Datasource Browser in the Mail & Deploy Designer.

Example:
SELECT tableName As TABLE_NAME, columnName As COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='MY_SCHEMA' AND TABLE_CATALOG='MY_DATABASE_NAME'

Table Query SQL

A SQL query which returns a table containing a TABLE_NAME column and rows for all of the tables in the datasource.

This is optional, if it is set it will be used to populate the 'Fields' entries in the Datasource Browser in the Mail & Deploy Designer.

Example:
SELECT distinct TableName as TABLE_NAME FROM system_tables

View Query SQL

A SQL query which returns a table containing a TABLE_NAME column and rows for all of the views in the datasource.

This is optional, if it is set it will be used to populate the 'Fields' entries in the Datasource Browser in the Mail & Deploy Designer.

Example:
SELECT TABLE_NAME FROM sys_views

ODBC Datasources

Introduction

Properties

What's Next