How Do I Set Up Database Operations In the Data Mapper? (Magic xpi 4.6)

This section provides information about the steps you need to perform when setting up database operations in the Data Mapper. The information provided here is generic for each operation. For specific information about how to write the SQL statements and how to make the mapping connections, see How Do I Create Data Mapper SQL statements and Make the Mapping Connections?.

Insert Operation

The steps below refer to the actions you would perform as part of an Insert operation.

1. Define an XML file as the Source schema.

2. Define a database as the Destination schema.

3. Right-click on the Destination schema and select Show Properties.

4. In the Wizard property, click to open the Wizard.

5. In the DB Operation field, select Insert.

6. For the Destination schema, use the Wizard to insert a valid Insert SQL statement based on the connected database.

7. After you define the Source and Destination objects, you can proceed to the Data Mapper screen where you connect the information retrieved from the XML file to the Insert SQL statement.

Update Operation

The steps below refer to the actions you would perform as part of an Update operation.

1. Define a schema for a database as the Source. The SQL statement in this case is “Select”.

2. Define a schema for a database as the Destination.

3. Right-click on the Destination schema and select Show Properties.

4. In the Wizard property, click to open the Wizard.

5. In the DB Operation field, select Update.

6. For the Destination schema, use the Wizard to insert a valid Update SQL statement based on the connected database.

7. After you define the Source and Destination objects, you can proceed to the Data Mapper screen where you connect the information retrieved from the Select SQL statement to the Update SQL statement.

Delete Operation

The steps below refer to the actions you would perform as part of a Delete operation.

1. Define a schema for a database as the Source. The SQL statement in this case is “Select”.

2. Define a schema for a database as the Destination.

3. Right-click on the Destination schema and select Show Properties.

4. In the Wizard property, click to open the Wizard.

5. In the DB Operation field, select Delete.

6. For the Destination schema, use the Wizard to insert a valid Update SQL statement based on the connected database.

7. After you define the Source and Destination objects, you can proceed to the Data Mapper screen where you connect the information retrieved from the Select SQL statement to the Delete SQL statement.

Select Operation

The steps below refer to the actions you would perform as part of a Select operation.

1. Define a schema for a database as the Source. The SQL statement in this case is “Select”.

2. Define an XML file as the Destination schema.

3. After you define the Source and target objects, you can proceed to the Data Mapper screen where you connect the information retrieved from the Select SQL statement to the XML elements.