Comarch Data Editor – safeguarding data quality

Ensure the completeness, consistency and accuracy of your data with the Comarch Data Editor tool.

Are there any areas in your system where transaction data is incomplete or out of date? Maybe you want to quickly update your customer data, bulk import new product information, or import missing EAN codes? Or perhaps you need to quickly migrate data from another system or unify data from different sources?

With Comarch Data Editor, it is easy.

Comarch Data Editor

safeguarding data quality

The solution allows for intuitive and quick entry and editing data in databases and data warehouses. Comarch Data Editor helps to manage data in the company better and is a valuable support for processes related to Data Quality Management, Master Data Management (MDM), Data Enrichment and Data Governance.

Even more possibilities:

  • Quick configuration of database views
  • Granting permissions and managing users
  • Automatic cleaning procedures triggered by data saving
  • Data filtering, including defining permanent filters for applications
  • Slowly Changing Dimensions – SCD
  • Ability to paste data from the clipboard and add it to database tables.
  • Changes history preview
  • Data export to Excel
Even more possibilities

When is it worth using Comarch Data Editor?

Data enrichment

Companies often struggle with incomplete or missing information, which makes decision-making difficult. The lack of complete data negatively affects operational efficiency and effective data management.

Comarch Data Editor enables data enrichment by supplementing missing information, integrating data from various systems and external sources and managing master data. The tool facilitates the data enrichment process by combining customer data, transaction data and product data with additional information from ERP or CRM systems. For example, the tool allows to enrich customer data with missing tax identification numbers, addresses or additional product attributes.

Improved data integrity and accuracy ensure consistency of information across the enterprise and enable its use in data analysis.

Improving data quality

High data quality is the foundation of effective data management in an organization. Data inconsistencies, errors, and duplicates lead to incorrect conclusions and ineffective decisions.

Comarch Data Editor enables improvement of data quality by eliminating errors, duplicates and inconsistencies in databases. The tool supports the data quality management process, allowing for real-time validation, cleaning and standardization of data, ensuring its accuracy and integrity. The tool offers the ability to run automatic cleaning procedures and also gives users the option to make manual corrections.

Data standardization

Data from different systems, often stored in different formats, poses a significant challenge in data management processes. The lack of standardization prevents the effective use of information and leads to errors in business analysis.

Comarch Data Editor enables data unification by standardizing formats, values, and structures. For example, you can unify date formats, currencies or units of measurement, ensuring data consistency and integrity across the entire organization.

Creating approval/workflow systems

Approval systems are crucial for organizations that need to monitor and authorize data changes before they are saved, and in companies with complex structures, this often requires multi-stage validation. Such entities need process management tools that ensure data security and control over changes.

Comarch Data Editor allows you to create dedicated approval systems (workflow) in which data is approved at various stages by the appropriate persons. This process streamlines the data lifecycle and ensures data accuracy. For example, budget changes can be authorized at various stages by data analysts, controllers, and department managers. Importantly, every modification is documented and a message about it is available for review at any time in Comarch Data Editor. This ensures data protection, auditability of changes, and improves the quality of processes within the organization.

Setting targets and bonus factors

Setting realistic targets for sales, production or finance teams requires accurate and consistent data on historical performance and future forecasts.

Comarch Data Editor allows you to precisely define and adjust targets in real time. With the ability to group and filter information from different systems, users can create and monitor targets tailored to the company's business models. In addition, the solution enables flexible management of bonus factors and their integration with transaction data, which translates into increased operational efficiency, effective management and better decision making.

Data migration

Data migration between different systems often results in inconsistency or gaps in the final system. This process is crucial for organizations when updating systems or implementing new solutions.

Comarch Data Editor enables data quality management during database migration. It features mechanisms for mapping, duplicate removal and data cleaning. This ensures that migration is carried out in a controlled manner and in accordance with the defined data lifecycle.

Cost allocation

Accurate cost allocation across projects, departments, or products holds key importance for effective budget management and financial control. Dispersed and inconsistent data can lead to wrong financial decisions.

Comarch Data Editor allows you to assign costs to the appropriate responsibility centers based on transaction data and rules established by the organization. The tool also enables dynamic correction and monitoring of changes in these allocations.

Budgeting

The budgeting process requires data integrity and consistent information about costs and revenues, which are often stored in different formats and sources. The need to manually combine this data often leads to errors and reduces operational efficiency. The ability to create flexible budgets in real time is the foundation of effective financial management across the enterprise.

Comarch Data Editor supports the budgeting process by integrating and improving the quality of data from various sources and systems. It enables dynamic management of budget-related data, allowing for adjustments, divisions, and the creation of custom groupings based on transaction and master data. Effective use of budget data will also enable accurate forecasting and financial planning.

Creating custom groupings and segmentation

In many companies, decision-making is based on detailed data analysis, which often requires custom groupings or segmentation. Data analysts and managers in particular need tools that allow them to quickly adapt data to specific business requirements.

Comarch Data Editor allows you to create custom groupings and segmentations of data that meet the specific needs of your organization. Users can create their own categories, filters, and dedicated views of data in various formats and systems. Such data can be used to create dedicated reports and personalized analyses.

Editing and creating data dictionaries

Managing data dictionaries, especially those containing product or customer data, is crucial for maintaining data consistency, however, errors or duplicates may appear in company dictionaries.

Comarch Data Editor allows for easy editing, standardization and updating of dictionaries. The tool also supports the integration of data from various sources, which allows for maintaining data consistency across the entire enterprise.

Data mapping

Comarch Data Editor enables precise mapping of data between different sources and formats, as well as their conversion into a uniform structure. The process is supported by an intuitive interface and mechanisms that automate data management.

Tracking changes or documenting your work

Comarch Data Editor offers real-time changes tracking. The changes history preview provides full transparency and allows the user to monitor when and who made specific modifications to the database. Documenting changes and analyzing their history are key aspects of the data quality management process.

Preparing the environment for end users

In many organizations, processes related to data management and data quality improvement require cooperation between IT departments and business users who expect to be provided with a ready-to-use environment where they can independently supplement data or correct errors.

Comarch Data Editor allows for quick and effective preparation of the environment for end users, providing them with secure and intuitive access to data in real time. Thanks to the ability to define views, assign permissions and implement approval systems, end users can enter, complete and correct data without the risk of compromising data integrity.

For example, the finance department receives an environment prepared in Comarch Data Editor, where it can independently update transaction data, verify product dictionaries, and supplement missing customer data. Thanks to the built-in approval system and changes history, managers have full control over data accuracy.

Working with Comarch Data Editor

  • Application components

    The Comarch Data Editor application consists of the Data Editor Panel and the Administrator Panel. The Data Editor Panel allows for quick data preview and intuitive modification. The Administrator Panel is used to add and edit data sources, views, users and to assign permissions.

    Application components
  • Support for various data sources

    The solution allows for entering data directly into database tables based on connections: MSSQL, PostgreSQL and IBM DB2.

    Support for various data sources
  • Repository

    The tool has a Repository, which is a place where files attached by the user are stored. The file extensions that can be placed in the repository are: pdf, jpg, png, xls, xlsx, doc, docx, msg, txt, csv, sp. Files can also be added to predefined file columns in the table view.

    Repository
  • Cooperation with ERP

    Comarch Data Editor is available to Comarch ERP Optima and Comarch ERP XL users. Comarch Data Editor is also available in a standalone version.

    Cooperation with ERP
  • Advanced features

    • Duplication columns
    • SQL scripts editing
    • SQL procedures
    • Lookups
    • Aliases
    • Slowly Changing Dimensions
    • File columns
    • Expressions editor
    • Locks for concurrent operations
    Advanced features
  • Changes history

    The changes history allows the application user to view changes that have been made to a selected table. Information such as user name, modification date, type of change (edit, add, delete row) and primary key are available in tabular form. This functionality allows for effective changes tracking and auditability.

    Changes history