Database Tools

CSM provides a plethora of tools and wizards to help manage data and database. Tools are accessed in several ways: launched automatically when performing a task, accessed from within CSM Administrator, and accessed as stand-alone tools from the CSM Tools folder.

Database tools and wizards in CSM Administrator:

• Database page (in CSM Administrator): Access tools for exporting and importing different kinds of data from the CSM Administrator Database page (CSM Administrator>Database), and to Perform Database System Maintenance (Full-Text Searches, Indexes, and some queue/user accounts).

External data tools:

• Connection Wizard: Provides the steps to configure the connections between the CSM applications and the CSM Database. The steps vary depending on the type of connection, either direct-to-database (2-tier) or Application Server (3-tier).
• External Connection Wizard: Walks through the steps to create a saved connection to an External Database (called an External Connection). CSM also provides the External Connection Manager to help manage (create, edit, and delete) the External Connections.
• External Data Wizard: Provides the steps to either map an existing CSM Business Object to an External Database, or create an External Business Object to link/import external data.
• External Data Import Wizard: Provides the steps to import external data from an External Database into a mapped CSM Business Object or an External Business Object.
• Import Data Wizard: Provides the steps to run a one-time import of .csv data into a CSM Business Object.
• Stored Import Definition Manager: Helps manage (create, edit, and delete) stored .csv imports.

Stand-alone database tools:

• System Restore Tool: The System Restore tool is a stand-alone database tool that allows a system administrator to import t\he CSM Database for the first time or reload the CSM Database from an archive file (.czar file).
• System Upgrade Tool: The System Upgrade tool is a stand-alone database tool that allows a system administrator to upgrade a CSM Database to a new version.

  Note: When installing a new version of CSM and running Cherwell Administrator, it prompts an upgrade to the database and automatically runs this tool.

• Definition Editor: The Definition Editor is a stand-alone tool for advanced Users that allows Users to clear demo content from a database and search through definitions and make changes that cannot be made in the application.

  Caution: This is a powerful tool and should only be used if working with the Cherwell Support Team to accomplish advanced troubleshooting or configuration objectives. Please contact the Cherwell Professional Consulting Services team at support@cherwell.com for advanced configurations.

• Import Utility: The Import Utility is a legacy stand-alone utility used to import .csv files into the CSM Database.