Introduction

The new Bulk Data Loader supports migrating large amounts of legacy data into an Optiva database, without directly accessing the database.
The main purposes of the Bulk Data Loader are:
  • Provide a tool to MT SAAS customers to support load of business object data.
  • Ensure that data coming into Optiva is valid.
  • Validate as quickly as possible.
  • Generate scripts for loading legacy data into Optiva.
  • Apply scripts for loading stage tables data into Optiva tables.

At this time, the Bulk Data Loader is supported only for MT SAAS customers. Other tools exist that can be used in other implementation environments.

Bulk Data Loader uses the schema of the Optiva database. The BDL creates the tables called stage tables in the same Optiva database and validate the data in these stage tables.

Stage Tables

Stage tables are SQL Server database tables. These database tables are based on an Optiva database schema where unvalidated data can be loaded without the normal constraints of an Optiva table. These tables are used by the Bulk Data Loader to validate the data so that it can be cleaned up and added to the target Optiva tables.

Initially, the tables are empty. Special columns exist to track the status (BDL_STATUS) of the data loading functions and a sequence number (BDL_ROWNUM) as data is loaded.

Note: Administrators should get a copy of the Infor PLM for Process - Optiva Database Reference for working through data preparation TYPE_IND and key functional columns. It is available in the Support KB or by request from Support. In future phases of the product, we hope to include the information in the COMMENTS of the template.