ER/Studio MetaWizard Import/Export Bridges

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Main Page

  • Metadata Import Bridges and Metadata Export Bridges list applications supported for model data import and export (MetaWizard bridges). Many applications use a directory or ODBC data source rather than a single file such as a *.xml or *.dm1 file for metadata exchange. Please refer to the description within the wizard for your particular platform.
  • Data Lineage Bridges includes the Data Lineage import bridges, which are available as a separate package from the MetaWizard Import and Export bridges. These bridges pull the metadata and data transformations from the BI and ETL data sources into an ER/Studio data lineage diagram.

These bridge packages are add-on options for ER/Studio Data Architect and Data Architect Professional; a subset of common modeling tool import bridges is included in these products. The ER/Studio Enterprise Team Edition includes all of the MetaWizard Model Import and Export bridges as well as the Data Lineage Import Bridges.

Metadata Import Bridges Metadata Export Bridges Data Lineage Bridges
Actian Vector (Vectorwise) Database (via JDBC) Altova XMLSpy IBM Cognos Framework Manager (FM)
Alteryx Unsupported Beta Bridge Borland Together (via UML 2.x XMI) IBM InfoSphere DataStage
Alteryx Repository Unsupported Beta Bridge CA Component Modeler 3.52 (ParadigmPlus) Informatica Big Data Management (BDM) Developer
Amazon Web Services (AWS) Athena Database (via JDBC) CA Component Modeler 4.x (via UML 1.x XMI) Informatica Data Engineering Integration (DEI) Developer
Amazon Web Services (AWS) Athena Database (via JDBC) New Beta Bridge CA Gen Microsoft SQL Server Analysis Services (SSAS) (Repository)
Amazon Web Services (AWS) Aurora / MySQL Database (via JDBC) Gentleware Poseidon (via UML 1.x XMI) Microsoft SQL Server Analysis Services (SSAS) (via DSV File)
Amazon Web Services (AWS) Aurora / PostgreSQL Database (via JDBC) IBM Cognos Framework Manager (FM) Microsoft SQL Server Data Source View (DSV)
Amazon Web Services (AWS) Glue ETL (via Apache Spark) IBM Cognos Framework Manager (FM) for ReportNet Microsoft SQL Server Integration Services (SSIS) (via DSV File)
Amazon Web Services (AWS) RedShift Database (via JDBC) IBM DB2 Cube Views Oracle Hyperion Essbase Integration Services (EIS)
Amazon Web Services (AWS) S3 Storage IBM InfoSphere Data Architect (IDA) Oracle Warehouse Builder (OWB)
Apache Avro File (JSON) IBM InfoSphere DataStage SAP BusinessObjects Designer (File)
Apache Cassandra NoSQL Database IBM InfoSphere Warehouse - InfoSphere Data Architect SAP BusinessObjects Information Design Tool (IDT) (File)
Apache CouchDb Database (JSON) IBM Rational Rose 4.0 Talend Data Integration
Apache Hadoop HBase NoSQL Database (Java API) IBM Rational Rose 6.0 (98i) to 6.5 (2000) IBM Cognos Content Manager Packages
Apache Hadoop Hive Database (HCatalog and Metastore via JDBC) IBM Rational Rose 7.x (2000e and newer) Informatica PowerCenter (File)
Apache Hadoop Hive Database SQL DDL Script IBM Rational Rose XDE Developer (via Rose MDL) Informatica PowerCenter (Repository)
Apache Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL) IBM Rational Software Architect (RSA) (via Rose MDL) Microsoft SQL Server Analysis Services (SSAS) 2005 to 2017 (Repository)
Apache Kafka IBM Rational Software Architect (RSA) (via UML 2.x XMI) Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository)
Apache ORC File IBM Rational Software Modeler (RSM) (via Rose MDL) Microsoft SQL Server Integration Services (SSIS) (File)
Apache Parquet File IBM Telelogic Tau (via UML 1.x XMI) Microsoft SQL Server Integration Services (SSIS) (Repository Database)
Apache Spark (with Python or Scala) IDERA ER/Studio Business Architect (via DM1) Microsoft SQL Server Integration Services (SSIS) (Repository Server)
Borland Together (via UML 2.x XMI) IDERA ER/Studio Data Architect Oracle Business Intelligence (OBI) Repository (RPD file)
CA COOL:Biz 5.1 IRI CoSORT RowGen Data Definition File Oracle Data Integrator (ODI)
CA COOL:BusinessTeam (GroundWorks) 2.2.1 IRI CoSORT SortCL Data Definition File SAP BusinessObjects Designer (Repository)
CA COOL:DBA (Terrain for DB2) 5.3.2 Informatica Big Data Management (BDM) Developer SAP BusinessObjects Information Design Tool (IDT) (Repository)
CA COOL:Enterprise (ADW) 2.7 Informatica Data Engineering Integration (DEI) Developer SAP Data Services (BODI/BODS)
CA COOL:Xtras Mapper (TerrainMap for DB2) Informatica PowerCenter Talend Data Preparation
CA Component Modeler 3.52 (ParadigmPlus) Metadata Excel Format
CA Component Modeler 4.x (via UML 1.x XMI) MicroStrategy 7.0 to 11.x / 2021
CA Gen Microsoft SQL Server Analysis Services (SSAS) (Repository)
COBOL Copybook File Microsoft SQL Server Analysis Services (SSAS) (via DSV File)
Cloudera Enterprise Hadoop Hive Database (HCatalog and Metastore via JDBC) Microsoft SQL Server Data Source View (DSV)
Cloudera Enterprise Hadoop Hive Database SQL DDL Script Microsoft SQL Server Integration Services (SSIS) (via DSV File)
Cloudera Enterprise Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL) Microsoft Visual Studio / Modeler 2.0 (via MDL)
Cloudera Impala Hadoop Hive Database (HCatalog and Metastore via JDBC) NoMagic MagicDraw (via UML 2.x XMI)
Cloudera Impala Hadoop Hive Database SQL DDL Script OMG CWM 1.x XMI 1.x
Cloudera Impala Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL) OMG CWM Pre-1.0 XMI 1.1 Unsupported EOL Bridge
Cloudera Impala Hadoop Hive Server OMG UML 1.x XMI 1.x
Confluent Kafka Schema Registry New Beta Bridge OMG UML 2.x XMI 2.x
DataStax Enterprise (Cassandra) Oracle Data Modeler (ODM) 4.x (via erwin 4 XML)
Database (via JDBC) Oracle Designer
Database SQL DDL Script Oracle Hyperion Essbase Integration Services (EIS)
Database SQL DML (DI/ETL) Script Oracle Warehouse Builder (OWB)
Databricks Delta Lake Hadoop Hive Database (HCatalog and Metastore via JDBC) SAP BusinessObjects Designer (File)
Databricks Delta Lake Hadoop Hive Database SQL DDL Script SAP BusinessObjects Information Design Tool (IDT) (File)
Databricks Delta Lake Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL) SAP PowerDesigner CDM 8.0 to 16.x
Databricks Unified Data Services (via Apache Spark) SAP PowerDesigner OOM 9.x to 15.x (via UML 2.x XMI)
Delimited File (CSV) SAP PowerDesigner PDM 8.x to 16.x
Denodo Virtual DataPort SAP PowerDesigner XSM 10.x to 15.x
EMC ProActivity 3.x & 4.0 Sparx Enterprise Architect (EA) (via UML 2.x XMI)
Excel File (XLSX) Tableau (File)
File System (Delimited, Fixed Width, Excel, XML, JSON, Avro, Parquet, ORC, COBOL Copybook) Talend Data Integration
Fixed Width File Talend Master Data Management (MDM)
Gentleware Poseidon (via UML 1.x XMI) Tigris ArgoUML (via UML 1.x XMI)
Google BigQuery Database Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia)
Google Cloud Storage Unicom (Popkin) System Architect (SA) 7.1 to 11.4 (File)
Grandite Silverrun-RDM 2.4.4 to 2.8.6 W3C XML Schema Definition (XSD) 1.0 Forward Engineering
HP Vertica Database (via JDBC) erwin 4.x Data Modeler
Hortonworks Hadoop Hive Database (HCatalog and Metastore via JDBC) erwin 7.x Data Modeler
Hortonworks Hadoop Hive Database SQL DDL Script erwin 8.x Data Modeler
Hortonworks Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL) erwin 9.x to 2021 Data Modeler
IBM Cognos Content Manager Packages
IBM Cognos Framework Manager (FM)
IBM Cognos Framework Manager (FM) for ReportNet
IBM DB2 Cube Views
IBM DB2 Universal Database (UDB) (via JDBC)
IBM DB2 Universal Database (UDB) SQL DML (DI/ETL) Script
IBM DB2 for z/OS (mainframe) Database (via JDBC)
IBM DB2 iSeries (AS/400) Database (via JDBC)
IBM InfoSphere Data Architect (IDA)
IBM InfoSphere DataStage
IBM InfoSphere Federation Server (via JDBC)
IBM InfoSphere Warehouse - InfoSphere Data Architect
IBM Informix Database (via JDBC)
IBM Lotus Notes (via JDBC-ODBC)
IBM Netezza Database (via JDBC)
IBM Rational Rose 4.0
IBM Rational Rose 6.0 (98i) to 6.5 (2000)
IBM Rational Rose 7.x (2000e and newer)
IBM Rational Software Architect (RSA) (via UML 2.x XMI)
IBM Telelogic Tau (via UML 1.x XMI)
IDERA ER/Studio Data Architect
Informatica Big Data Management (BDM) Developer
Informatica Data Engineering Integration (DEI) Developer
Informatica PowerCenter (File)
Informatica PowerCenter (Repository)
JSON File
MapR Hadoop Hive Database (HCatalog and Metastore via JDBC)
MapR Hadoop Hive Database SQL DDL Script
MapR Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL)
MarkLogic NoSQL Database (for JSON only)
Metadata Excel Format
Micro Focus (Merant) AppMaster Builder
MicroStrategy 7.0 to 11.x / 2021
MicroStrategy MDX Adapter (via ODBO) Unsupported EOL Bridge
Microsoft Azure Analysis Services (SSAS)
Microsoft Azure Blob Storage
Microsoft Azure Data Factory New Beta Bridge
Microsoft Azure Data Lake Storage Gen1
Microsoft Azure Data Lake Storage Gen2
Microsoft Azure SQL Database (via JDBC)
Microsoft Azure Synapse Analytics (SQL Data Warehouse) (via JDBC)
Microsoft Office Visio Database Diagram (via ERX)
Microsoft Office Visio UML Class Diagram (via UML 1.x XMI)
Microsoft SQL Server Analysis Services (SSAS) (via DSV File)
Microsoft SQL Server Analysis Services (SSAS) 2005 to 2017 (Repository)
Microsoft SQL Server Analysis Services (SSAS) 2005 to 2019 (XMLA File)
Microsoft SQL Server Analysis Services (SSAS) 2016 to 2019 (Tabular Model File)
Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository)
Microsoft SQL Server Data Source View (DSV)
Microsoft SQL Server Database (via JDBC)
Microsoft SQL Server Database SQL DDL Script
Microsoft SQL Server Database SQL DML (DI/ETL) Script (Transact-SQL)
Microsoft SQL Server Integration Services (SSIS) (File)
Microsoft SQL Server Integration Services (SSIS) (Repository Database)
Microsoft SQL Server Integration Services (SSIS) (Repository Server)
Microsoft SQL Server Integration Services (SSIS) (via DSV File)
Microsoft SQL Server XML Data Reduced (XDR) Schema
Microsoft Visual Studio / Modeler 2.0 (via MDL)
MongoDB NoSQL Database (JSON)
NoMagic MagicDraw (via UML 2.x XMI)
OMG CWM 1.x XMI 1.x
OMG CWM Pre-1.0 XMI 1.1 Unsupported EOL Bridge
OMG UML 1.x XMI 1.x
OMG UML 2.x XMI 2.x
OpenAPI Specification (OAS)
OpenStack Swift Object Store New Beta Bridge
Oracle Business Intelligence (OBI) Repository (RPD file)
Oracle Data Integrator (ODI)
Oracle Data Modeler (ODM) 4.x
Oracle Database (via JDBC)
Oracle Database SQL DDL Script
Oracle Database SQL DML (DI/ETL) Script (PL/SQL)
Oracle Designer
Oracle Hyperion Essbase Integration Services (EIS)
Oracle MySQL Database (via JDBC)
Oracle Warehouse Builder (OWB)
Pivotal Greenplum Database (via JDBC)
PostgreSQL Database (via JDBC)
PostgreSQL Database SQL DML (DI/ETL) Script
QlikSense File
QlikView File
SAP BusinessObjects Crystal Reports XI (File)
SAP BusinessObjects Crystal Reports XI (Repository)
SAP BusinessObjects Designer (File)
SAP BusinessObjects Designer (Repository)
SAP BusinessObjects Information Design Tool (IDT) (File)
SAP BusinessObjects Information Design Tool (IDT) (Repository)
SAP Data Services (BODI/BODS)
SAP HANA Database (via JDBC)
SAP PowerDesigner CDM 6.x
SAP PowerDesigner CDM 7.5 to 16.x
SAP PowerDesigner LDM 15.x to 16.x
SAP PowerDesigner OOM 9.x to 15.x (via UML 2.x XMI)
SAP PowerDesigner PDM 6.1.x
SAP PowerDesigner PDM 7.5 to 16.x
SAP Sybase ASE Database (via JDBC)
SAS Base SAS Code
SAS Data Integration
SAS Library
SAS OLAP Server (via ODBO) Unsupported EOL Bridge
Salesforce (SFDC) Database
Select SE
Snowflake Database (via JDBC)
Snowflake Database SQL DML (DI/ETL) Script (SnowSQL)
Sparx Enterprise Architect (EA) (via UML 2.x XMI)
TIBCO Spotfire Analyst (DXP Format) (File)
TIBCO Spotfire Binary Data (SBDF Format) (File)
TIBCO Spotfire Server (Repository)
TIBCO Spotfire Text Data (STDF Format) (File)
Tableau (File)
Tableau Server (Repository)
Talend Data Integration
Talend Data Preparation
Talend Master Data Management (MDM)
Teradata Database (via JDBC)
Teradata Database SQL DDL Script
Teradata Database SQL DML (DI/ETL) Script (BTEQ, Fastload, etc.)
ThoughtSpot
Tigris ArgoUML (via UML 1.x XMI)
Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia)
Unicom (Popkin) System Architect (SA) 7.1 to 11.4 (File)
Visible IE:Advantage 6.1
W3C Semantic Web Ontology (OWL/RDF)
W3C Web Service Definition Language (WSDL) Beta Bridge
W3C XML
W3C XML Document Type Definition (DTD) 1.0
W3C XML Schema Definition (XSD) 1.0
W3C XML Schema Definition (XSD) 1.0 Reverse Engineering
erwin 3.x (ERX)
erwin 4.x Data Modeler
erwin 7.x Data Modeler (File)
erwin 7.x Data Modeler (Single Model from Model Manager)
erwin 8.x Data Modeler (File)
erwin 8.x Data Modeler (Single Model from mart)
erwin 9.x to 2021 Data Modeler (File)
erwin 9.x to 2021 Data Modeler (Single Model from mart)

See Also