Add instant value to your business with Codeset and Reference Data Management
The AnalytiX Code Set Manager helps organizations drive the standardization of user defined reference data and Code Sets across an enterprise. The Code Set Manager allows organizations to create standardized code sets and valid values and allows importing of legacy Code Sets across multiple operational systems. The Code set Manager contains interfaces to easily import legacy code sets through its upload and database scanning capabilities and allows customers to build and version Code Mappings and “Code Crosswalks” to drive the Code set standardization processes and review changes to the Code Mappings as they may change over time.
While reference data is similar to code sets in nature, it also has a lot more data that is associated with other data then just a code value and a code description. It has defined hierarchy (i.e. a product belongs to a product family which belongs to a product line which belongs to a brand), aggregation (i.e. lists containing multiple values such as “cancer codes”) or cross-walk (allowing the transition from one set of codes to another by using code translation tables or composite data maps).
AnalytiX RDM lets you create database like structure to maintain all your reference data. You can create your own tables, add columns and scan/maintain all reference data. These reference tables will then serve the purpose for data quality tests by running validations on the data sets. They can also be versioned, published to various environments like DEV, TEST and PROD.
Leverage and enforce industry best practices and standards for creating Code Crosswalks specifications across the enterprise for all data integration projects
Reference Data Manager brings out-of-box features that offer incredible value to any data management organization. Key Features of Reference Data Manager
Mapping Manager allows you to scan and import all source and target databases in just about any file format (XML, XSD, Excel, Flat Files, etc.), so that you can quickly understand the metadata, and begin to build your ‘Pre-ETL’ source to target data mapping designs using drag and drop features, and reusable business and transformation rules.
20 to 50% savings on ETL with code-gen templates: Our out of the box code generation will save up to 20% in the process by automatically creating your job layouts –take that number higher with custom templates that take your jobs to 70% complete and beyond.
Versioning is the one which differentiates between maps. It offers versioning at mapping level and at project level something impossible with spreadsheets.