DMT Documentation

1. DMT Installation

1.1. Before You Start

1.2. Installing DMT

1.2.1. Windows User Access Control

1.2.2. Installation steps

1.3. Checking the Installation

1.4. Troubleshooting the Installation

2. DMT Overview

2.1. Launching DMT

2.3. Basic Principles

2.4. The 1 minute startup guide

3. DMT Quick Start

3.1. Create ODBC Data Sources (in Windows)

3.2. Create Database Connections (in DMT)

3.3. Create your first Job

3.4. Validate the Job

3.5. Run your first Job

4. Groups and Jobs in Data Moving Tool

4.1. Running Groups and jobs

4.2. Available Group and Job Types

5. Export Tab: Export Data

5.1. List of Export Groups and Jobs

5.1.1. Shortcut Buttons

5.1.2. Export List Context Menu

5.2. Export Group or Job Parameters

5.3. Export SQL Statement

5.4. Scheduling Parameters

6. Transform & Load Tab: Transform and Load Data

6.1. List of Load Groups and Jobs

6.1.1. Shortcut Buttons

6.1.2. Load List Context Menu

6.2. Load Group or Job Parameters

6.3. Load Mapping

6.4. Scheduling Parameters

7. Scheduling Condole Tab: Schedule Exports and Loads

7.1. Current Operation

7.2. Operations History

8. Scheduling Parameters: When to Run Exports and Loads

8.1. Common fields for all scheduling frequencies

8.2. Scheduling Frequency: Manual

8.3. Scheduling Frequency: Continually

8.4. Scheduling Frequency: Daily

8.5. Scheduling Frequency: Weekly

8.6. Scheduling Frequency: Monthly 1

8.7. Scheduling Frequency: Monthly 2

8.8. Scheduling Frequency: After Export

9. Run Pre-Conditions: Control execution of Exports and Loads

9.1. SQL Query Pre-Conditions

9.2. File Pre-Conditions

9.3. Overall Pre-Conditions Commands

10. Pre and Post Processes: Additional custom processing

10.1. Run a DMT Export or Load

10.2. Run an SQL Statement

10.3. Run an Executable

10.4. Upload or Download a file via FTP

10.5. Send an Email

11. Advanced Parameters for Exports and Loads

11.1. Advanced Parameters for Export Groups

11.2. Advanced Parameters for Export Jobs

11.3. Advanced Parameters for Load Groups

11.4. Advanced Parameters for Load Jobs

11.5. Advanced Parameters: Error Handling

12. Run Variables: Access to Runtime Information

12.1. Principles: How do Run Variables Work?

12.2. Custom Run Variables

12.3. Predefined Run Variables

13. Settings Tab: Configure DMT

13.1. Settings: DB Connections

13.2. Settings: FTP Connections

13.3. Settings: General

13.4. Settings: Export

13.5. Settings: Load

13.6. Settings: Logging

13.7. Settings: Application Events

13.7.1. Application Events: Errors

13.7.2. Application Events: Warnings

13.7.3. Application Events: Run Information

13.8. Settings: Scheduler

13.9. Settings: Email

13.10. Settings: Appearance

14. Miscellaneous

14.1. Data File Parameters Form

14.2. Column Definitions Form

14.2.1. Common Fields

14.2.2. Data File Columns

14.2.3. Destination Table Columns

14.3. Expression Editor Form

14.3.1. Expression Area

14.3.2. Data File Columns and Run Variables Area

14.3.3. Categories Area

14.3.4. Functions and Operators Area

14.3.5. Description Area

14.4. LRI Form (Last Run Information)

14.5. Run Progress Form

15. Help & Support Tab: Information, Documentation, Support