BODS to SharePoint list using web services

[Former Member]

Hello All,

Thanks in advance.

I got an assignment to push the data from Hana to SharePoint list using BODS.

Created a Datastore for Input, able to see the Hana data without any issues.

Added a Datastore for SharePoint list using SharePoint web services. Able to see all the functions and imported the function "UpdateListItems" to send the data from Hana to Sharepoint list.

How to configure the job to send the data from Hana datastore to SPS data store on scheduled manner?

Any help is really appreciated.

Thanks

Sriram E

[former_member187605]

You'll have to call the function from within a Query transform.

Check out Consuming an external Web Service - Enterprise Information Management - SCN Wiki and http://wiki.scn.sap.com/wiki/display/EIM/The+Nested+Relational+Data+Model+NRDM for all details on how to call a web service and deal with the NRDM in DS.