Importing Data Into Your Database → Importing Data From A Generic ODBC Database → Specifying a Generic Data Source Import Table
The Specify Data to Import dialog box enables you to select a source table from which to import data and to specify a SQL statement to limit imported records to specific criteria.
You can also provide a unique record identifier for each imported item. The benefits of selecting a unique numeric identifier include:
Ordering of source records – When the wizard queries the source database, it uses field for ordering, which provides greater control and allows for more organized log files.
Improved logging – A unique identifier enables the wizard to log detailed information about source and imported items. For example, newly imported items are logged similar to the following example:
Source record 1 established as new TS_ID 60
Updated items are recorded similar to the following example:
Source record 1 already imported as TS_ID 60 -- updated
For details on Import Data Wizard logging, refer to Import Data Log Information.
The following options are available on the Specify Data to Import dialog box:
Source Table – This drop-down list contains all tables and views in the source database that are accessible to the login ID specified when you connect to the database. Select the table that contains the data you want to import. You must specify a source table before continuing with the data import.
Select Records from Source Table Where: To limit the records you want to import from the source table, enter an SQL (Structured Query Language) conditional expression that matches the records to import. Consult your database documentation for details. If you do specify an SQL conditional expression, all records from the source table are imported.
After specifying source table import information, click Next to continue.
Copyright © 2001–2019 Micro Focus or one of its affiliates. All rights reserved.