Page 1 of 1

Reading Excel files from share point

Posted: Wed May 11, 2016 12:23 pm
by 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

Re: Reading Excel files from share point

Posted: Wed May 11, 2016 10:22 pm
by mallikharjuna
Please let me know if anybody know how to read the sharepoint excel file in datastage.

Thanks

Posted: Thu May 12, 2016 1:04 am
by 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.

Posted: Thu May 12, 2016 6:20 am
by 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.