To test user table access
You should confirm that Campaign is configured properly to access the necessary user tables.
1.
Select Settings > Campaign Settings.
The Campaign Settings page opens, presenting links for various administration tasks.
2.
In the Data Source Operations section, click Manage Table Mappings.
The Table Mappings window opens, with Show System Tables selected.
3.
Select Show User Tables.
Initially, there are no mapped user tables and the list is empty.
4.
Click New Table.
The New Table Definition window opens.
5.
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.
6.
If Campaign is using one or more flat files for user data:
a.
Select Map to Existing File, then click Next.
The New Table Definition window now contains fields for the flat file and data dictionary location.
b.
Click Browse to locate the necessary files, or enter the relative path and file name directly into the text box. 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 Working with user tables.
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 window opens, listing the system table database, and all configured customer databases. From this window, you can log into and log out of customer databases.