Applications

Use the Maintain Applications page to maintain source and target applications for the conversion. To migrate data, you must create an application that retrieves the Infor ERP or legacy data dictionaries from the source and target environments.

The page has the following group boxes:

- Applications: Lists all the applications you have defined.
- Application Details: Use this group box to add or edit an application.

Related topics

- Migration Profiles page

Applications

The Applications group box lists all the applications you have defined.

Field Descriptions
Fields | Description
Application Name | Enter the name that best describes the Infor release. The data models are referred by this name in DCA Studio.
Description | Description of the Infor release.
Application Type | The application type of the metadata saved by the application. Following are the possible values: Non-Baan: Indicates that the metadata stored by the application is of a legacy system. The data models are imported to DCA using OLE DB or ODBC providers. Baan: Baan applications in DCA are used to store data models of a particular Infor Application release. In an Infor ERP, the data models are stored as a Runtime Data Dictionary (RDD).

Processing Options
Commands | Description
New | Opens the Application Details group box. Enter the new application details.
Delete | Deletes the selected application. You cannot delete applications used in the migration profiles.
Browse | Opens the data dictionary page. For Baan applications, the data dictionary is displayed in a new window. For non-Baan applications, the data dictionary is displayed in the Tables/Files page.
Change Connection | Use this option to view DSNs on the Change Connection Details page. The page lists the DSN details such as the user name and password used to import tables. You can change DSN name, user name, and password. Important! This button is enabled only for non SSA-Baan applications.

Application Details

Use the Application Details group box to add or edit an application.

The Application Details group box contains the following tabs:

- General
- Table Defaults
- File Defaults

Field Descriptions
Fields | Description
Application Type | Indicates the type of the application. You can define two types of applications: Infor Application: Enables you to store data models of an Infor application. The data models are retrieved from the runtime data dictionary (RDD). Non-BaanERP application: Enables you to store data models of applications other than Infor. The data models are retrieved directly from database using the ODBC/OLE DB provider for the database.
Application Name | Specify the name that best describes the application.
Description | Provide the description of the application. For example application version etc.
Imported Date | Displays the date and time when the application was created. The field is populated automatically.
Server Name | Enter the server name/IP address of the Infor ERP server. The field is applicable when the Infor ERP is installed on UNIX environment.
Remote Directory | Enter the directory path of the Runtime Data Dictionaries (RDD) stored on the Infor ERP server. The field is applicable when the Infor ERP is installed on UNIX environment. Note To view path of the RDDs, start the Package Combinations (ttaad1520m000) session and double-click your package combination. For example, path of the session is /b5/baan5c/dict and your package combination is b50ustnd, then you must enter /b5/baan5c/dict/ddb50ustnd.

General Tab

Field Descriptions
Fields | Description
Application Type | Indicates the type of the application. You can define two types of applications: Infor Application: Enables you to store data models of an Infor application. The data models are retrieved from the runtime data dictionary (RDD). Non-BaanERP application: Enables you to store data models of applications other than Infor. The data models are retrieved directly from database using the ODBC/OLE DB provider for the database.
Application Name | Specify the name that best describes the application.
Description | Provide the description of the application. For example application version etc.
Imported Date | Displays the date and time when the application was created. The field is populated automatically.
Server Name | Enter the server name/IP address of the Infor ERP server. The field is applicable when the Infor ERP is installed on UNIX environment.
Remote Directory | Enter the directory path of the Runtime Data Dictionaries (RDD) stored on the Infor ERP server. The field is applicable when the Infor ERP is installed on UNIX environment. Note To view path of the RDDs, start the Package Combinations (ttaad1520m000) session and double-click your package combination. For example, path of the session is /b5/baan5c/dict and your package combination is b50ustnd, then you must enter /b5/baan5c/dict/ddb50ustnd.

Table Defaults Tab

Fields | Description
Connection Type | Select the connection type to connect to the database. Following options are available: DSN Name: Select the type of DSN . You must create a system DSN when you use ODBC driver to connect to your database. Connection String: Select the type of the connection string when you use OLE DB driver to connect to your source database.
DSN Name | Enter the system DSN name you have created. As an alternative, you can use the browse button to select the existing DSNs on the DCA Server. Note This field is available only when you set the Connection Type field to DSN Name.
Connection String | Enter the connection string, to connect to your database. Ensure that the connection string does not contain user name and password. Note This field is available only when you set the Connection Type field to Connection String.
User-ID | Specify the user name to connect to the database.
Password | Specify the password for the user. Note Click Test Connection to verify the connection details .

File Defaults Tab

Fields | Description
Source Directory | Displays the path where you must copy the data files, from which you like to migrate data.
Skip First | The initial number of rows that must be skipped in the file before you import the data. Sometimes the initial lines of a file are only descriptions.
Format | Specifies the format in which the data is stored. The following options are available : Delimited: The size of the record of every line in the file is not fixed . A unique character must delimit each column value. The following are the possible values: Comma Tab Semicolon Other: Specify the delimiter other than comma, tab or semicolon. Fixed: The record size in the file is fixed . Each column value must occupy fixed number of characters on every line. Ensure that the delimited character does not appear as a part of the data in the file.
First row has column names | This option indicates whether first row of the file contains field names. If no column names are present in the file, the system generates default column name for each field.
Null values as "NULL" | This option indicates whether the fields of the file with NULL word must be considered as the NULL values in RDBMS.
File Type | Indicates the format of the data stored in the file. Allowed values ANSI: Used by Windows. OEM: Used by some versions of DOS. Unicode: Used by Windows. Each character requires 2 bytes of memory. Unicode supports Japanese and Chinese character sets.
Row Delimeter | The row delimiter using which two records are separated. Allowed values {CR}{LF}: Carriage Return and Line Feed (Windows files). {CR}: Carriage Return. {LF}: Line Feed (Unix Files).
Text Qualifier | Indicates whether the text is enclosed within a single quote or double quote. The text qualifier differentiates text from the numerical data. Allowed values {none}: Text is not enclosed within any specific character . Target table structure is created according to data in the field. Single Quote {'}: Text data is enclosed in single quote {'}. Double Quote {"}: Text data is enclosed in double quote {"}.

Commands
Commands | Description
Modify | Use this option to modify or edit the description of the application you select in the Application group box.
Save | Saves the application details.
Cancel | Cancels the operations.
Test Connection | The system connects to the database using the DSN/Connection string, specified user name and password ; and reports whether the connection is successful.

| Send Us Your Feedback About this Help Page