HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Publish a table as Web Service

Trusted Contributor

Publish a table as Web Service

[ Edited ]

Hi Experts,


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-Service/Importing-CI-relationship-data-from-excel-fi...


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


4.  Add/Saved

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,




Honored Contributor Honored Contributor

Re: Publish a table as Web Service

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.