1. Access the Administration module.
2. Select Integration Tasks from the Integrations option on the menu.
3. In the Integration Tasks section, click Create Task.
4. Select the Extract and Process Intelligence Data option from the list that appears (see figure below).
The system displays the form required to create the new task (see figure below).
5. In the Name field, enter a name to identify the new integration routine.
6. In the Status field, determine the status of the new task. If you select Active, the routine will be activated immediately after it is created. If you select Inactive, the routine will be created but will not function until it is enabled.
7. You can create a schedule for the integration routine in the Schedule section. In the Start on field, enter a start date and a start time for the integration routine. Next, select one of the options (Daily, Weekly, Monthly, Yearly, Every minute, Hourly), to determine the frequency with which the task will be executed. The task can also be set to run only on week days or on weekends as well. In addition, it can be configured to have no end date by clicking the No end date option or configured to end by a certain date by completing the End by field. Note that some integration tasks may take more time to be executed than the option selected, which may result in performance problems.
8. In the SQL Script field of the SQL Script Information section, enter the SQL script to extract and process data from the system database to which you have access. This data will then be stored in templates of the Microsoft Analysis Services database so that it can be used to generate intelligence reports. Note that access to the Analysis Services database must be previously configured in the Intelligence Solution section, located in the Settings of the Administration module.
Note: The SQL script can only query and extract data from these databases and cannot make any changes in them. If a database is not specified in the script, by default the queries will be directed to an external database configured in the web.config file, which is in the installation folder for the system.
9. Mark the Execute immediately after saving checkbox for the system to execute the task once it is saved. For subsequent executions, the system follows the schedule set for the task.
10. When finished, click Save. If you want to quit the operation, click Cancel.
The system displays a success message.