Create a directory for the flat file cache where the Analyst tool stores uploaded flat files. The Data Integration Service must also be able to access this directory.
If the Analyst Service and the Data Integration Service run on different nodes, configure the flat file directory to use a shared directory. If the Data Integration Service runs on primary and back-up nodes or on a grid, each Data Integration Service process must be able to access the files in the shared directory.
For example, you can create a directory named "flatfilecache" in the following mapped drive that all Analyst Service and Data Integration Service processes can access:
If the Analyst Service connects to a Data Integration Service that uses operating system profiles, the operating system user specified in the operating system profile must have access to the flat file cache directory. If the Analyst Service and the Data Integration Service run on different nodes, the operating system profiles must be configured for both nodes. The flat file cache directory specified in the operating system profile must be accessible from both nodes.
When you import a reference table or flat file source, the Analyst tool uses the files from this directory to create a reference table or flat file data object.