Unloading dataset using XMDBTool

From 10.1.3, it is possible to unload data from the Expense Management tenant database to the client machine using XMDBTool. A new batch file (download_all.bat) is used to download all the tables from Expense Management transaction db.This batch file is available only in the XMDBTool PSO distributable.

Download_all.bat has these parameters:

• skipTableList – You can specify a list of tables that do not get unloaded. This list of table is a comma separated list. However, if this parameter is supplied viz the command line then please ensure that each table is separated with a dot (.) instead of comma. For example download_all -skipTableList alco_user.alco_division. By default, skipTableList is set to almt_maxbobid.
• printColumnHeaders – If set to true it prints column headers. By default, it is false.
• downloadFolderName – This is the name of the folder in the client machine where the downloaded data is residing.
• unloadToDataSets - This can be set to true or false. By default, unloadToDataSets is set to true. If set to true, download_all.bat downloads all the data files to specific directories. If unloadToDataSets is set to false, all the data files are downloaded to a single folder (that specified in the downloadFolderName parameter).

Since, there is a substantial number of files, these files will be downloaded from the server to the client in batches. There is a parameter called numOfFiles, that is used to specify the number of files in each batch. By default, the value of this parameters is 15. That means if numOfFiles is not specified, 15 files are downloaded per batch. If this parameter is set to 50 the number of files downloaded are 50 and so on.