iMIS Analytics is made up of a number of components. One of those components is the collection of "mappings" that give the instruction for the ETL operations (Extract, Transform, and Load) form source databases to the iMIS data warehouse. There are sever components to the mappings, but the component of interest in this article is the "extract script". Extract scripts are SQL based processes that perform the "E" in ETL.

From time to time, ASI, customers or partners may make available improvements or other updates to these scripts. This article addresses how to update the scripts in the field.

Steps to update an Extract Script.

1. Be sure you have a current backup of your data warehouse database.
2. Locate the new or replacement script as instructed. Usually updated scripts can be found at: http://svn.imiscommunity.com/viewcv/imiscommunity/trunk/imis/modules/ana...
3. Get a copy of the replacement script into the cut and paste buffer.
4. Open the Analytics Configuration tool from the start menu.
5. Select "Tools-->Mapping" from the menu.
6. In the "Table List" select the table/script name that is going to be updated.
7. Select the "Extract Script" tab.
8. Get a copy of the replacement script into the cut ans paste buffer.
9. Clear the existing script by right clicking on the body of the existing script and "select all", then right click and "delete".
10. Paste the replacement script into the text area by right click and "paste".
11. Press the save button above.
12. Close the mappings and configuration tools.