Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating SharePoint Connection in ODI 11g

2709933Feb 27 2017 — edited Feb 28 2017

Hi , I need to connect SharePoint from ODI 11g, then using lists and views i have to extract the data and should load into target table. i have separate jar file, using that jar file now we are downloading csv file, then loading the data using ODI OS command like below. java -cp /export/home/odixfer/scripts/wsutil.jar com.wsu.SharepointList user pawrd domainĀ  "url/_vti_bin/lists.asmx" "{3B5F108C-6A78-4F43-97DD-5D8429A789B7}" "{195F74AF-5714-4095-8B79-9A118379E36F}" > filename.csv Instead of manual process, do we have any other option like, creating topology for that connection, and reverse eng then creating interface. Thanks in Advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2017
Added on Feb 27 2017
4 comments
875 views