fbpx
Let's Talk

What Can DQ Studio™ Do?

What can DQ Studio do?

Use Cases

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

How Does it Work?

Connect

1. Connect

Connect to over 130+ sources and extract data from your legacy, on-premise, online systems, ready to be pushed to its new destination or environment.

3

2. Configure

With over 25 years of experience in customer data, we have come across a wide array of data quality issues and our team is committed to delivering each individual project on time and on budget.

1

3. Cleanse

Be assured that all your data is correctly formatted, transformed and enriched before searching for duplicates and being inserted or updated in your business applications.

DQ Infographic Studio

1. Connectors

Connect to over 130+ data sources and targets. Migrate from source to target, integrate between multiple systems, or consolidate one to many systems by utilising our many connectors. Once data has been extracted, it is standardised into SQL format ready to enter a data cleansing, matching, mastering workflow.

Discover our range of connections by clicking the tabs below.

Standard

FixedLengthFile
Fixed Length Files
appRules.Core
Core Activities
appConnector.Record
Record Activities
icon odbc
ODBC
DelimitedFile
Delimited Files
appConnector.Logs
Log Activities
appConnector.Viewers
Viewers
icon oledb
OLEDB
FileSystem
File System
appConnector.List
List Activities
appConnector.Automation
Automation Activities

CRM/ERP

icon dynamics365 small
Microsoft Dynamics365
icon netsuite 1
NetSuite CRM
icon zohocrm
ZohoCRM
icon dynamicsgp
Microsoft Dynamics GP
icon dynamicscrm
Microsoft Dynamics CRM
icon oraclecrm
Oracle CRM
icon sap
SAP
icon dynamicsnav
Microsoft Dynamics NAV
icon salesforce
Salesforce
icon sugarcrm
SugarCRM
icon netsuite 1
NetSuite ERP
icon dynamicsax
Microsoft Dynamics AX

Databases

icon sql
SQL Server
icon mysql
MySQL
icon teradata
Teradata
icon firebird
Firebird
icon db2
DB2
icon postgresql
PostgreSQL
icon nuodb
NuoDB
icon sqlite
SQLite
icon oracle
Oracle
icon informix
Informix
icon msaccess
Microsoft Access
icon sqlce
SQLCe Icon

Marketing/Social

icon marketo
Marketo
icon mailchimp
Mailchimp
icon linkedin
Linkedin
icon eloqua
Eloqua
icon facebook
Facebook
icon hubspot
HubSpot
icon twitter
Twitter

Accounting

icon exact
ExactOnline
icon quickbooks
Quickbooks
icon sageuk
Sage50UK
icon freshbooks
Freshbooks
icon quickbooks
Quickbooks Online
icon xero
Xero
icon intacct
Intacct
icon qbpos
Quickbooks POS

Big Data / No SQL

icon bigquery
BigQuery
icon mongodb
MongoDB
icon hpcc
HPCC ECL Queries
icon dynamodb
DynamoDB
icon azure
Azure Table Storage
icon simpledb
SimpleDB

Spreadsheets/Collaboration

googleapps
GoogleApps
icon excel
Excel
icon sharepoint
SharePoint
icon excelservices
Excel Service
icon exchange
Exchange Icon
icon gsheets
GoogleSheets

Analytics/Service

icon google analytics
Google Analytics
icon ldap
LDAP
icon email
Email
icon msproject
MS Project
icon OData
OData
icon gmail
Gmail
icon activedirectory
Active Directory
icon RSS
RSS

2. Data Quality Improvement

2

Cleanse

Cleanse fields or Records to improve your data hygiene. Format, tokenise and enrich your data ready for matching.

People

Match

Tokenise and transform your data to benefit from our DQ Fontix ™fuzzy matching algorithms.

DQ Icons (1)

Score

It is one thing finding duplicates, but are they legitimate? Utilise our advanced scoring module to ensure you are returning genuine duplicate records

Graduation Cap

Master

Assemble a set of rules to define how records are mastered before an insert, update or merge event.

1

Review

Send ambiguous records to our review process and maintain your data compliance, data integrity and data governance.

3

Schedule

Timetable a regular cadence for your data management tasks so your data quality is the least of your concerns.

3. DQ Consulting

Map

  • Uncover the map of the data quality minefield
  • Understand your data management goals
  • Discover and clarify your current situation using our ‘data value map’
  • Identify your obstacles to success
  • Agree on actions and set out the solution roadmap

Implement

  • Customise the proposed solution
  • Implement the proposed solution
  • Manage project milestones

Maintain

  • Work alongside DQ Global to help configure, refine and implement your successful data quality project
  • Over 25 years of experience in Data quality
  • Project knowledge transfer
  • Application training
  • Ongoing support

DQ Studio™ Products & Services

DQ Studio™ Foundation

  • Connect to 130 + data sources & targets
  • Schedule and build workflow processes
  • Limited data quality modules
  • Data replication
  • Decision tables
  • Low Code/No code UI

DQ Studio™ Master

  • Unleash the full potential of DQ Studio with our Master Edition
  • Build complete data quality workflows with modules, including cleanse, match, score, master and review

DQ Consulting

  • Map the data quality minefield
  • Implement alongside DQ Global’s expert consultants
  • Maintain and update your solutions

Let's Talk

The best way to learn more about how our solutions 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