During this tutorial of ECMap, create a map that converts XML data to a proprietary ODBC database format. Use an any-to-any map to accomplish this — importing the source record definitions from XML schema and the destination record definitions from the ODBC output data. We use a BizTalk XML schema in this example.
For this exercise, you are a company called Toys for Business that sells electronic toys to a trading partner called Major Playtime Tools (MPT). MPT sends all of its purchase orders as XML data, and you must be able to accept purchase orders in this format in order to do business with MPT.
You can complete this exercise in three easy steps:
To use this tutorial, you need to have installed ECMap on your PC.
You need the following data files, which were supplied with this tutorial:
c:\Program Files\Sybase\ECMap\maps\data\podata.xml
c:\Program Files\Sybase\ECMap\maps\data\poschema.xsd
c:\Program Files\Sybase\ECMap\maps\data\PO_DATA.mdb
Throughout this tour, the above path is abbreviated to c:\..\
Starting the tutorial
From the desktop, double-click the ECMap (globe) icon on your desktop. (When you install ECMap, the installation process automatically places this icon on your desktop.)
In the Password text box on the Login window, type ecmap. Press ENTER or select OK.
The main ECMap window opens and you are ready to begin the tutorial. To perform actions in ECMap, you can use the menu options at the top of the window or the icons on the toolbar. (The icons are also available on the ECMap Work Space, which can be opened by choosing Workspace from the View menu on the main ECMap window.)
Project  |
Map  |
Company  |
Partners  |
Application Directories  |
Files/Databases  |
Records/Tables  |
Memory Variables  |
Rules  |
Mapping  |
Map Flow  |
Generate Map  |
Run Map  |
||
On many windows with a drop-down list of available choices, if you begin typing your choice, ECMap automatically enters it for you.
You can use the Tab key to move from text box to text box when entering data on a window.
On windows with a Next option, you can either select Next or press Alt-N.
We assume you are using C as your hard drive. If not, substitute your hard drive letter for C.
