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 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