04-03-2014 11:26 AM - edited 04-03-2014 11:38 AM
I am trying to import ci relationship data from excel to HPSM using text delimiter(Source) and Database(Destination).
Here's a link to the post http://h30499.www3.hp.com/t5/HP-Service-Manager-Se
Instead of using Database as the destination Connector, I tried to use Service Manager Web Service or Service Center/Service Manager as the dstination Connector. But couldnot find "cirelationship" table in the destination.
So what I did is, I tried to publish the table "cirelationship" as a webservice so that other integrating application can use the table. Followed the steps as mentioned below,
1. Tailoring > Database Manager
2. Typed extaccess > Search
3. Name-cirelationship, Service Name- CiRelationship, Object Name- CIRelationship
5. Restarted the SM Services.
Now, in CIT, after defining the destination Connector as Service Manager Web Services, I couldn't find the element "CIRelationship" under Destination Connector.
Am I missing out something? Need help out here.
Thanks and Regards,
04-03-2014 12:14 PM
The ConnectIt Connector shows only the OOB options in that dropdown, but you are not limited to those options. Instead of selecting an endpoint from the dropdown (for example, IncidentManagement) you enter your own value in the Service Name field - in this case, CIRelationship.