Erwin Data Modeler incorpora Data Bridges

La herramienta líder del mercado en modelado de datos, erwin Data Modeler, ha impulsado en las últimas versiones la capacidad de intercambio de metadatos con otras aplicaciones.

Erwin siempre ha facilitado la conectividad con una gran variedad de bases de datos, y ha permitido la importación de formatos de modelos de datos de muy diferentes aplicaciones de modelado, dando a los usuarios la mayor flexibilidad de trabajo. Este, que ha sido uno de sus puntos fuertes, además se unía a la posibilidad de exportación de los modelos de erwin a un formato abierto y estándar como es XML.

Además, en la versión actual de erwin, la 2021, incluso en la edición Standard, encontramos la capacidad de conexión a una enorme variedad de entornos de gestión de datos, con un modelo de intercambio basado en ficheros, que nos permite extraes los modelos inherentes a servicios de todo tipo, incluyendo Amazon AWS, Tableau, Salesforce, QlikView, Apache Hadoop, o erwin Data Intelligence, además de una larga lista que incluye otros servicios en la nube, los más importantes motores de bases de datos, y las herramientas de modelado más populares.

Erwin Data Modeler, tras su adquisición por parte de Quest, afianza así su posición de liderazgo, alcanzada por la amplitud de sus funcionalidades de nivel profesional.

Lista de Data Bridges disponibles:

AplicaciónModo
Actian Vector (Vectorwise) Database (via JDBC)Import
Altova XMLSpyImport
Alteryx – Beta Bridge
Alteryx Repository – Beta Bridge
Import
Amazon Web Services (AWS) S3 Storage
Amazon Web Services (AWS) Glue ETL – Beta Bridge
Import
Apache Avro File (JSON)
Apache Cassandra NoSQL Database
Apache CouchDb Database (JSON)
Apache Hadoop Hive Native bridges include:
Apache Hadoop Hive Database (Hive Metastore via JDBC)
Apache Hadoop Hive Database (HCatalog via JDBC)
Apache Hadoop HiveQL DDL
Apache Hadoop Web HCatalog
Apache Hbase
Apache Hadoop HBase NoSQL Database (Java API) – New Beta Bridge
Apache Kafka – New Beta Bridge
Cloudera Enterprise Hadoop Hive Database (HCatalog via JDBC)
Cloudera Enterprise Hadoop HiveQL DDL
Cloudera Impala Hadoop Hive Server
Cloudera Impala Hadoop HiveQL DDL
Cloudera Navigator – New Beta Bridge
DataStax Enterprise (Cassandra)
Hadapt Hadoop Hive Server
Hortonworks Hadoop Hive Database (HCatalog via JDBC)
Hortonworks Hadoop HiveQL DDL
MapR Hadoop Hive Database (HCatalog via JDBC)
Import
Apache Parquet FileImport
Amazon Web Services (AWS) RedShift Database (via JDBC)Import
Borland Together (via UML 1.x XMI)Import
Borland Together (via UML 2.x XMI)Import/Export
CA Component Modeler 3.52 (ParadigmPlus)Import/Export
CA Component Modeler 4.x (via UML 1.x XMI)Import/Export
CA COOL:Biz 5.1Import
CA COOL:BusinessTeam (GroundWorks) 2.2.1Import
CA COOL:DBA (Terrain for DB2) 5.3.2Import
CA COOL:Enterprise (ADW) 2.7Import
CA COOL:Xtras Mapper (TerrainMap for DB2)Import
CA GenImport/Export
COBOL Copybook FileImport
Database (via JDBC)Import
Database SQL Data Definition Language (DDL)Import
erwin 3.x (ERX)Import
erwin 4.x Data ModelerImport
erwin Data Profiler – Beta bridgeImport
erwin Web PortalExport
Embarcadero Describe (via UML 1.x XMI)Import/Export
Embarcadero ER/Studio Business Architect (via DM1)Import/Export
Embarcadero ER/Studio Data ArchitectImport/Export
Embarcadero ER/Studio RepositoryImport
EMC ProActivity 3.x & 4.0Import
Excel File (XLSX)Import
Flat File (CSV) – New Beta BridgeImport
Flat File (CSV)Import
File System (CSV, Excel, XML, JSON, Avro, Parquet)Import
Gentleware Poseidon (via UML 1.x XMI)Import/Export
Grandite Silverrun-RDM 2.4.4 to 2.8.6Import
Google BigQuery DatabaseImport
HP Vertica Database (via JDBC)Import
IBM Cognos Framework Manager (FM)Import/Export
IBM Cognos Framework Manager (FM) for ReportNetImport/Export
IBM Cognos BI Reporting – Framework ManagerExport
IBM Cognos Content Manager PackagesImport
IBM DB2 Cube ViewsImport/Export
IBM DB2 Data Database (via JDBC)Import
IBM InfoSphere Data Architect (IDA)Import/Export
IBM InfoSphere DataStageImport/Export
IBM InfoSphere Federation Server (via JDBC)Import
IBM InfoSphere Discovery – Beta bridgeImport
IBM InfoSphere Metadata Workbench Extension Mappings – BetaExport
IBM InfoSphere Warehouse – InfoSphere Data ArchitectImport/Export
IBM Netezza Database (via JDBC)Import
IBM Rational Rose 4.0Import/Export
IBM Rational Rose 6.0(98i) to 6.5(2000)Import/Export
IBM Rational Rose 7.x (2000e and newer)Import/Export
IBM Rational Rose XDE Developer (via Rose MDL)Export
IBM Rational Software Architect (RSA) (via Rose MDL)Export
IBM Rational Software Architect (RSA) (via UML 2.x XMI)Import/Export
IBM Rational Software Modeler (RSM) (via Rose MDL)Export
IBM Rational System Architect (SA) 10.4 to 11.x (Encyclopedia)Import/Export
IBM Rational System Architect (SA) 7.1 to 11.x (File)Import/Export
IBM Telelogic Tau (via UML 1.x XMI)Import/Export
Informatica Data AnalyzerExport
Informatica DeveloperImport/Export
Informatica PowerCenterExport
Informatica PowerCenter (File)Import
Informatica PowerCenter (Repository)Import
IRI CoSORT RowGen Data Definition FileExport
IRI CoSORT SortCL Data Definition FileExport
JSON FileImport
MarkLogic NoSQL Database (for JSON only)Import
Micro Focus (Merant) AppMaster BuilderImport
Microsoft Azure SQL Database (via JDBC)
Microsoft Azure Blob Storage
Import
Microsoft Office ExcelImport/Export
Microsoft Office Visio Database Diagram (via ERX)Import
Microsoft Office Visio UML (via UML 1.x XMI)Import
Microsoft SQL Server Analysis Services (SSAS) 2016 (File)Import
Microsoft SQL Server Analysis Services (SSAS) (Repository)Export
Microsoft SQL Server Analysis Services (SSAS) (via DSV File)Import/Export
Microsoft SQL Server Data Source View (DSV)Import/Export
Microsoft SQL Server Integration Services (File)Import/Export
Microsoft SQL Server Integration Services (SSIS) (via DSV File)Import/Export
Microsoft SQL Server XML Data Reduced (XDR) SchemaImport
Microsoft SQL Server Analysis Services (SSAS) 2005 to 2016 (Repository)Import
Microsoft SQL Server Analysis Services (SSAS) 2005 to 2016 (File)Import
Microsoft SQL Server Database (via JDBC)Import
Microsoft SQL Server Database SQL DDLImport
Microsoft SQL Server Integration Services (Repository)Import
Microsoft Visual Studio / Modeler 2.0 (via MDL)Import/Export
MicroStrategy 7.0 to 10.xImport
MicroStrategy MDX Adapter (via ODBO) – Unsupported EOL BridgeImport
MongoDB NoSQL Database (JSON)Import
NoMagic MagicDraw (via UML 2.x XMI)Import/Export
OMG CWM 1.x XMI 1.xImport/Export
OMG CWM Pre-1.0 XMI 1.1 – Unsupported EOL BridgeImport/Export
OMG UML 1.x XMI 1.xImport/Export
OMG UML 2.x XMI 2.xImport
OpenAPI Specification (OAS)Import
OpenStack Swift Object Store – New Beta BridgeImport
Oracle Business Intelligence (OBI) Repository (RPD file)Import
Oracle Cloud Object Storage Classic – New Beta BridgeImport
Oracle Database (via JDBC)Import
Oracle Database SQL DDLImport
Oracle Data Integrator (ODI)Import/Export
Oracle Data Warehouse Administrative Console (DAC)Import
Oracle DesignerImport/Export
Oracle Hyperion Essbase Integration Services (EIS)Import/Export
Oracle MySQL Database (via JDBC)Import
Oracle Warehouse Builder (OWB)Import/Export
Pivotal Greenplum Database (via JDBC)Import
PostgreSQL Database (via JDBC)Import
QlikSense FileImport
QlikView FileImport
SAS OLAP Server (via ODBO) – Unsupported EOL BridgeImport
SAS LibraryImport
SAS Data IntegrationImport
SAS Base SAS CodeImport
SAP BusinessObjects Data Integrator (BODI)Import/Export
SAP BusinessObjects Designer (File)Import/Export
SAP BusinessObjects Designer (Repository)Import
SAP BusinessObjects Information Design Tool (IDT) (Repository)Import
SAP BusinessObjects Information Design Tool (IDT) (File)Import/Export
SAP HANA Database (via JDBC)Import
SAP NetWeaver Master Data Management (MDM) – Beta bridgeImport/Export
SAP NetWeaver Business Warehouse (BW) (via ODBO) – Unsupported EOL BridgeImport
Salesforce (SFDC)Import
Select SEImport
Sparx Enterprise Architect (EA) (via UML 1.x XMI)Import/Export
Sparx Enterprise Architect (EA) (via UML 2.x XMI)Import
SAP ASE Database (via JDBC)Import
SAP Data Services (BODI/BODS)Import
SAP PowerDesigner CDM 6.xImport
SAP PowerDesigner CDM 7.5 to 16.xImport
SAP PowerDesigner CDM 8.0 to 16.xExport
SAP PowerDesigner OOM 9.x to 15.x (via UML 2.x XMI)Import/Export
SAP PowerDesigner PDM 6.1.xImport
SAP PowerDesigner PDM 7.5 to 16.xImport
SAP PowerDesigner PDM 8.x to 16.xExport
SAP PowerDesigner LDM 15.x to 16.xImport
SAP PowerDesigner XSM 10.x to 15.xExport
Syncsort DMExpressImport/Export
Tableau (File)Import
Tableau Server (Repository)Import
Talend Data IntegrationImport/Export
Talend Data Preparation – New Beta BridgeImport
Teradata Database (via JDBC)Import
Teradata Database SQL DDLImport
ThoughtSpot – Beta BridgeImport
TIBCO Spotfire Analyst (File)Import
TIBCO Spotfire Server (Repository)Import
TIBCO Spotfire Stdf (File) – New Beta BridgeImport
Tigris ArgoUML (via UML 1.x XMI)Import/Export
Visible IE:Advantage 6.1Import
Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia)Import/Export
Unicom (Popkin) System Architect (SA) 7.1 to 11.4 (File)Import/Export
W3C XML DTD 1.0Import
W3C Ontology (OWL/RDF) – New Beta BridgeImport
W3C Semantic Web Ontology (OWL/RDF) – New Beta BridgeImport
W3C XMLImport
W3C XML Schema 1.0 (XSD)Import/Export

Más Información

Ayúdanos con este formulario a facilitarte la información que necesitas.