| # Glossary for the BC package Architecture A detailed investigation will be initiated to analyze the customer environment related to business and functional aspects, customizations used localization, and technical infrastructure. Assessment Before you start up the actual migration activities, you must carry out an assessment to provide insight into the efforts to be made for the migration, as well as the feasibility and the main risks. Bad Files (Oracle/MSSQL Server) The Oracle and MSSQL Server Database Loader utility creates these files to specify which records were rejected due to data errors. This file contains the records that were rejected due to data errors. These files are created with the name < ERP LN 6.1 table name >.bad. BC Conversion package. All the components of the conversion are under the BC package. BSE The Software Environment: This variable contains a directory path in which all runtime files and programs are located. BSE_TMP This variable contains a directory path in which temporary LN application files will be stored. BW BW is a graphical user interface program in the LN software that runs on a PC in a Windows environment. CA Engine The CA Engine 2.0 generates objects from the 3GL source code generated by the CA Studio and distributed by means of an CA Logic Pack. Subsequently, the CA Engine starts with the execution of preconversion sessions, followed by the execution of the conversion objects. Finally, the post-conversion sessions start. OTHER: This tool performs the actual data conversion, using the data conversion scripts generated by CA Studio and is also used to execute pre- and post data-conversion activities. This tool was developed in Tools. CA Logic Pack The CA Logic Pack contains source codes of the conversion logic that can be imported by the CA Studio. CA Object Pack The CA Object Pack contains the encrypted 3GL source code files generated by the CA Studio. CA Studio The CA Studio enables you to load, compare, and map data dictionaries from a source and target environment. The mapped data dictionaries are converted to conversion rules that can be modelled and validated. The conversion rules can be exported to XML files. Based on these XML files, you can generate 3GL source code . OTHER: This tool enables you to capture the difference between two Infor software releases, based on runtime data dictionaries and generates data conversion scripts and is developed in a thin client architecture. Consolidation This phase is the after-migration phase in which the emphasis lies on business performance improvement and new features. Control Files (Oracle) These files are required to load a particular data file into a table. The SQL *Loader utility reads this file for details, such as from where to pick the data file, and which table this data must be loaded into. These files are created with the name < ERP LN 6.1 table name >.ctl. Conventional Load (Oracle) If you use this option to start loading, the data is loaded record by record and the indices are built simultaneously. Conversion In this document, the terms migration and conversion are synonymous. Conversion Adapter The Conversion Adapter is a new generation of flexible conversion tools. With the Conversion Adapter the conversion logic can be generated, modelled, and distributed in a very flexible way, because the conversion logic will be split from the conversion tools. Conversion Object An object that stores the information about how data is migrated to a target table from a source table. The information is stored as: (a) A set of source tables from which data originates. (b) A precondition in what criteria data is coming from each of these source tables. (c) The main query that specifies what fields must be selected under what condition for each of the source tables. (d) Rules on how these selected fields are mapped to the target fields for each dump in the main query. Conversion Parameters Numerous parameter sessions to control the required functional conversion parameters related to the ERP functionality. These sessions are part of the bc package. Database Driver An interface between ERP LN 6.1 and the RDBMS that interprets the commands given in ERP LN 6.1 and maps these commands to the underlying RDBMS. Data Conversion/ Data Migration The conversion of all company data to a new format. Data Files These files are the dump files that are created during the dumping process in MANMAN/HP. These files contain the actual data that will populate the ERP LN 6.1 tables. These files are created with the name < ERP LN 6.1 table name > .dat. Data Validation Analyzer This utility compares data fields between the source and target data environments to validate the correctness of the data conversion process. This utility checks that the business processes are correct between the source and target environments after a data conversion process. This mechanism clearly shows the number of records migrated for each source table to what target tables. This mechanism also checks if the total number of records between the source and target are equal. The mechanisms also compares the data itself for most critical data fields, such as open orders, sales orders, stock, items, and so on. Compare data of the most critical data tables/fields. Features to validate if the content of a field in line is with definition in the runtime data dictionary. If all fields are filled correctly, Mandatory /References / Counters and so on Deluxe Mode (Informix) If you start the load with this mode, the tables are not locked. As a result, the loading of data can take place while other users are working. This mode updates indices, performs constraint checking, and evaluates triggers as data is inserted into the table. Direct Load (Oracle) If you start loading with this option, the data is loaded and the indices are then built. The checks of the SQL layer are bypassed. Dynamic Enterprise Models Most business procedures have considerably changed between the MANMAN/HP source and the LN target environment. A DEM conversion tool is available to help the user perform an automatic conversion of the DEM models. Component release conversion tables are the basis for an automatic conversion of the DEM models that a customer uses. Environment The technical area, which consists of the directories on a system used by the programs. Export The process in which data from the MANMAN/HP database table is dumped in an ASCII file in the format of ERP LN 6.1 tables. Express Mode (Informix) If you start loading with this mode, the tables are locked. Therefore, data loading cannot take place if other users are working. This mode disables indices, constraints, and triggers during the loading process. After the load, indices, constraints, and triggers are rebuilt, evaluated, and re-enabled. GCT Module in the package bc for conversion; all the components of the Conversion Adapter software are available in this module. HPL ipload The High Performance Loader utility that is a GUI mode provided with Informix and only functions in X-windows. HPL onpload The High Performance Loader utility provided with Informix. Implementation Scanner To develop the proper migration plans for a customer, you must know the technical details of the customer's software environment. The Implementation Scanner provides reports that contain information about the system, companies, DEM, software components, and interfaces. Import The process in which data from the dumped ASCII file is loaded in the database table of the target environment. INFORMIXDIR This variable specifies the full path of the directory in which Informix is installed. If your system has multiple copies or versions of Informix, INFORMIXDIR must contain the directory name for the version that you want to access. INFORMIXSERVER This variable specifies the name of the database server. Informix uses the name of the database server as the index to obtain the connectivity information in the remaining fields from the `$INFORMIXDIR/etc/sqlhosts` file when client applications connect to database servers. The name of the database server must correspond to an entry in the sqlhosts file. L1 and L2 Drivers Level 1 and level 2 database drivers. More information is available in the technical documentation of Infor. Log Files These files are created when a data file is loaded into a table with the database-specific Loader utility. This file contains details, such as how many records were loaded and how many rejected, and so on. These files are created with the name < target table name >.log. Mapping Tables Generate and maintain sessions for generation and maintenance of additional temporary mapping tables. Those tables are required to solve complex mapping problems between the source and target tables. Mapping tables are filled and maintained during the preparation phase of conversion process. The logic of mapping tables is part of the bc package. Migration The total set of activities that must be carried out in a project to deliver a new version of the Infor software that works properly with data converted from the old Infor software version, and possibly combined with a new or changed technical infrastructure. Migration Wizard The Migration Wizard tool can be used to migrate the data from the source to the target environment without manually invoking the sessions required for the migration. The Migration Wizard tool is created to simplify the process of migration by running the correct sessions sequentially, depending on the environment and your requirements. Onpload Database The onpload database contains information that the onpload utility requires to perform data loads and unloads. The onpload database can reside on any database server on your network. In addition, any onpload utility can use the onpload database as long as the onpload utility can access the database server that contains the onpload database. In contrast, the onpload utility must run on the same computer as the database server that contains the target database. ORACLE_HOME Oracle Database HOME is the path on which the database-related executables and files are available, and is a parameter that must be set before the migration tool is run, for data to be migrated to ERP LN 6.1. ORACLE_SID Oracle Database Instance ID, a parameter that must be set before the migration tool is run, for data to be migrated to ERP LN 6.1 on Oracle. Post-conversion Sessions Several standard sessions and other specific (bc) sessions in the target environment to fill and correct some target tables, to be run before operational work can be started in the target environment. Pre-conversion Sessions Several standard sessions and other specific sessions in the source environment to correct and verify the source database. The specific sessions as required for preconversion are part of the bc package. In addition, a number sessions in the target environment for conversion of some relevant target data to the source environment. Sessions are developed as part of the bc package. Preparation In this migration phase, the entire setup of the customer organization, infrastructure, and software environment takes place. RDBMS Relational Database Management System. Realization After acceptance of the conversion results by the customer, the final cut over will be realized based on the tested infrastructure and tested new LN solution. Reject Files (Informix) The Informix Database Loader utility creates these files to specify which records were rejected due to data errors. This file contains the records that were rejected due to data errors. These files are created with the name < target table name >.rej. Software Component Converter The Software Component Converter supports the upgrade of customized software components based on tools in the source environment to tools in the target environment with mapping features to new or other software components in the target environment. Software Conversion The conversion and upgrade of general or in-house customized software components to a new version. Source environment The environment in which the earlier ERP LN 6.1 application release is present. SQL* Loader Oracle utility to load data in the ASCII file into a table. Target environment The environment in which the new release of the LN application is present. UTC Universal Time Constant. A new concept of representing date. VRC The Version Release Customer (VRC) module in Tools enables you to manage various versions and releases of a package. Four types of VRCs are available: L: Localizations; B: Line of business-specific software; C: General customizations; and O: Customers own customizations. |