Contact Us

Call Us

+1 800-78-erwin
(800-783-7946)

Click here for a list of erwin’s global offices.

Technical Support
Submit a Ticket

+1 813-773-4170

Chat

Get live sales support.

Email

Send us comments or
ask general questions.

info@erwin.com

erwin Smart Data Connectors

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

Request Demo

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 management, data governance and data intelligence.

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.

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.

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.

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.

Harmonized Data Management
& Governance

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

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.

What’s Really Different About erwin’s Approach to Metadata-Driven Automation?

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-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.

Modern Data Catalog

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

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.

Optimized Data Pipeline
& Infrastructure

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

Schedulable & Configurable

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

List of erwin Smart Data Connectors

#TECHNOLOGY PLATFORMREVERSEFORWARD
Metadata ConnectorsSmartAVRO
SmartAzure Data Lake (Gen 1 / Gen 2)
SmartCobol Copybooks
SmartGzip
SmartKafka Topics
SmartORC
SmartParquet
SmartS3 Scanner
#TECHNOLOGY PLATFORMREVERSEFORWARD
ETL/ELT Platform ConnectorsSmartAurora SQL
SmartAzure Synapse SQL
SmartDenodo
SmartIBM DataStage
SmartInformatica PowerCenter
SmartMatillon
SmartMicrosoft SQL Server Analysis Services (SSAS)
SmartMicrosoft SQL Server Integration Services (SSIS)
SmartMS TSQL
SmartOracle DI
SmartOracle Packages
SmartOracle PL/SQL
SmartOracle Warehouse Builder
SmartPentaho DI
SmartPowerShell Scripts
SmartQlik Replicate
SmartRedshift SQL
SmartSAP Data Services
SmartSAP HANA CV
SmartSAS DI
SmartSnowflake SQL
SmartTalend
SmartTeradata BTEQ
#TECHNOLOGY PLATFORMREVERSEFORWARD
BI Report ConnectorsSmartCognos
SmartMicrosoft SQL Server Reporting Services
SmartMicrostrategy
SmartOracle OBIEE
SmartPower BI
SmartPyramid Analytics
SmartTableau
#TECHNOLOGY PLATFORMREVERSEFORWARD
Testing Automation ConnectorsSmartData Aggregation Comparator
SmartData Comparator
SmartMetadata Comparator
#TECHNOLOGY PLATFORMREVERSEFORWARD
Ecosystem ConnectorsSmartCloudera Atlas
SmartGit Hub
SmartIBM InfoSphere Governance Catalog
SmartJira
SmartMulesoft
#TECHNOLOGY PLATFORMREVERSEFORWARD
MethodologySmartData Vault (Package of Smart Connectors)

If you believe you need a smart data connector you don’t see above, please contact erwin or your erwin partner representative.

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

Helpful Resources

Datasheet

erwin DI

PDF

Datasheet

erwin Data Connectors

PDF

Video

erwin Data Intelligence
Demo for Data Governance

PLAY

Video

erwin Data Intelligence
Demo for Data Analysis

PLAY

Video

erwin Data Intelligence
Suite Overview & Product Demos

PLAY

White Paper

Data Governance Preparedness Using Data Catalogs

PDF

Report

2020 State of Data Governance and Automation

PDF

White Paper

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

PDF

Report

IDC Data Intelligence Innovators
2019

PDF

White Paper

Data Intelligence: Empowering
the Citizen Analyst

PDF

© 2020 erwin, Inc. All rights reserved.