ER/Studio logo
ER/Studio logo
Home > Features > Import & Export Bridges with MetaWizard

Import & Export Bridges

Metadata Mobility Without the Headache

Data doesn’t live in one place, and neither should your metadata. ER/Studio’s MetaWizard bridges give you the flexibility to bring in metadata from virtually any platform, and push it back out as needed. Whether you’re modeling from source systems, ingesting from legacy environments, or exporting to governance and analytics tools, MetaWizard lets you move metadata cleanly, quickly, and without losing meaning.

No hacks. No painful rework. Just seamless interoperability.
Import & Export Bridges (MetaWizard)

What MetaWizard Enables

  • Import metadata from 70+ platforms including Oracle, Snowflake, SAP, Hadoop, MongoDB, Teradata, and more
  • Export models and metadata to BI, ETL, governance, and catalog tools
  • Support file formats like JSON, XML, CSV, and XMI
  • Integrate with big data, cloud storage, and lakehouse environments
  • Standardize imported metadata with ER/Studio’s governance rules and glossaries
  • Map business terms and technical fields across environments

Why It Matters

For Data Architects & Engineers:
  • Quickly reverse engineer from source systems, even without full access
  • Save time by avoiding manual model builds
  • Ensure consistency when importing legacy metadata
For Governance Teams:
  • Bring siloed metadata into your enterprise catalog
  • Standardize definitions and relationships across tools
  • Export clean, governed metadata into platforms like Collibra and Microsoft Purview
For Data Integration & Analytics Teams:
  • Use the same metadata across ETL, BI, and modeling environments
  • Maintain a single source of truth for schemas, definitions, and lineage
  • Avoid rework and mismatch between pipeline stages

Real-World Use Case

A retail enterprise is consolidating multiple legacy data sources into a new Snowflake-based architecture. Using ER/Studio’s MetaWizard bridges, they import metadata from SQL Server, Oracle, and Excel files into a unified modeling environment. From there, they standardize the naming and definitions, then export clean metadata into Collibra for governance tracking, all without rebuilding models from scratch.
use case import and export

How It Works in ER/Studio

  • Access a growing library of MetaWizard connectors inside the ER/Studio interface
  • Choose your source or target platform (database, file, cloud system, or tool)
  • ER/Studio handles the transformation and mapping
  • Apply naming conventions, glossary terms, and governance rules post-import
  • Export to external systems with full structure, lineage, and metadata attached
These bridges make ER/Studio the connective tissue in your data ecosystem.

Supported Categories Include:

  • Relational Databases (Oracle, SQL Server, DB2, PostgreSQL, MySQL…)
  • Cloud Platforms (Snowflake, Redshift, BigQuery…)
  • Big Data / NoSQL (Hadoop, Hive, MongoDB, Cassandra…)
  • ETL Tools (Informatica, Talend, SSIS…)
  • BI Tools (Power BI, Tableau, Qlik…)
  • Governance Platforms (Collibra, Purview)
  • Modeling Standards (UML, XMI, XML)
  • Files (CSV, Excel, JSON)

Frequently asked questions

MetaWizard supports metadata ingestion from more than 70 platforms, including relational databases, cloud warehouses, NoSQL systems, ETL tools, BI platforms, modeling standards, and file formats such as JSON, XML, CSV, and XMI. This allows teams to bring legacy structures, source systems, and distributed assets into a unified modeling environment.

Teams can export models and metadata directly into BI, ETL, governance, catalog, and analytics platforms. The exported metadata retains its structure, definitions, classifications, and relationships, ensuring downstream systems receive clean, governed, and standardized information without manual reconstruction.

The bridges integrate with databases, data lakes, lakehouses, and cloud storage systems such as Snowflake, BigQuery, Redshift, Hadoop, Hive, MongoDB, and more. This enables organizations to move metadata freely between on-prem and cloud platforms while maintaining consistency across environments.

After metadata is imported, ER/Studio applies naming conventions, glossary links, and governance rules to standardize structures and definitions across systems. This reduces inconsistencies from legacy environments, aligns technical fields with business terms, and provides cleaner metadata for platforms like Collibra and Microsoft Purview.

Instead of rebuilding models by hand, MetaWizard automates the capture and transformation of source metadata. This shortens onboarding time for new systems, eliminates copy-and-rebuild tasks, reduces human error, and ensures that imported structures reflect the actual production environment.

Get Started

Connect Everything Without Losing Control

With ER/Studio’s MetaWizard import/export bridges, your metadata moves faster and stays cleaner—making true enterprise-wide integration possible.
Copyright © 2026 Idera, Inc.
Hi! Need help finding something?
ER/Studio
Here to help you find your way