DataRight IQ
Data Cleansing & Standardization
DataRight IQ
Parse, standardize, and cleanse all types of data - from names, email addresses, phone numbers, account numbers, dates, or any user-defined pattern and data.
ASCII
delimited
dBase3
EBCDIC
User defined pattern matching
Boolean expressions for your filters
What is DataRight IQ?
Firstlogic DataRight IQ is self-managed server software for general-purpose data cleansing. With DataRight IQ, organizations can parse and cleanse data using user-defined patterns. Parse, standardize, and cleanse data such as names, firms, email addresses, phone numbers, social security numbers, account numbers, dates, and more. Available as a self-managed product, DataRight IQ can be run on-premise or in-cloud depending on your need.
Unlimited Records
Pay by license, not by record. You won't be surprised by usage fees.
Secure Processing
Your data never leaves your server - records are processed entirely offline. Easily comply with privacy best practices and regulations.
All Included
We provide you the software, directories, and know-how to install and manage the software on your own infrastructure.
Direct Integrations
Direct access to Microsoft SQL Server, MySQL, Oracle RDBMS, ASCII, delimited, dBase3, or EBCDIC flat files.
Partnered with SAP
As a leading SAP® Partner, Firstlogic utilizes the enterprise-proven SAP DQM SDK. Get the same precision and stability you’ve come to expect from SAP.
DataRight IQ takes you through the Data Cleansing Process
1. Parsing.
Identifies individual data elements and break them down into their component parts. Using DataRight IQ, you can rearrange data elements in a single field or move multiple data elements from a single data field to multiple discrete fields.2. Standardization.
Set business rules around formats, abbreviations, acronyms, punctuation, greetings, casing, order, and pattern matching – all examples of elements you can control to meet your business requirements and prepare the data for validation, correction, and accurate record matching.3. Correction.
Finally, run DataRight IQ to identify and cleanse "dirty data" using built-in and custom algorithms and rulesets.Built-in cleansing functions and directories
Powerful data manipulation algorithms.
Address-Level Geocoding converts physical addresses into latitude and longitude coordinates using multiple industry leading geocoding directory providers.Nth Select Type for random user selection
Bypass filter exclude
Built-in User Modifiable Dictionaries.
DataRight IQ ships with built-in cleansing packages, also known as User Modifiable Dictionaries (UMDs). These dictionaries are referential data sources collected and packaged to provide extra identification and appending capabilities, including:Prenames
Nicknames
Firm acronyms
Gender codes
Customizeable outputs.
DataRight IQ will allow you to build structures that are Fixed ASCII, Delimited ASCII, DBase3, or EBCDIC.Why C.TRAC Direct loves DataRight IQ
“The other vendors usually can’t equal the functionality we see from Firstlogic software”
—Gina Greco, Manager of Data Services
Technical Specifications
| Supported Platforms | Windows, Linux |
| Server deployment options | On-premise or on a cloud provider of your choice (AWS, Azure, GCP, etc.) |
| Minimum System Requirements | For on-premise installations, a minimum of 1 physical server with 4 CPUs For in-cloud installations, a minimum of 1 cloud instance with 4 vCPUs |
| SDK APIs | Java, .NET, C++ |
Ready to get started?
Request a demo or talk to our sales team to answer your questions about DataRight IQ