Using a data source on a sharepoint server for TM1

[dan.kelleher]

I'm trying to access a file via TI residing on a sharepoint server.

I have given the service account the necessary permissions to access the folder the file resides in, and can access the folder using windows explorer when on the server.

When I run the TI process however, I get a "unable to open datasource" error.

Any help greatly appreciated.

Thanks,

Dan

[jim wood]

Are you using a unc path? for example \\example\example_file.csv,

Jim.

[dan.kelleher]

Yes, I'm using

\\ServerName\Folder\File.csv

[jim wood]

Are you using the local desktop user for the service? I know you have gicen it permissions but whne using that user you can get some funnies.

[jim wood]

Another thing to consider is adding a batch copy to your process. We run on Unix servers and we have terrible trouble with samba shares. To get around this we have a batch file that copies all needed files to the Unix server first and our processes run from there,

Jim.

[dan.kelleher]

I'm using a domain service account.

I also would like to be able to write to the sharepoint server if possible.

Thanks for your help.

Dan

[tomok]

I've never tried to use a Sharepoint file in TI but I've used files located on Windows shares numerous times, even those under web sites. If anyone has the file open, even if it means they are dispaying the contents in their browser, you'll get that error message.

[jim wood]

That's a good point. If the sharepoint services are running it may have it locked in some way. That's another good reason to copy the file first as I suggested.

[blackhawk]

Here is something else to consider, though I cannot say this is necessarily the case here, because I don't know the underlying code. I do however, know how this would work when building applications for portability.

TM1 server is built to run on multiple platforms and it is written in C and C++. This *may* mean that they are using the lower level file open routines rather than the windows routines in the client side, which know how to hit a Sharepoint server.

The best way to figure this out is to run procmon.exe (part of SysInternals tools - look them up in google if you haven't used them) on the tm1sd.exe and see what files it attempts to get when you run the TI process. If it truely is a permissions issue, then you will see a denied message in the monitor. If not, you will see some other failure message. This might give you some insight as to the problem.

[blackhawk]

I also would like to be able to write to the sharepoint server if possible.

Dan.

As far as writing back to SharePoint from TM1, you might consider looking at Enterprise Services. It has the ability to syncrhonize data from TM1 into SharePoint lists on a scheduled basis. If you want to know more send me a private message or we can further this discussion in the commercial section.