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.

Connect to Multiple Data Sources

Live or Scheduled Data Extraction

Data Transformation Capabilities

Load Data into Staging Tables

Report on Data in Wizsm Visivo

Publish Data into Wizsm Performance

Sync Master Data into Wizsm Trova

Capture Streaming Data

Powerful Integration Capabilites

Wizsm Integrator allows the business to break down data silos by combining relevant data from different sources across the organization.

The data retreival, transformation and load can be scheduled in near real time or as required.

Managers are provided with deeper insights on issues and challenges before them, and are enabled to take better decisions.