Let's Talk

Use Cases

Integration and Migration
Data Quality Improvement
Data Cleansing
Data Replication
Data Governance
Master Data Management
Process Automation
Business Rules Execution

DQ Infographic 2

Connectors

DQ Studio™ connects to over 130 target and source systems, take a look at the connectors below:

Show Connectors

Standard

Add-On/Connector
Description
FixedLengthFile
Fixed Length Files
Extended activity module and connectors for text fixed length files
DelimitedFile
Delimited Files
Extended activity module and connectors for delimited files
FileSystem
File System
Extended activity module and connectors for Files and Folders
appRules.Core
Core Activities
Core activities for common functions including launching functions, expressions, launching external jobs etc.
appConnector.Logs
Log Activities
Activity module for logging entries
appConnector.List
List Activities
Activity module for managing of custom lists and picklists
appConnector.Record
Record Activities
Activity module for processing records and pre-loaded records
appConnector.Viewers
Viewers
Design time activity module used for viewing records and values during development
appConnector.Automation
Automation Activities
System activities automating sources & project management for launching, monitoring and stopping processes
icon odbc
ODBC
Activities and Connector for ODBC database access
icon oledb
OLEDB
Activities and Connector for OLEDB database access

CRM/ERP

Add-On/Connector
Description
icon dynamics365 small
Microsoft Dynamics365
Activity module and connectors for Dynamics365 (Sales, Financials, Operations)
icon dynamicscrm
Microsoft Dynamics CRM
Activity module and connectors for CRM onpremise and online (from CRM4 to CRM2016)
icon salesforce
Salesforce
Activity module and connectors for Salesforce
icon netsuite 1
NetSuite CRM
Activity module and connectors for NetSuite CRM
icon oraclecrm
Oracle CRM
Activity module and connectors for Oracle CRM
icon sugarcrm
SugarCRM
Activity module and connectors for SugarCRM
icon zohocrm
ZohoCRM
Activity module and connectors for ZohoCRM
icon sap
SAP
Activity module and connectors for SAP
icon netsuite 1 1
NetSuite ERP
Activity module and connectors for NetSuite ERP
icon dynamicsgp
Microsoft Dynamics GP
Activity module and connectors for Dynamics GP
icon dynamicsnav
Microsoft Dynamics NAV
Activity module and connectors for Dynamics NAV
icon dynamicsax
Microsoft Dynamics AX
Activity module and connectors for Dynamics AX

Databases

Add-On/Connector
Description
icon sql
SQL Server
Activity module and native connectors for Microsoft SQL Server databases
icon db2
DB2
Activity module and connectors for IBM DB2 databases
icon oracle
Oracle
Activity module and connectors for Oracle databases
icon mysql
MySQL
Activity module and connectors for MySQL databases
icon postgresql
PostgreSQL
Activity module and connectors for PostgreSQL databases
icon informix
Informix
Activity module and connectors for IBM Informix databases
icon teradata
Teradata
Activity module and connectors for Teradata databases
icon nuodb
NuoDB
Activity module and connectors for NuoDB databases
icon msaccess
Microsoft Access
Activity module and connectors for Microsoft Access databases
icon firebird
Firebird
Activity module and connectors for Firebird databases
icon sqlite
SQLite
Activity module and connectors for SQLite databases
icon sqlce
SQLCe Icon
Activity module and connectors for Microsoft SQL Server Compact Edition databases

Marketing/Social

Add-On/Connector
Description
icon marketo
Marketo
Activity module and connectors for Marketo
icon eloqua
Eloqua
Activity module and connectors for Oracle Eloqua
icon hubspot
HubSpot
Activity module and connectors for HubSpot
icon mailchimp
Mailchimp
Activity module and connectors for MailChimp
icon facebook
Facebook
Activity module and connectors for Facebook
icon twitter
Twitter
Activity module and connectors for Twitter
icon linkedin
Linkedin
Activity module and connectors for Linkedin

Accounting

Add-On/Connector
Description
icon exact
ExactOnline
Activity module and connectors for ExactOnline
icon freshbooks
Freshbooks
Activity module and connectors for Freshbooks
icon intacct
Intacct
Activity module and connectors for Intacct
icon quickbooks
Quickbooks
Activity module and connectors for QuickBooks
icon qbonline
Quick Books Online
Activity module and connectors for QuickBooksOnline
icon qbpos
Quick Books POS
Activity module and connectors for QuickBooksPOS
icon sageuk
Sage50UK
Activity module and connectors for Sage50UK
icon xero
Xero
Activity module and connectors for Xero

Big Data/No SQL

Add-On/Connector
Description
icon bigquery
BigQuery
Activity module and connectors for Google BigQuery
icon hpcc
HPCC ECL Queries
Activity module and connectors for HPCC Systems
icon azure
Azure Table Storage
Activity module and connectors for Azure Table Storage
icon mongodb
MongoDB
Activity module and connectors for MongoDB
icon dynamodb
DynamoDB
Activity module and connectors for Amazon DynamoDB
icon simpledb
SimpleDB
Activity module and connectors for Amazon SimpleDB

Spreadsheets/Collaboration

Add-On/Connector
Description
googleapps
GoogleApps
Activity module and connectors for GoogleApps
icon sharepoint
SharePoint
Activity module and connectors for SharePoint
icon exchange
Exchange Icon
Activity module and connectors for Microsoft Exchange
icon excel
Excel
Activity module and connectors for Microsoft Excel
icon excelservices
Excel Service
Activity module and connectors for Microsoft Excel Service
icon gsheets
GoogleSheets
Activity module and connectors for Google Sheets

Analytics/Service

Add-On/Connector
Description
icon google analytics
GoogleAnalytics
Activity module and connectors for GoogleAnalytics
icon msproject
MS Project
Activity module and connectors for Microsoft Project
icon activedirectory
Active Directory
Activity module and connectors for Microsoft Active Directory
icon ldap
LDAP
Activity module and connectors for LDAP
icon OData
OData
Activity module and connectors for OData
icon RSS
RSS
Activity module and connectors for RSS
icon email
Email
Activity module and connectors for Email
icon gmail
Gmail
Activity module and connectors for GMail

Modules Available

Optional additional modules can be added to DQ Studio

Master Record Merge

Powerful module designed to detect the best record from a set of matched records, auto-fill data field values into the selected best record to assemble a ‘Golden Record’.

Batch Match

An integrated record matching engine using advanced fuzzy matching logic to identify duplicate records.

DQ on Demand

Access our wide array of data improvement functions without having to write any code through DQ on Demand.

 

Benefits of using DQ Studio:

Enhance confidence in data
Facilitate good quality decision making, fuelled by accurate reporting
Prevent the development of costly workarounds
Ensure regulatory compliance
Provide data more readily available for analysis
Enhance customer relationships

Let's Talk

The best way to learn more about how DQ Studio™ can help is to let us know more about your data challenge.

  • This field is for validation purposes and should be left unchanged.
Let's Talk