Reading Excel files from share point

[mallikharjuna]

hi,

I have requirement to read files from share point. is it possible to read files from share point? if yes please let me know the steps.

Thanks

[mallikharjuna]

Please let me know if anybody know how to read the sharepoint excel file in datastage.

Thanks

[ray.wurlod]

Don't push.

If someone can help you, they will.

DSXchange is an all-volunteer site whose members post when they can, and in any case are not compelled to do so, nor to meet arbitrary timelines.

If you need urgent help sign up with with your official support provider for premium service, and learn just how much "urgent" can cost.

It IS possible to read from Sharepoint, though the security mechanism can be ugly. You will need to have (someone with) Java skills, and make use of the Java client stage.

[chulett]

Never done anything with it but my understanding is "there's a service for that", meaning you'd need to investigate their API. Do you have a technical contact there that can help? Don't worry about the "from DataStage" part, just first do the "read Excel files from SharePoint" part with them.

Oh, and involve your official support provider.