NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
==Scheduling the Staging Area creation==__NOEDITSECTION__
The above described generation of a staging area needs human interaction. However, once all the options are fixed, there might be the requirement to re-generate the staging area regularly, in order to have an up-to-date reporting database. It is possible to automatize the staging area generation by following these steps:<ol><li>In the C:\IMSMAETLTool folder, create a .bat script named for example '''runStagingArea.bat''' with the following content:<pre>cd C:\IMSMAETLToolcall bin\runnogui.bat</pre></li><li>Edit the properties file C:\IMSMAETLTool\conf\config.PROPERTIES by specifying the required values for all the parameters (they correspond to the ones from the graphical user interface described above). If a parameter should not be used, e.g. '''script_file''', then comment it by placing a # at the beginning of the line:<pre>conversion_language=engazetteer_sequence_level=0#script_file=scripfile.sql</pre></li><li>Schedule a task in an operating system's task scheduler. For example, using Windows 7, follow those steps:<ol><li>Go to Control Panel → Administrative Tools → Task Scheduler</li><li>In the Task Scheduler interface, click on '''Create Basic Task...'''</li><li>In the Create Basic Task Wizard, provide a name, e.g. '''Staging Area Generation''' and an optional description. Click '''Next'''.</li><li>In the next window, specify the required recurrence (daily, weekly, etc.) and click '''Next'''.</li><li>Next, refine recurrence criteria (e.g. time of the day) and click '''Next'''.</li><li>In the next window, select '''Start a Program''' and click '''Next'''.</li><li>Browser to the previously created script, e.g. C:\IMSMAETLTool\runStagingArea.bat. Click '''Next''' and then '''Finish'''.</li></ol></li></ol>The staging area generation should now start at the specified time.
{{NavBox Business Intelligence}}
[[Category:VIE]]
