ODBC Table Selection

Window Details		How Do I...
	Navigation		Export to an ODBC Data Source
	Overview		Link Multiple ODBC Tables
	Fields		Modify the SQL Statement

Related Topics
	Import Job Selection	ODBC Test Read Data
	Import Job Maintenance	Visual Integrator FAQs
	Browse

Navigation

Select Visual Integrator Main menu > Import Job Maintenance. In the Import Job Selection window, enter a job name and table name, and then click Accept. In Import Job Maintenance, in the File Type field, select ODBC Data Source. Click Tables.

Overview

The following information applies only to import jobs for the Material Requirements Planning and Work Order modules.

Use ODBC Table Selection to select the tables and fields (columns) for the ODBC data source. You can also define links between multiple tables (joins) and, if necessary, display and/or change the SQL statement used to extract the data from the ODBC data source.

Fields

1. Tables
Available Tables	Selected Tables

2. Fields
Available Fields	Selected Fields

3. Links
From Table	To Table
(From) Field	(To) Field
Relation	List Box

4. SQL Statement
List Box