Skip to content

Pentaho Kettle script for bulk uploading of CIs to CA Cloud Service Management

License

Notifications You must be signed in to change notification settings

codefitz/cacsm_bulkload_kettle

Repository files navigation

CA Cloud Service Management Bulk Load CIs

Pentaho Kettle script for bulk uploading of CIs to CA Cloud Service Management

I no longer have access to Cloud Service Management so these are provided "as is". Contributions and improvements welcome. Happy to assist with bug-squashing and implementation in a limited capacity.

How To

Tested on Bamboo Only.

Install Kettle from here: http://community.pentaho.com/projects/data-integration

Bulk Import

  • Use main_ci_import.kjb to import bulk CIs from a text file (see sample cis.csv).

  • Replace user login details in tf_import_ci.ktr input step:

  • userName

  • userPassword

  • responseFormat - leave as "json"

  • url

  • Update HTTP Post step with http login details

Bulk Relate

  • Use main_ci_relate.kjb to relate CIs to each other from text file input (see sample ci_rels.csv).

  • Replace user login details in tf_relate_ci.ktr input step:

  • userName

  • userPassword

  • responseFormat - leave as "json"

  • url

  • Update HTTP Post step with http login details

About

Pentaho Kettle script for bulk uploading of CIs to CA Cloud Service Management

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published