This picture shows Data Connections, Query Objects, and Variables in the Data Link tab.
     Each database is defined as a connection object. Types of connection objects are: ODBC, flat file delimited, flat file fixed, and custom.
     Then a variable is created internal to PatternStream for: a) needed data fields from one or more databases, and b) other variables needed in the publishing process. PatternSteam supports all the usual data types.