Transforming data generated tools like CA ARD, HP ALM to ALM Octane
This custom solution bridges the gap between widely known tools in the market, namely CA Agile Requirements Designer [ARD], HP Application Lifecycle Management [ALM] and MicroFocus ALM Octane.
Currently, CA ARD provides an integration capability with HP QC/ALM and automatically uploads the test cases generated from ARD to QC/ALM. However, CA ARD and does not integrate with the advanced version of QC/ALM, which is MicroFocus ALM Octane. Likewise, test cases in HP ALM cannot be directly fed into Octane.
A custom solution is written in Python which reads the data generated from CA ARD or HP ALM [.xlsx], transforms and writes the data [.xlsx] to Octane undestandable format. The transformed data in [.xlsx] is further used for import into ALM Octane.
For the easy of usage, custom solution is wrapped as a standard python package using PYPI and made available as ard-transformer
- Python Interpreter to be installed on the machine where this utility is planned to be run. Python can be downloaded from https://www.python.org/downloads/
Run the following command to install the package
pip install octane-transformer
Utility can be run using the command below
Use one of the command below to list the possible command line arguments
transformer -h transformer --help
transformer [-h] [-v] [-p PATH] [-s SOURCE] [-m MODULE] [-i INPUT] [-o OUTPUT] Arguments: -p PATH Path of input and output files -s SOURCE Source System of input file (ARD or ALM) -m MODULE Source Module of input file (Tests or Defects) -i INPUT Name of Input file -o OUTPUT Name of Output file
Below are example commands
transformer -p C:/work -s ard -i ard.xlsx -o octane.xlsx transformer -p C:/work -s alm -m tests -i alm.xlsx -o octane.xlsx transformer -p C:/work -s alm -m defects -i alm.xlsx -o octane.xlsx