Batch mode is specifically designed to allow large amounts of data to be exported from TM1 to be loaded into an application or a server. Batch mode is executed as a scheduled process in the background with a predefined TM1 user account (usually an administrative account). This means that TM1 security for the data content must be handled by the application or destination server before distributing to multiple users.
TM1Connect uses a data agent that is usually installed as a service on the same server where TM1 resides (although it is not required) to periodically check TM1Connect for views that are scheduled for export. By having the TM1Connect Data Agent on the same server as TM1, allows for the highest possible performance when extracting large amounts of data, and so that there is no impact on network performance when processing files.
When TM1Connect starts up, it checks to see if there are any pending views to be extracted. If it encounters one, it will dynamically create a TI process which exports the data in an optimized format for speed. This file is loaded by the TM1Connect Data Agent and the dimensional information is added to the file as the output file is written.
The diagram below illustrates the overall flow of data for Batch Mode.