Baycastle Software DataSlave, ETL at market-leading value for money
  Contact Forum Support Home

DataSlave Screenshots

 

DataSlave provides a graphical tool to import, validate, transform and export data.
At all times the data can be reviewed in the data panel showing rows that pass validation and those that fail.

Any column can be validated to check for example:

- The customer ID is in range
- The Contact Name is valid
- The Region is not missing
- The ZIP code is of correct format
- The Phone and Fax numbers are correctly formatted
Data can be mapped onto the fields of your database and where required transformed.
In this case the Contact Name is split into separate FirstName and LastName fields.
One of a large number of Transform Functions, the Name Split accepts a single contact field and creates the constituent fields. More...

DataSlave more...

News

What is a Null?

A Null and an empty string are not the same. We discuss when a Null is found in the data and how it is used.

Handling abbreviations in your data

We discuss how to handle abbreviations found in your source data. DataSlave offers a tool to abbreviate and indeed "de-abbreviate" data.

 

 

 

 

Data Export / Data Import / Data Validation