Cookies on this site

We would like to use cookies to understand how the site is used and to measure our campaigns. Nothing is set until you choose, and you can change your mind at any time from “Cookie settings” at the foot of every page. Privacy policy

Contact UsContact Us

Resources / Blogs

Security & compliance

Ataccama ONE Import Export: Data Quality Rule Migration Guide

Manage data quality rule migration in Ataccama ONE with a structured import and export framework. Ensure consistent data governance across environments.

· · 2 min read

Moving Data Quality Rules Across Environments in Ataccama ONE

Every mature data governance framework operates across multiple environments. Teams build and refine data quality rules in sandbox environments, validate them in testing, and then promote them to production. However, this transition is often one of the most error-prone steps in any data governance workflow.

Ataccama ONE addresses this challenge through a structured import and export framework, making it easier to manage data quality rule lifecycle management across environments. This approach creates a repeatable and controlled process for moving metadata, rules, and glossary terms without introducing risk.

How Export Plans Work in Ataccama ONE

Export plans are JSON-based configurations that define what metadata gets transferred between environments. They help teams standardize metadata management and ensure only the required assets are included in the migration.

Out-of-the-box export plans in Ataccama ONE cover:

  • Business glossary terms
  • Data quality rules
  • Reference data
  • Data lineage repositories

Teams can also create custom export plans to support specific data governance best practices and align with their internal promotion workflows.

Step-by-Step: Export and Import Data Quality Rules

Export from Source Environment

  1. Navigate to Global Settings → Application Settings → Import and Export
  2. Create a new export and select the appropriate export plan
  3. Choose encryption settings (use AES-256 encryption for secure transfers across environments)
  4. Run the export and download the ZIP file from the Notification Center
image (38)image (26)image (39)

Import into Target Environment

  1. Open Import and Export in the target instance
  2. Upload the exported ZIP archive
  3. Enter the password if encryption was applied
  4. Run validation before deployment to identify conflicts or missing dependencies
  5. Choose import mode:
  6. Draft (recommended for production validation)
  7. Published (for direct deployment)

This validation-first approach supports reliable data quality rule validation and prevents errors during production rollout.

image (40)image (41)

Key Considerations for Rule Migration

Validate Before Promotion

Asset IDs, such as DQ dimension IDs, may differ across environments. Always validate to avoid broken references and ensure smooth data governance environment migration.

Avoid Migrating Environment-Specific Data

Data source connections and profiling results should remain within their original environments. Focus on migrating only data quality management configurations and metadata.

Use Monitoring Lifecycle Instead of Direct Migration

Monitoring projects should follow a structured lifecycle rather than direct export/import. This ensures proper mapping between development and production datasets within your enterprise data governance setup.

Why This Matters for Data Governance

A structured approach to migrating data quality rules is essential for maintaining consistency and trust in your data. Without it, organizations risk introducing inconsistencies, broken dependencies, and governance gaps.

With Ataccama ONE, teams can:

  • Standardize data governance workflows
  • Improve data quality automation
  • Reduce deployment errors
  • Ensure consistent rule enforcement across environments

Final Thoughts

Moving rules between environments doesn’t have to be a risky process. With a well-defined import and export process in Ataccama ONE, organizations can turn environment promotion into a predictable and controlled step in their data governance strategy.

By combining structured export plans, strong validation practices, and clear governance policies, teams can confidently manage data quality rules across environments—without compromising accuracy or control.

← All articles

Case studies

Microsoft Consulting in practice

Client names are withheld. We are happy to share details on a call.

All case studies
  • Delivered

    600k files, < 3 days

    Document management

    Microsoft

    600,000 documents moved from ImageRight to SharePoint in under three days

    A one-file-at-a-time script would have needed about 22 days of continuous running. We rebuilt the migration around a SQL work queue with parallel uploads, automatic retries and crash recovery, and it finished unattended in under three days.

    • 1,125 → 8,314 files per hour
    • Under 3 days instead of about 22
  • Product

    Every prompt screened

    Any industry on Microsoft 365

    Microsoft

    AI activity and data posture for Microsoft 365

    Sentinel watches Copilot and Copilot Studio agents in a Microsoft 365 tenant. It logs prompts and tool calls, scores each agent's risk, flags oversharing and stale access, and screens prompts for injection attempts with a classifier that runs locally at no per-call cost.

    • Every agent prompt screened
    • Runs inside the customer's own Azure tenant
  • In production

    Hours → minutes

    Food manufacturing

    AI Consulting

    Document intake agent for a national food cooperative

    A Copilot Studio agent reads certificates of analysis as they arrive in the quality team's inbox, extracts 14 fields with AI Builder, checks them, files the PDF in SharePoint and posts a summary in Teams. Fields it is unsure about go to a person instead of being guessed.

    • Hours of daily filing down to minutes
    • 14 fields per document, validated

Keep reading

All Security & compliance articles

See what Copilot and your users can reach

A 30-minute demo of Princeton Sentinel on sample data: AI activity and data posture across Microsoft 365, with the engineers who build it.