For the best web experience, please use IE11+, Chrome, Firefox, or Safari
Free Trials Request Pricing
Home / Products / erwin Data Connectors

erwin Data Connectors

An expansive library of proven, erwin-built data connectors backed by deep metadata activation experience ensures erwin customers have the tools to quickly use the erwin Data Intelligence Suite by Quest, and at the same time automate the development lifecycle. Included with erwin Data Catalog by Quest, erwin Standard Data Connectors automate metadata harvesting and ingestion from common industry data-at-rest sources. Optional erwin Smart Data Connectors take metadata harvesting and activation to the next level, enabling you to collect metadata from data in motion, as well as leverage automation to reverse-engineer and forward-engineer data pipeline development, documentation and operations. erwin data connectors provide more than you have come to expect. It’s the erwin advantage.
erwin Smart Data Connectors
Request Demo

Nav Menu

erwin Data Connectors

The Added Benefits of erwin Smart Data Connectors

erwin Smart Data Connectors
Out-of-the-box erwin Standard Data Connectors are included with an initial license of erwin Data Catalog to automate metadata collection from common industry data-at-rest sources, including relational, NOSQL and Big Data database management systems (DBMS), as well as XML, JSON and CVS flat file metadata. But many organizations elect to take active metadata use further with the addition of erwin Smart Data Connectors. Providing metadata-driven automation for even the most complex systems and environments, erwin Smart Data Connectors extend data architecture visibility and create engineering efficiencies that shorten project delivery times and reduce risks. The advantages of our erwin Smart Data Connectors include:

Complex metadata harvesting

Automate metadata harvesting and ingestion of data in motion and complex data-at-rest sources through an extensive library of data connectors to industry-standard DBMS, ETL/ELT platforms and BI/reporting applications.

Detailed and thorough data mapping

Better guide decisions, impact analysis and data governance by providing the most complete, current and unified view of your data architecture – inclusive of data sources, flows, transformations and targets.

Universal code generation

Automatically generate SQL, ETL and 4GL procedural code by forward-engineering mapping documents to eliminate time-consuming hand-coding, speed project delivery, and ensure code quality.

Faster data migration & ETL modernization projects

Increase the speed of data migration and ETL modernization projects by forward- and reverse-engineering the associated re-platforming processes.

Data Vault automation

Cut project timelines and efficiently deliver, document and operate data vaults or other traditionally complex data architectures and data warehouse methodologies.

Automation potential on overdrive

Backed by the robust parsing, code generation and metadata activation capabilities of erwin’s proprietary automation framework, erwin Smart Data Connectors can be developed for even the most challenging environment.

Efficient business intelligence

Make data analysts more productive in analyzing BI reports, document dashboards and mappings by linking reporting fields to the underlying data sources.

Harmonized data management & governance

Synchronize and harmonize data management and governance processes with third-party tools at the API level, reducing ongoing maintenance and ensuring sustainability.

The erwin automation difference

Here’s the reality: there’s not enough time, people and money for true metadata management or sustainable data governance using manual processes. Without automation, business and digital transformation will be stymied, but having to outsource these efforts to professional services firms will only delay schedules and increase costs.

With erwin Smart Data Connectors, your organization can reduce errors and accelerate data preparation, deployment, literacy and governance. Only erwin unifies every piece of the data management and governance lifecycle so enterprises can understand and trust their data for faster speed to insights.

What’s really different about erwin’s metadata-driven automation approach ?

Software, not services

Automate data operations with software suited to your needs. Forget expensive, outsourced professional services.

Productivity gains & cost reductions

Achieve productivity gains of 85%+ for coding, 70%+ for metadata discovery, up to 50% for data design, up to 70% for data conversion, and up to 80% for data mapping.

erwin-built & maintained

erwin data connectors are 100% developed and maintained by erwin, backed by deep metadata activation expertise that has guided hundreds of customers to success.

Maps your entire data landscape

Rely on the broadest range of metadata connectors available to fully capture your “as-is” data architecture inclusive of data sources, dataflows, transformations and data targets.

Schedulable & configurable

Keep data lineage and mind map documentation current with advanced scheduling of automated metadata harvesting, with granular version control and full traceability.

Eliminates manual, repetitive coding

Automate and activate metadata-driven processes to develop, document and operate data pipelines more efficiently for faster time to value.

Governs your development lifecycle

Standardize approach, code, documentation and delivery to assure quality and leverage and retain tribal knowledge despite staffing changes.

Overcomes technical complexity

Leverage erwin automation and expertise to successfully tackle sophisticated development projects, such as delivery and operation of a Data Vault.

List of erwin Standard Data Connectors

Data Modeling Connectors

erwin Data Modeler

Idera Embarcadero ER/Studio

OMG.CWM.XML

SAP/Sybase Power Designer

Amazon Redshift

Cloudera

Google Big Query

Greenplum

HortonWorks

HP Vertica

IBM DB2 and DB2 on mainframe

IBM Netezza

JDBC (any software using a JDBC driver)

Kafka Topics

Microsoft Access

Microsoft SQL Server

MongoDB

MySQL

Oracle and Oracle Exadata

Pervasive

Rocket UniVerse DB

SAP Sybase

Service Now CMDB

Snowflake

Teradata

Amazon S3

AVRO

Cobol Copybooks

CSV

Gzip

JSON Schema

Microsoft Azure Data Lake (Gen 1/Gen 2)

ORC

Parquet

Snappy Parquet

XSD/XMI

JD Edwards

Microsoft Dynamics AX

Microsoft Dynamics CRM

Oracle EBS

PeopleSoft

Salesforce

SAP

SAP BW

List of erwin Smart Data Connectors

Data Integration Connectors

Category

Reverse-engineering

Forward-engineering

Alteryx

checkmark
 

Amazon Aurora SQL

checkmark
 

Amazon Kenesis

checkmark
 

Amazon Redshift SQL

checkmark
 

Databricks [Spark SQL]

checkmark
 

DBT

checkmark
 

Denodo

checkmark
 

Google Big Query SQL

checkmark
 

HiveQL

checkmark
checkmark

IBM Data Stage

checkmark
checkmark

Impala

checkmark
 

Informatica ICS

checkmark
 

Informatica PowerCenter

checkmark
checkmark

Matillion

checkmark
checkmark

Microsoft Azure Data Factory

checkmark
checkmark

Microsoft Azure SQL Database

checkmark
 

Microsoft Azure Synapse SQL

checkmark
 

Microsoft SQL Analytics Platform System

checkmark
 

Microsoft SQL Server Integration Services (SSIS)

checkmark
checkmark

Microsoft SQL Server TSQL

checkmark
checkmark

Oracle Data Integrator

checkmark
checkmark

Oracle PL/SQL

checkmark
checkmark

Oracle Warehouse Builder

checkmark
 

Pentaho Data Integrator

checkmark
 

PostgresSQL

checkmark
 

Qlik Replicate

checkmark
 

SAS Data Integrator

checkmark
 

SAP Data Services

checkmark
 

Snaplogic

checkmark
 

Snowflake SQL

checkmark
checkmark

Talend

checkmark
checkmark

Teradata SQL

checkmark
 

WebFocus

checkmark
 

Category

Reverse-engineering

Forward-engineering

Cognos

checkmark
 

Information Builders Web Focus

checkmark
 

Looker

checkmark
 

Microsoft Power BI

checkmark
 

Microsoft SQL Server Analytics Services(SSAS)

checkmark
 

Microsoft SQL Server Reporting Services (SSRS)

checkmark
 

MicroStrategy

checkmark
 

Oracle OBIEE

checkmark

Pyramid Analytics

checkmark
 

QlikView

checkmark
 

QlikSense

checkmark
 

SAP Business Objects

checkmark
 

Tableau

checkmark
 

Category

Reverse-engineering

Forward-engineering

AWS Glue

checkmark
 

Databricks [PySpark]

checkmark
 

R Markdown

checkmark
 

Category

Reverse-engineering

Forward-engineering

Apache Atlas

checkmark
 

AWS Glue Catalog

checkmark
 

Collibra

checkmark
 

Databricks Unity Catalog

checkmark
 

Elastic Search

checkmark
 

GIT Hub

checkmark
checkmark

Google Big Query Catalog

checkmark
 

IBM Information Governance Catalog

checkmark
checkmark

Jira

 
checkmark

Microsoft Azure Data Catalog

checkmark
 

Microsoft Purview

checkmark
 

Mulesoft

checkmark
 

Category

Reverse-engineering

Forward-engineering

Data Vault 2.0

 
checkmark

Get started now

Wouldn’t it be cool if you could automate complex, expensive and time-consuming data management and governance processes? You can thanks to the erwin Data Intelligence Suite and the smart data connectors developed and maintained for your environment.
Request Demo Request Pricing

Resources

View All
Datasheet

erwin Data Intelligence by Quest

Data intelligence to maximize the business impact of data
Datasheet

erwin Data Connectors by Quest

Data intelligence to maximize the business impact of data
Datasheet

erwin Data Catalog by Quest

Automated metadata harvesting, data catalog, code generation and data lineage software
Datasheet

erwin by Quest Data Vault Automation

Automated metadata harvesting, data catalog, code generation and data lineage software
White Paper

Data Vault Automation with erwin and Snowflake

This white paper discusses how to build and automate a scalable data warehouse based on Data Vault 2.0.
Analyst Report

Quadrant Knowledge Solutions 2023 Metadata Management Spark Matrix

erwin by Quest is recognized as a leader by analyst Quadrant Knowledge Solutions in its 2023 Metadata Management Spark Matrix a...
Case Study

Petco harnesses data with erwin Data Intelligence

As Petco seeks to redefine its stores as pet care centers, it has been expanding its offerings. Petco turned to erwin Data Inte...
White Paper

Metadata Management: The Hero in Unleashing Enterprise Data's Value

Connect all the pieces of your data management and data governance lifecycles to reduce risks and realize results

Support and services

Product Support
Get the help you need to install, configure and use erwin products.

Support Offerings
Find the right level of support to accommodate the unique needs of your organization.