Data Transformation Engine Introduction to the Design Studio

Chapter 5 - Database Interface Designer Database/Query Files
Introduction to the Design Studio
58
Database/Query Files
Use the Database Interface Designer when working with database/query files to
create database/query files and define the various objects included in a
database/query file.
A database/query file (
) contains the definitions for one or more databases,
queries, stored procedures, and other specifications that may contribute to the
execution of a map. A database/query file is created in the Database Interface
Designer and has an .mdq file name extension. The filename and path of the
active database/query file appear in the title bar of the Database Interface
Designer.