Data import

Q: Why do you need data import?

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

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.

Trusted By

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?

Native connectors

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).

Synchronize updates

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.

Custom import

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.

Criteria-based 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.

Export or load data

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.