Importing i2 Data into the PDW Catalog

If you are using eDataFlex Catalog Connect from i2 Technology, you can take advantage of a specially designed i2 data import utility that formats and maps the data for you.

To import i2 EDATA FLEX Relational Tables into the Product Data Warehouse (PDW) Catalog, use the i2 Data Import Utility instead of the PDW Data Import Utility. i2 data's format is unique and Eclipse has designed a separate way to import the i2 data. You need to schedule the import.

Before you run the utility, load the i2 data into a system directory. You do not need to define the data layout or map. The i2 Data Import Utility formats and maps the data to the PDW Catalog.

To import i2 data into the PDW catalog:

  1. From the Tools > Product Data Warehouse (PDW) > PDW Data Imports menu, select I2 Data Import Utility to display the I2 Update of PDW Catalog screen.

Note: If prompted, log on to the character-based system.

  1. In the Data Sub-Directory field, enter the sub directory holding the i2 data.

  2. In the Load Date field, enter the date you want this data to load and be marked as effective in the PDW Catalog.

For example, if you are importing new pricing information on 12/01/01, but the data is not effective until the new year, enter 01/01/02 as the Load Date to mark the information as inapplicable until the correct date.

  1. In the Number of Threads field, change the number of concurrent processes that will load the i2 data, as needed.

Note: We recommend that you use the default in this field unless you are experiencing performance issues. Contact your PDW installer if you are experiencing performance issues.

  1. Use one of the following hot keys to import the data and exit the screen:

Hot Key

Function

Schedule

Displays the Phantom Scheduler, where you can schedule the import.

Begin

Runs the import immediately.

See Also:

PDW Importing Overview

Tasks Not Available in Solar