To map a general table to a database table
You can map a new general table to an existing database table:
*
When editing a flowchart through the Admin menu, as described in Working with user tables while editing a flowchart.
*
Through the Campaign Settings page, as described in Working with user tables from the Campaign Settings page.
You map a new general table to export Campaign data for use by other applications.
1.
Begin from the New Table Definition - Select the table type window.
2.
Select General Table, then click Next.
3.
Select Map to Existing Table in Selected Database, select the customer database name, then click Next.
4.
Select the table you want to map from the Source Table list.
The source fields in the table you select are mapped automatically to new table fields in the general table you are creating. To change the automatic mappings, select fields from the Source Table Fields list or the New Table Fields List, and use the Add, Remove, Up 1, an Down 1 buttons, until the table is mapped as required, then click Next.
5.
(Optional) Change the name which Campaign will use for the general table and its fields.
To change the table name, edit the name in the IBM® Campaign Table Name field.
To change a field name, select the mapping in the New Table Fields list, and edit the text in the IBM® Campaign Field Name field.
6.
Click Finish
You have created the general table based on a database table.
Copyright IBM Corporation 2015. All Rights Reserved.