What is SQL DataTool?

SQL DataTool is a data solution for data analysts to easily import data into SQL server databases. It enables you to connect to different databases and import data from different sources and sourcetypes into the database. SQL DataTool helps you as a data professional to focus on your value added activities, which should not be solving issues around the ETL process!

SQL DataTool process

Error handling

Have you ever had issues while importing data into a database? One record with an error breaks your data load, and the source table remains empty. SQL DataTool allows you to solve errors when importing data. Records with errors are written away in an error-file, without breaking the import. You can then solve these errors and append the data to the already imported table.

Error handling

Import different file types

Import data from different file types. You can import plain text files, comma separated files, excel sheets or MS Access databases. You can even import a whole folder in one run, making it very easy to batch import (or append) data into a new or existing database.

SQL DataTool filetypes

Easy reload of data

Do you have files that have to be loaded regularly? With SQL DataTool you can save your import settings, so you can reuse these settings. No need to find the right settings again, just store your imports.

Save import config

 

  Default Tools/Import wizard SQL DataTool
Import Access database
Import Excel files
Import plain text/csv files
Import multiple text files in one run
Interpretation of line breaks
Advanced date import
Import continues on error
Solution to erroneous records

Please contact us when you have questions, suggestions or remarks about our product or services.