I want to load all the devices in CA spectrum to SDM CMDB. Is there a way to automate it rather than using API to get data from spectrum and load manually using gr loader.
Out Of the Box (OOB) we don't have such automation.
But you can use the CA PAM (Process Automation Manager). See the link below:
Webcast - Integrating CMDB CI's w/ CA Spectrum via RESTful using CA PAM 5/8
PAM Community Webcast May 2014 Integrating CMDB CIs w/ Spectrum using via RESTful using PAM - YouTube