Data Quality and Transformation
- Case Study: View the Public Works and Government Services Canada case study.
iWorks' software is a revolutionary set of tools for data analysis, transformation and movement (loading of data from source to target systems). Utilizing MetaData management tools and methodologies, a re-usable code base, and Data Quality assurance practices developed over decades, iWorks minimizes maintenance and allows for quick and easy tailoring of data sources that are forever changing.
iWorks' software and solutions bring to life the promise of data integration and data accuracy in a suite of Java / XML based products. Our next generation architecture allows users to bring important data closer to real-world applications for analysis, reporting and critical business decision systems. Built on a platform for enterprise growth and stability, the system integrates powerful techniques for data discovery, data quality and job management in one seamless, web-enabled solution.
iWorks' software and solutions dramatically reduces the time and resources required to manage and maintain data integration and transformation projects. But most of all, it delivers accurate and trustworthy business intelligence to end-users.
When you come right down to it, what business are you really in?
Data Access
Using Data Access components, define source/target & dictionary data collections in one of many formats.
- Source file(s) and/or database(s)
- Target file(s) and/or database(s)
- Dictionaries (used for data validation using lookup tables)
Using the available Data Access Components, it is possible to read-from and write-to various file formats including:
- Fixed-length flat text files
- Variable-length (delimited) flat text files
- Direct database connectivity via ODBC/JDBC access
- Excel files
- .DBF files
Additionally, the application automates metadata collection by utilizing existing RDBMS database schemas. As a result, database table sources can be defined quickly and easily at the touch of a button, and data can be processed directly from the RDBMS without requiring staging files or flat-file exports of the data.
Finally, as with the entire application, the open architecture allows the user to add new Data Access Components where required and make them available for use in the application by other users.
Data Transformation
Your data, once verified for completeness and accuracy, often requires transformation before it reaches the target.
Before iWorks' software, IS departments had to hand code all of the endless routines necessary to make the data accurate and get it into a workable format. These routines were completely custom leaving the user at the mercy of the source data and target environments that are forever changing. The time and cost to create and maintain these routines is significant, especially when trying to manage them in an enterprise-wide setting.
iWorks' data Transformer facilitates data transformation functions through dozens of flexible Business Process Components and Data Process Components. These individual Business Process Components and Data Process Components consist of the most popular business operations in transforming data to the target format in an accurate and reliable manner. Operations such as concatenate, split, and copy get the data into a useable format for business analysis and processing.
For more information, contact: Philip Hume, Identity & Matching Solutions, The Kenna Group. 905-361-4044.