Testing user table access

After Campaign is installed, administrators must confirm that Campaign is configured properly to access the necessary user tables.

Select Settings > Campaign Settings.

Click Manage Table Mappings.

In the Table Mappings dialog, click Show User Tables.

Initially, there are no mapped user tables and the list is empty.

Click New Table.

The New Table Definition dialog opens.

Click Next.

You are prompted to specify whether to map to a file or database.

When Map to Existing Table in Selected Database is selected, you should see one or more databases in the Select Data Source list. If no entries appear in the Select Data Source box, you must define the data sources. For more information, see the installation documentation.

If Campaign is using one or more flat files for user data:

Select Map to Existing File, then click Next.

The New Table Definition window now contains fields for the flat file and data dictionary location.

Click Browse to locate the necessary files, or enter the relative path and file name. Files must be located under the partition root of Campaign to be accessible.

You can now map the user data into Campaign, as described in User table administration tasks.

You can also view the customer databases that Campaign is set up to access when editing a flowchart. Click Settings > Campaign Settings and select View Datasource Access. The Database Sources dialog opens. This dialog lists the system table database and all configured customer databases. From this dialog, you can log in and out of customer databases.