For the best web experience, please use IE11+, Chrome, Firefox, or Safari

erwin Data Connectors

Quest offers a robust library of proven, ready-to-use connectors, enabling fast, automated use of erwin Data Intelligence by Quest. Included with the software, Standard Data Connectors automate metadata harvesting from common data sources into erwin Data Intelligence for use in your data catalog. For advanced needs, optional Smart Data Connectors capture metadata from data in motion for use in data lineage and automate data pipeline development, documentation and operations. Experience more than standard connectivity.
erwin Smart Data Connectors
erwin Data Connectors

The Added Benefits of erwin Smart Data Connectors

erwin Smart Data Connectors
erwin Standard Data Connectors, included with every erwin Data Intelligence license, automate metadata collection from common data-at-rest sources like relational, NoSQL, and Big Data database management systems, as well as XML, JSON, and CSV files. But many customers take active metadata use further with the metadata-driven automation of erwin Smart Data Connectors for complex environments, expanding data landscape visibility and streamlining project delivery. Key advantages of 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

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 Dataverse

Microsoft Fabric

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

Category

Reverse-engineering

Forward-engineering

Alteryx

checkmark
 

Amazon Redshift SQL

checkmark
 

Azure Synapse

checkmark
 

Databricks [Spark SQL]

checkmark
 

DBT

checkmark
 

Denodo

checkmark
 

Fivetran

checkmark
 

Google Big Query SQL

checkmark
 

HiveQL

checkmark
checkmark

IBM Data Stage

checkmark
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

MySQL

checkmark
 

Oracle Data Integrator

checkmark
checkmark

Oracle PL/SQL

checkmark
checkmark

Oracle Warehouse Builder

checkmark
 

PostgresSQL

checkmark
 

Qlik Replicate

checkmark
 

SAS Data Integrator

checkmark
 

SAP Data Services

checkmark
 

Snowflake SQL

checkmark
checkmark

Talend

checkmark
checkmark

Teradata SQL

checkmark
 

WebFocus

checkmark
 

Category

Reverse-engineering

Forward-engineering

Azure Analysis Services

checkmark
 

Cognos

checkmark
 

Information Builders Web Focus

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

Apache Atlas

checkmark
 

AWS Glue Catalog

checkmark
 

Collibra

checkmark
 

Databricks Unity Catalog

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
Quest continues to bring new connectors to life. Please ask us if you don’t see a connector in the list above that is needed to meet your specific data landscape needs.

Get started now

Automate complex, expensive and time-consuming data management and governance processes.