®

erwin Data Connectors by Quest®

®

AT A GLANCE

Metadata is at the heart of any data intelligence initiative. erwin provides metadata
expertise and an expansive library of erwin-built data connectors so that customers
can efficiently harvest metadata from across their enterprise data landscape. For use
with the erwin Data Intelligence Suite by Quest, erwin Data Connectors by Quest
are available for a wide range of industry data sources. They automatically gather
metadata spread throughout the enterprise and populate it into the central metadata
repository of erwin Data Catalog by Quest, part of the erwin Data Intelligence Suite.
Once inside the software, this centralized metadata is used for data mapping, automateddata discovery and integration – driving data governance artifacts and processes.
erwin Standard Data Connectors are included at no cost with erwin Data Catalogand automate metadata harvesting and ingestion from common data-at-rest datasources. A broad array of optional erwin Smart Data Connectors are available totake active metadata use to the next level. Through erwin’s proprietary automation
framework, erwin Smart Data Connectors tackle metadata harvesting from more
complex data-at-rest data sources, harvest metadata associated with data-in-motion,and offer forward-engineering capabilities.
SOLUTION OVERVIEW

management systems (DBMS), as well as
XML, JSON and CSV flat file metadata.

Standard Data Connectors
erwin Standard Data Connectors areout-of-the-box and provided at no charge
to automate harvesting and ingesting
metadata from common industry data-atrest sources to erwin Data Intelligence.
erwin Standard Data Connectors help
customers efficiently collect and maintaincurrent metadata from JDBC-compliant
data-at-rest sources, including relational,
NoSQL and Big Data databaseerwin Standard Data Connectors
shorten the time to value for erwin DataIntelligence by eliminating the manual
discovery and data entry associated withmetadata collection. Built and maintained
solely by erwin, erwin Standard Data
Connectors provide customers with asingle, trusted partner to work with assoftware, data sources and targets evolve.

Smart Data Connectors

Standard Data Connectors
SourcesEnterprise Data Warehouse

CRM

CRM

Staging

3NF Data Warehouse

ODS
Sales Schema

DataStage001External Data
Excel

TabularSQL Server
Reporting Services

Business
Glossary

Tableau

DQS
Dimensional
SSIS
DataStage002

BI REPORTING
LAYER

Policies

Operational Systems

ERP

SSAS

DataMart

Financial Schema

Multidimensional

SSIS

MDM

SSIS
Marketing SchemaPowerPivot
for
SharePoint

MicroStrategy

IBM Cognos

Rules

Communication
CenterOthers…

SSIS Transactional

Data Lake

Excel

PowerPivot
for Excel

PublishUse included erwin Standard Data Connectors to leverage JDBC-compliant data-at-rest
metadata from common industry sources. Add Smart Data Connectors to capture more
complex data-at-rest and data-in-motion metadata, and automate code generation,lineage, documentation and more.

BENEFITS OF ERWIN SMARTDATA CONNECTORS• Automate discovery and ingestionof complex data-at-rest metadataand schema from non-JDBC
compliant data sources, API-basedand cloud-based file storage;
Mongo DB, MariaDB and othersemi-structured data sources;
schemaless data and from other datacatalogs into erwin Data Catalog• Automate discovery and ingestionof data-in-motion for SQL, ETL,
4GL and BI procedural code andany data source with an open
SDK into erwin Data Catalog• Automate code generation toeliminate repetitive hand-coding,
speed development projectdelivery and ensure code quality• Accelerate project timelines andreduce complexity and barriers
to successful delivery andmaintenance of a Data Vault

Smart Data Connectors

Forward-engineering

Optional erwin Smart Data Connectors
extend data architecture visibility andcreate engineering efficiencies thatshorten delivery time and reduce risk.
In addition to metadata harvesting from
more complex data-at-rest data sources,
erwin Smart Data Connectors provide
reverse-engineering capabilities tocollect data-in-motion metadata andforward-engineering capabilities toactivate metadata-driven processing
within the development lifecycle. A wide
library of erwin Smart Data Connectors isavailable to connect erwin Data Catalog
with industry-standard DBMS, ETL/ELT
platforms and BI/reporting applications.
Backed by the robust parsing, code
generation and metadata activation capabilities of erwin’s proprietary automation
framework, erwin Smart Data Connectors
can be developed and customized to fit
even the most complex environment.

The forward-engineering automation
capabilities of erwin Smart Data Connectorsextend the power of metadata andenable IT teams to eliminate redundantmanual coding efforts, automatically
document data pipeline development
and change, standardize engineering
approaches and govern the development
lifecycle. The standardization andauto-documentation provided by pairing
erwin Smart Data Connectors with erwin
Data Intelligence assist IT organizations
in retaining tribal knowledge, assuring
quality, minimizing risk and controlling
costs in moving projects forward.

Reverse-engineering
Reverse-engineering is the best way togain a complete and unified view of anorganization’s current data architecture.
erwin Smart Data Connectors automate
reverse-engineering efforts, and include
data sources, flows, transformations andtargets. This information becomes aninvaluable asset to guide decision-making,impact analysis and data governance.

Quest

4 Polaris Way, Aliso Viejo, CA 92656 | www.quest.com
If you are located outside North America, you can findlocal office information on our website.

erwin Data Connectors are backed by
the deep integration expertise and trackrecord of erwin Professional Services,a proven partner to overcome any datachallenge. Through this experience,
erwin offers the broadest, most powerfullibrary of data connectors on the market.
See a complete list of erwin DataConnectors on erwin.com.
ABOUT QUESTQuest creates software solutions thatmake the benefits of new technology
real in an increasingly complex IT
landscape. From maximizing the value of
their data, to Active Directory and Office
365 management, and cybersecurity
resilience, Quest helps customers solve
their next IT challenge now. Quest
Software. Where next meets now.

© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Quest, Quest Software, the Questlogo, erwin and the erwin logo are trademarks and registered trademarks of Quest Software
Inc. and its affiliates worldwide. For a complete list of Quest marks, visit www.quest.com/legal/trademarkinformation.aspx. All other trademarks are property of their respective owners.
Datasheet-erwinDataConnectorsQuest-LP-67187