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

ETL

 

Visual ETL Tool

DataSlave is an example of an ETL Tool (Extract, Transform and Load) tool. It is designed to allow you to import data from for example a CSV File and then run a series of data quality checks on that data.

Follow the links to the right to find out more.

Formats supported as part of Extract Transform Load

Check the data for valid formats - Social Security Number, Email address, URL, ISBN number, valid telephone number, ZIP code, Postcode and many more. DataSlave offers over 100 standard functions, more than most ETL Tools on the market and at a market-leading price.

Transform

Data can be modified for example splitting a field into two, breaking up a contact name or stripping our unwanted characters. More than 35 standard functions.

De-duplicate

Data can be checked for duplicate or repeated records either within its self or compared to another set of data.

Finally the clean data can be loaded into a new database or exported into a text file.

DataSlave is a leading ETL Tool, but also provides de duplication (de dup) and data cleaning, removing duplicates, clone or repeat records. We do not use soundex as this does not work well with names drawn from non-English sources. We use the number of edits, a simple but effective approach.

First-class ETL

DataSlave is designed to allow you to import data, transform data, validate data and finally export that data. DataSlave is one of the best tools on the market for database import, database export and data migration. We are not a de duplication service, but a de-dup tool that you own and use as many times as you need. An ETL Tool with data de-duplication built in. DataSlave also offers tools for merging data.

DataSlave provides support for CSV files, Tab delimited, comma delimited, fixed format files, Microsoft Access, Excel, SQL Server, FoxPro, Act, DataFlex, MySQL, ODBC, OLE DB, Oracle, VSAM, Paradox, Postgress, dBase, ISAM. More...

The data can come from marketing lists, email lists, mailing lists, direct mail lists, address lists, contact management systems, CRM systems, Maxamiser, ACT!, Outlook. Make DataSlave a part of your marketing campaign management or list management.

You can also use the DataSlave SDK to add a ETL into your own application. A data migration facility with the minimum of development effort. Learn more. See a demonstration of Extract Transform Load (ETL) in action.

Key ETL projects our customers have undertaken

 
Data Export / Import project
Major UK bank exports data from a sales system to a customer service system to manage a large customer communications project. Mission critical ETL.
 
Data Export project

Web marketing services company carries out a regular data export as part of a significant wen marketing initiative. ETL in action

 
Data Export project
US data supplier uses DataSlave to carry out data export (ETL) for delivery of that data to customers.

Your ETL project

Contact us today and let us help you design your ETL project. We can join you in a GoToMeeting session or you can send us a sample of the data you need to manipulate.Let our professional team help you meet your project delivery targets. Data Import, Validation, Transformation and Data Export or Extract Transform Load (ETL) is our business.

 

Download your free evaluation today.

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.

 

 

 

 

ETL Tool / CSV / Extract Transform Load