For the best web experience, please use IE11+, Chrome, Firefox, or Safari
Home / Products / Quest Data Connectors

Quest Data Connectors

Quest offers proven, ready-to-use connectors, enabling fast, automated use of Quest Data Intelligence and the Quest Trusted Data Management Platform. Included Standard Data Connectors automate metadata harvesting from common data sources into your data catalog. Advanced Smart Data Connectors capture metadata from data in motion for use in data lineage and automate data pipeline development and operations.

erwin Smart Data Connectors
Request Demo Request Pricing
Quest Data Connectors
Overview Benefits Resources Support
Request Demo

The Advantage of Quest Data Connectors

Quest offers a robust library of 100+ Quest-built data connectors to provide data landscape visibility and leverage metadata to automate data management, data governance and data intelligence. Standard Data Connectors, included in every subscription, 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 optional Smart Data Connectors for complex environments and these added advantages:

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 Quest’s proprietary automation framework, Quest 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.

List of Quest Standard Data Connectors

Data Modeling Connectors

Quest Data Modeler

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 Quest Smart Data Connectors

Data Integration 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

The Quest Automation Difference

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.

Quest-built & maintained

Our library of data connectors is developed and maintained by Quest, 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 Quest automation and expertise to successfully tackle sophisticated development projects, such as delivery and operation of a Data Vault.
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.
Request Demo

Resources

View All
Datasheet

Quest Data Intelligence

Make trusted data and AI models easy to find, understand, govern, score and use in your enterprise
Analyst Report

Gartner® Report: Critical Capabilities for Metadata Management Solutions

See Quest Software's top-three ranking across all five metadata management use cases in Gartner's Critical Capabilities report.
Case Study

Wealth management firm simplifies audit preparation and gains data estate visibility

Since 1991, clients have put their trust in St. James’s Place, one of the largest advice-led wealth management firms in the UK....
E-book

Scaling AI and Business Value through Automated Data Products

Data teams are pressured to move faster with analytics and AI but most data delivery efforts remain slow, manual, and one‑off. ...
Analyst Report

Omdia Analyst Review of Quest Automated Data Product Factory

Omdia analyst Stephen Catanzano reviews the introduction of the Quest Trusted Data Management Platform and its Automated Data P...
Video

Build trusted, AI ready data products in days with Quest

Building trusted, reusable data products shouldn’t take months. Yet manual processes, skipped governance, and siloed teams ofte...
Video

Introducing Quest Data Marketplace

Take a look at this quick overview to see how Quest Data Marketplace, available within Quest Data Intelligence and the Quest Tr...
E-book

7 Steps to Maximizing the Value of Your Data eBook

Improve your organization's ability to extract value from your data with this 7 step erwin by Quest approach to data maturity. ...