Data Extractor for CapMan

File uploaded by kopja02 Employee on Aug 27, 2014
Version 1Show Document
  • View in full screen mode

capManExtract -utility for extracting data from Capacity Manager. CA Technologies Engineering Services @ 2014

Version tested with: Java(TM) SE Runtime Environment (build 1.7.0_55-b13) 64-bit

1. Extract to any folder

3. There are three files, capManExtract.jar and capManExtract.bat, and the queries.xml

4. Open the capManExtract.bat for edit, and modify the connect information in double quotes

java -Xms54m -Xmx128m -jar capManExtract.jar "DB IP Address" "DB Username" "DB Password" "DB Instance name" "DB Port" "DB Type"

Supported DB Types are "SQL Server" and "Oracle". Note that this is case sensitive.

5. Open command prompt and rum 'capManExtract.bat'


C:\AASoftware\CapMan\Extractor>java -Xms54m -Xmx128m -jar capManExtract.jar "ITCAPA1" usr" "pwd" "SQLVSphere5" "1433" "SQL Server"

6. Any errors are displayed in the command line. If you wish a separate output.log -file for the errors, modify the capManExtract.bat to contain the following

java -Xms54m -Xmx128m -jar capManExtract.jar "MSSQL IP Address" "MSSQL Username" "MSSQL Password" "SQLVSphere5" "1433" > output.log

7. The command will print output for each query in c:\cap -folder.

8. Queries in the 'queries.xml' can be modified