To export a schema to the MQSI or e-Biz Integrator, first create a schema name and associate it with record definition(s) and then export it to the e-Biz Integrator, e-Biz 2000, or MQSI.
Exporting a schema to MQSI or e-Biz Integrator
Choose Application Files>Export Definition>Schema>e-Biz Integrator
or
Application Files>Export Definition>Schema>MSQI from the main menu.
The SchemaExport window displays, asking if you would like to select a configuration File for schema mode.
If you select Yes, the Choose Configuration File window displays. Select a configuration file.
If you select No, the Configuration File Options window appears.
Select With MQSI or e-Biz Integrator Options, select OK.
The Configuration Information window displays.
Enter the following information on the Configuration Information window:
Server Name – the name of the computer where the database used by the Rules and Formatter is installed.
User Name – used to log onto the computer where the database used by the Rules and Formatter is installed.
Password – used to log in to the computer where the database used by the Rules and Formatter is installed.
Database – the name of the database that Rules and Formatter set up as a schema repository and to which you will export this schema.
Formatter Version – the database (including version) that is loaded on the computer where Rules and Formatter is installed. Select from the following:
Version 4.11 – Microsoft SQL Server
Version 4.11 – Oracle 8.x Server
Version 4.11 – DB2 5.x Server
Version 4.11 – Sybase 11.x Server
Version 5.1 – Microsoft SQL Server
Version 5.1 – Oracle 8.x Server
Version 5.1 – DB2 5.x Server
Version 5.1 – Sybase 11.x Server
Prefix – a unique identifier that is placed at the beginning of all of the schema names, and which help locate the schemas in the Rules and Formatter schema repository. The prefix cannot be longer than 5 characters.
Select Next.
The schema configuration file appears. Sample configuration files are in the ECMap Reference Guide. Make any modifications needed to the configuration file and then select Save. The Schema Export – Schema Name Selection window displays.
Create the name of the schema that you are exporting to the Rules and Formatter repository, and a description of the schema.
Select the Add button.
The Add Schema Name window displays.
Enter the following on the Add Schema Name window:
In the Schema Name text box, enter a name for the schema you are exporting to the Rules and Formatter schema repository.
In the Description text box, enter a brief description of the schema.
Select OK to return to the Schema Export – Schema Name Selection window.
The names and descriptions of all schemas associated with this map display.
To delete a schema, highlight the schema and select Remove.
To add another schema, select Add and follow the instructions above.
When you have finished adding schemas, select Next at the bottom of the window.
The Schema Export - Record Selection window displays.
All of the records that are defined in the current map display on the Schema Export - Record Selection window.
Select the check boxes next to the record definitions that you want to export to the Rules and Formatter schema repository.
Select Next.
The Schema Export – Schema Creation window displays.
Drag and drop associate records with a file and to create parent-child relationships between the records.
The record(s) selected for export display in the Records pane on the left side of the window. The schema name(s) you created display in the pane on the right side of the window.
For each schema, drag the parent record that you want associated with a schema and drop it on the schema name. The record(s) now display under the schema name(s) in the pane on the right side of the window.
Select Next and the Schema Export – Export < schema name> window displays.
On this window, you have three options. You may select any combination of these options. If you choose:
Export Schema – the program exports the schema(s) you created, and places them in the Rules and Formatter schema repository.
Create Flow – the program automatically creates the outbound map flow table associated with this schema. The flow table includes the flow relationships and the rules to read the NDO records. (This option is not available for inbound maps.)
Create File Definition – the program creates a file with the name of the schema/message, assigns NDO as the file type, and creates the association between the file and the records you selected for export.
Select Finish.
The window closes, and the program performs the option(s) you selected. You receive messages telling you that the operations were successfully performed.
Select OK on each message box.
