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.