To load data from files without placing them on TM1 server

[sreesuku]

Hi All,

In Turbo Integrator when we load the data from a text file, there are 2 sections under the tab ' Data Source'. 1) Data Source Name 2) Data source Name on the server.
Is it possible to load the data from some text files without placing them on the TM1 server.
For instance, I have files generated on some other server or they are available in my local. Can I use these files to load data in to TM1 ??
When I don't place the files on TM1 server its gives me the error 'Unable to open data file'

Regards
Sree

[tomok]

You can place them on another server. Just make sure the account TM1 is running under has security access to the files. Then the location would be specified using the UNC path (\\ServerName\ShareName\PathAndFileName). The trick is you will also need access in order to see the data in the preview tab.

[sreesuku]

You can place them on another server. Just make sure the account TM1 is running under has security access to the files. Then the location would be specified using the UNC path (\\ServerName\ShareName\PathAndFileName). The trick is you will also need access in order to see the data in the preview tab.

Hi Tomok,
I am able to preview the data when I place the files in one of our windows server. But when I run the process it gave the error 'Unable to open data source'.
Can you please explain in detail how do I give the security access for TM1 Account to the data files and define the UNC path.

Please check the attached scree shots for the further details

TM1 error Unabale to open data source

TM1 error Unabale to open data source.jpg (5.99 KiB) Viewed 3644 times

Preview Data

Preview Data.jpg (47.76 KiB) Viewed 3644 times

[lotsaram]

I am able to preview the data when I place the files in one of our windows server. But when I run the process it gave the error 'Unable to open data source'.
Can you please explain in detail how do I give the security access for TM1 Account to the data files and define the UNC path.

I am not sure what you didn't understand as it should be pretty clear!
When you preview the data source you are opening the file identified by "data source name" with your user credentials.
When the TM1 server accesses the data source at runtime it uses the file identified by "data source name on server" using the user credentials of the account running the TM1 service. If the location is on a network resource then the account used to run TM1 must have access to that location. If TM1 is being run under the server local admin account then it will be able to access only files on the same physical server.

[Andy Key]

When you preview the file, you are running the preview in the context of the user that you are currently logged on as, and using the file name as supplied in the Data Source Name box.

When you execute the process, you are doing so in the context of the user account that is running the TM1 service, and using the file name as supplied in the Data Source Name On Server box. Have a look in the Windows Services applet, find your TM1 server service and check the Log On As field. Unless you have changed this, it is probably set to the Local System account. As the name suggests this is Local to the machine and nothing to do with the domain, so won't have any access to the other server where your data file sits.

- Edit Ha! Snap.