top of page

erwin Smart Data Connectors

Accelerate project delivery and sustain data governance with metadata-driven automation for data integration, transformation and regulatory compliance

What are erwin Smart Data Connectors

erwin Smart Data Connectors are optional, customized software solutions that automatically scan, integrate and activate metadata within erwin Data Catalog (erwin DC), part of the erwin Data Intelligence Suite. Engineered and maintained by erwin – not third parties – they connect a wide array of data sources, including ELT/ETL platforms, business intelligence reports, database procedural code, testing automation tools, ecosystem utilities and ERP environments, to our data catalog. erwin Smart Data Connectors are developed for seamless integration into your specific data architecture and supporting IT infrastructure to automate complex, costly and time-consuming processes normally associated with metadata managementdata governance and data intelligence.

Screenshot 2020-09-02 at 12.34.34.png

What's really different about erwin's Approach to Metadata-Driven Automation?

code (1).png

Software, Not Services

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


erwin-Engineered & Maintained

Rest assured that this technology is not licensed from third parties; our smart data connectors are 100-percent developed and maintained by erwin.


Widest Connectivity

Depict metadata for both data at rest and data in motion for visibility across the metadata landscape thanks to the broadest range of metadata connectors.

calendar (1).png

Schedulable & Configurable

Activate metadata incrementally or completely with granular version control and full traceability.

up-and-down (1).png

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.


Modern Data Catalog

Power a centralized, integrated data catalog complete with metadata mapping, SDLC management and version control.

data-integration (1).png

Optimized Data Pipeline & Infrastructure

Seamlessly operationalize and govern your organization’s data pipeline to the benefit of all stakeholders.

The erwin Automation Framework 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.

Benefits of erwin Smart Data Connectors

Greater agility, accuracy and faster time to value – these are the gifts of automatically harvesting, transforming and feeding metadata from virtually any source to any target in a single data catalog. Standard data connectors for JDBC-compliant data sources are included with an initial license of erwin DC. However, metadata-driven automation for more complex systems and environments must be custom-engineered as optional add-ons to erwin DC. The advantages of our smart data connectors for data automation are:


Metadata Harvesting

Harvest metadata from various data management silos and consolidate it into a single source.


Data Vault Automation

Build and populate Data Vaults and other complex long-term data storage environments, such as traditional data warehouses, marts and lakes.

analysis (1).png

End-to-End Data Lineage

Quickly render graphical source-to-target lineage for a detailed view of data in motion, including transformation logic.


Faster Data Migration & ETL Conversion Projects

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


Universal Code Generation

Accelerate the development and maintenance of data movement code by forward-engineering mapping documents into platform-specific code.


Data Mapping

Easily develop and maintain versioned mapping documents with sources, targets and transformation logic by reverse-engineering ETL/ELT, database procedural code and scripting languages.

machine-learning (1).png

Efficient Business Intelligence

Make data analysts more productive in analyzing BI reports, document dashboards and mappings generated 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.


erwin Smart Data Connectors


Complete list of Smart Connectors


erwin Data Intelligence Demo for Data Governance


erwin Data Intelligence Demo for Data Analysis

bottom of page