To create a table catalog

You create a table catalog by saving the user tables that are in the current flowchart’s internal table catalog. Saving table catalogs with commonly defined table mappings makes it easy to share table mappings or restore table mappings.

1.	Follow the instructions in To access table catalogs. Ensure that the user tables you want to save as a table catalog are mapped in Campaign.

2.	In the Table Mappings window, select the user tables you want to save to the table catalog, and click Save.

3.	In the Save Tables window, select the option to save all table mappings to the table catalog, or the option to save only the selected table mappings to the table catalog, then click OK.

The Save Table Mappings to Catalog File window opens.

4.	Enter details for the new table catalog, including the folder under which you want to save it, a name, security policy, notes, and whether you want to save this catalog with database authentication information.

5.	Enter a name for the table catalog. If you enter .XML as the extension name, the table catalog will be stored in XML format rather than as a proprietary binary file.

The name must be unique within the folder; otherwise you will be prompted to overwrite the existing table catalog with the same name. The name cannot contain any periods, apostrophes, or single quotation marks, must begin with a letter and can only contain the letters A-Z, the numbers 0-9, and the underscore character (_).

6.	(Optional) Add a description for the table catalog in the Note field.

7.	(Optional) Check Save with Database Authentication Information.

If you leave Save with Database Authentication Information unchecked, anyone using this table catalog will need to provide a database login and password for any data sources referenced in the table catalog. These passwords may be already stored in their ASM user profile. If they do not already have a stored valid login and password, the user is prompted to provide them. This setting is the best practice for security purposes.

If you check Save with Database Authentication Information, the current authentication information (the login[s] and password[s] you are currently using to access these data source[s]) are saved with the table catalog and anyone with access permissions to this table catalog will automatically be connected to the data sources using the authentication stored in the table catalog. This means that users of this table catalog will not need to provide a login or password to access these data sources and will have all the privileges of the stored login for reading and writing to the data source. You may want to avoid this setting for security reasons.

8.	Select a folder in which to save the table catalog using the Save Underdrop-down list.

You can organize table catalogs in folders. Select an existing folder from the Items List, or click the New Folder button to create a new folder.

If you do not select a specific folder, or choose None in the Save Under drop-down list, the current table catalog will be saved at the top level. The selected folder appears after the Save Under field.

9.	Click Save.

The table catalog is saved as a .cat file if no extension was provided with the name and in the location you have selected. If you specified a file name with a .xml extension, the table catalog is saved in XML format.