In order to use the CAM External Connector most effectively, consider the following to determine the best location of the CAM Database:
- Installing the CAM Database in its own SQL Server instance, but on the same machine as that hosting the other database. In this case, the import from the other database to the CAM Database will be faster. Each SQL Server instance has its own process and memory usage, but both databases must draw from the same overall pool of memory on the machine hosting SQL Server.
- Installing the CAM Database on a dedicated physical or virtual server with fast network access to the machine hosting the other database. In this case, the import from the other database to the CAM Database will be slower, but the memory needs of the CAM Database will not impact the other database.
Once you've determined where to perform the installation:
- Install the CAM components to the desired machines. The CAM External
Connector is automatically installed with the
The CAM External Connector is also installed as a part of the separate Database Tools install.
- Launch CAM Administrator and enter your license key. You can skip running the Setup Wizard, as you will be importing data via the CAM External Connector.
- On the Status panel, check to see if the Cherwell Software Identification Database (CSID) is up to date; if it isn't, update it.
- Browse to location where the CAM External Connector is installed (for 64-bit installations, C:\Program Files (x86)\Cherwell Asset Management\Connector is the default).
- Run CAMExternalConnector.exe to start the CAM External Connector tool.
Once you've configured the CAM External Connector, you can import directly from within the tool or schedule the import to run on a regular basis.