Data maintenance is different than data cleansing. Data cleansing is "the process of detecting and correcting (or removing) corrupt or inaccurate records." (Wikipedia) But data maintenance is continual improvement and regular checks of the data.
Companies need to continually ensure that the data in their ERP, CRM or any other core system is accurate, consistent and fresh. While those same systems typically have a database back-end that the IT department and write quick and dirties (Q&Ds), it is really the responsibility of the business user to maintain the data.
Nu Sync was designed from the beginning to replace the Q&Ds and transfer the data maintenance function from IT to the business user. The tools that all business users know are Microsoft Excel and a web browser (Chrome, Firefox, Edge, etc).
To expedite the update process, the Nu Sync Extract Spreadsheet allows the user to download the existing ERP data into the blank spreadsheet. This allows the user to see what is already in the database - or to use as a "mini-datawarehouse."
Nu Sync uses the tools that the business user knows and leverages them to update and maintain the ERP system. Coupling the Web Services/APIs on the back-end and the integration is complete.
The data elements that can be inserted, updated or deleted are:
- Warehouse Products
- Product Cross-references
- Catalog Products
- Sales Orders
- Purchase Orders
The prerequisites for Nu Sync are Web Services Lite and the APIs (for SX users only).