Wizsm Integrator is an ETL Tool (Extract, Transform and Load) which is used to connect to source systems and retrieve the required data for reporting into Wizsm. It allows for extraction of data from various sources into staging tables. Data is then manipulated as required and the transformed data is loaded into Wizsm. Transformation queries can be written directly in the Wizsm interface and saved.

Wizsm Integrator allows for incremental or full load of the data on a one time or scheduled basis. By combining multiple views of data, it is possible to provide data visualization across systems and provide richer insight to users.

Consuming data using Wizsm Integrator is a simple process.

• Extract Data – Retreive data from multiple data sources and store it in a temporary database.
• Transform – Write transformation queries and visualize merged/integrated data.
• Load – Save the transformed and integrated data into a staging table.
• Schedule – Schedule the task and refresh interval.

Wizsm Integrator is based on the PRISE© Methodology, a best practice methodology for Strategy Execution. PRISE© integrates Processes, Risks, Initiatives and Strategy to ensure successful Strategy Execution.

Wizsm Integrator is part of the Wizsm PRISE© Product Suite, which provides a replicable roadmap to Strategy Execution, and takes us from the “What to the How”. It addresses the pitfalls of having different Management Frameworks run in silos, independent of each other and it provides a holistic view of all management information enabling better decisions.