System Optimization

Data Migration Data Archiving File Attachment and Audit Log Maintenance

Data Migration

Fast and efficient data transfers between systems

Transistioning from your current system and using Acumatica ERP also means transferring your data to Acumatica ERP too. Planning is needed to fully move your data, transition your users and avoid costly downtime.

At DCC-Digico, we help customers migrate and provide the following services:

  • Database Migration. Transfer data between database platforms, modify schema and data formats from current database to target database.
  • Application Migration. Move application data from one server to another. Mainly for hardware upgrades and high availability setups.
  • Cloud Migration. Moving from on-premise setup to self-hosted cloud setup. Moving from Software-as-a-Service (SaaS) to Private Cloud Subscription (PCS) and vice versa.

Our process involves:

  • Assessment and Profiling. Evaluation of current data for quality, storage size, and business requirements. Properly assess and document the requirements to guide the migration process.
  • Extract, Transform and Load (ETL). We handle extraction of data from source, cleaning and formatting, and storing into the new target system.
  • Testing and Validation. Checking target system after migration process to ensure data integrity and confirm no issues or corruption happened.

Data Archiving

Often overlooked but provides beneficial returns in the long run

Systematic process of moving historical but valuable records from primary database to a secure, accessible long-term storage. Data migration provides optimal system performance, reduce storage costs and comply to data retention policies.

Don't get confused between Data Archiving and Data Backup. The former is for long-term storage of historical data while still being accessible and searchable. While the latter is for disaster recovery and restoration at a certain point in time.

Our services for data archiving covers:

  • Management of Archived Data. Assist in the storage, setup, security and accessibility of archived Acumatica ERP data of organization.
  • Periodic Retrieval Checks. Maintain and check uptime of access links. Secure data integrity and free from errors and data corruption.

    • File Attachment and Audit Log Maintenance

    Monitoring and maintenance of file attachments and audit logs help improve system performance

    Monitoring file servers and tracking audit logs helps in managing resource consumption. File attachment fills up most of the storage capacity in an Acumatica ERP environment. Moving it in an external storage and separated from the primary database can help cut on expenses and can become a central repository of all files in all cloud applications of an organization.

    Audit logs are very important for security and regulatory compliance but leaving it on and unmanaged can quickly eat up database storage capacity. Use maintenance strategies, such as audit log retention and archive log history to have optimal performance in the production environment.

    Our team offers management and maintenance services of your Acumatica ERP file attachments and audit logs to keep your system in optimal performance.