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 management, data governance and data intelligence.
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.
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.
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.
Schedulable & Configurable
Activate metadata incrementally or completely with granular version control and full traceability.
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.
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:
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.
Easily develop and maintain versioned mapping documents with sources, targets and transformation logic by reverse-engineering ETL/ELT, database procedural code and scripting languages.
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
Synchronize and harmonize data management and governance processes with third-party tools at the API level, reducing ongoing maintenance.