ODBC Table Selection Home | FAQs & Troubleshooting

 

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 Maintenance		ODBC Test Read Data
	Browse		Visual Integrator FAQs

 

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 the Import Job Maintenance window, in the File Type field, select ODBC Data Source. Click Tables.

Overview

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

Use ODBC Table Selection to select the tables and fields (columns) for the ODBC data source. You must select at least one table. 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