Database Tools

CSM provides tools and wizards to help manage data and databases. 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

  • 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. In the CSM Administrator main window, create a New Blueprint. From the Menu bar, click Managers>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. In the CSM Administrator main window, click the Database category, and then the Import external data task.
  • Import Data Wizard: Provides the steps to run a one-time import of .csv data into a CSM Business Object. In CSM Administrator, click the Database category, and then either Run a one-off data import (.csv files) or Stored Import Definition Manager (.csv files).
  • Stored Import Definition Manager: Helps manage (create, edit, and delete) stored .csv imports.
  • Scheduler: Use the Scheduler to manage automated data imports.
  • Import Utility: Imports .csv files into the CSM Database.

Stand-alone Database Tools

  • System Restore Tool: Allows a system administrator to import the CSM Database for the first time or reload the CSM Database from an archive file (.czar file).
  • System Upgrade Tool: Allows a system administrator to upgrade a CSM Database to a new version. When installing a new version of CSM and running Cherwell Administrator, it prompts an upgrade to the database and automatically runs this tool.
  • Import Utility: Imports .csv files into the CSM Database.