Re: Publish a table as Web Service (151 Views)
Reply
Trusted Contributor
SanjeevDas
Posts: 388
Registered: ‎06-17-2013
Message 1 of 2 (169 Views)

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

extaccess_cirelationship.jpg

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,

Sanjeev

 

 

Honored Contributor
Jacob Heubner
Posts: 4,177
Registered: ‎07-21-2008
Message 2 of 2 (151 Views)

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.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.