Data import

All-in-one solution for connecting and combining data from multiple disparate sources – including file formats, relational databases, cloud storage, and APIs – and merging them to attain clean and standardized data.

Watch overview
Download

Trusted By

Trusted By

solution by feature

DEFINiTION

What is data import?

Data import is a feature that enables and allows you to connect disparate data sources to one application – especially for the purpose of data cleansing, matching, deduplication, or merge/purge.

Data import option must support multiple data inlets, such as local files (text files, CSV, excel sheets), databases (SQL Server, Oracle, Teradata), cloud stores (CRMs such as Salesforce), APIs, and other databases using ODBC connection.

Benefits

Why do you need data import?

Bring it all together

Join data from a variety of data stores and applications and keep all information related to an entity at one place.

Standardize data across sources

Resolve the syntactic and semantic differences in data values that develop while residing in siloes across multiple sources.

Drive holistic business insights

Ensure the accuracy of data-driven decisions by considering all data dimensions captured at different points in time.

Build a single source of truth

Provide a single source of truth to employees and customers by combining and joining data from varied sources.

Features

What can DataMatch Enterprise’s data import do for you?

DataMatch Enterprise supports import from a variety of data types and formats, including local files (text files, CSV, excel sheets), databases (SQL Server, Oracle, Teradata), cloud stores (CRMs such as Salesforce), APIs, and databases using ODBC connection. For custom projects or other specific requirements, we can also build new native connectors (condition apply).
After data import, you can sync sources to fetch updated records at any time to make sure that you’re using up-to-date information for your data quality management process.
While importing data from the connected source, you can also select specific tables, as well as columns within those tables that you wish to import.
For SQL databases, DataMatch Enterprise offers the option to write and run custom SQL scripts for joining tables and importing data based on some criteria.
All data imports are maintained in your Data Library that can be exported as local files whenever needed or loaded back to Tableau, databases, cloud stores, etc. You can also choose to export or load cleaned, matched, and deduped data records.

There’s more

What else do you get out of the box?

Our solution comes with a number of in-built features that facilitate easy, automatic, and error-free operations for importing and combining data.
  • Live preview of imported data
  • In-built and custom connectors
  • Support for bulk imports
  • SQL scripting for custom import
  • Data source and project library
  • Data files and fields renaming
  • Replace and reload data sources
  • Multi-format support for exporting results

User roles

A tool made for everyone

Data analysts

Business users

IT Professionals

Novice users

Features

We take care of your complete DQM lifecycle

Import

Connect and integrate data from multiple disparate sources

Profiling

Automate data quality checks and get instant data profile reports

Cleansing

Standardize & transform datasets through various operations

Matching

Execute industry-grade data match algorithms on datasets

Deduplication

Eliminate duplicate values and records to preserve uniqueness

Merge & purge

Configure merge and survivorship rules to get the most out of data

Want to know more?

Check out DME resources

Merging Data from Multiple Sources – Challenges and Solutions

Oops! We could not locate your form.

Resource Center
Tagged