Visual ETL
Visual Database Migration Tool

  Extract, Transform and Load
Complex Data from Multiple
Data Sources using a Simple
Visual Wizard Like Interface.

Visual ETL: Making Data Migrations Easy
 
 
Home > Features
 
VisualETL is an easy to use Extract, Transform, and Load (ETL) database administration and migration wizard. It provides a visual point and click interface so even non-technical users can perform data transfers for most leading databases and other file formats.

Screen Shots | Video Tour | Download Trial | Buy Now
Our product is a powerful, easy to use, inexpensive database adminsitration tool. It's easy enough that average people can use it, but powerful enough that database administrators and professional developers will find it a time saving database administration tool. Similar database tools can cost thousands of dollars. 
 
We have designed our tool to provide  the features you need at a price you can afford.  

Just about every application your business uses relies on data. Therefore you need to manage it. The problem is that you can't break your budget. That is a problem that plagues many small to midsize companies. VisualETL.com has the seamless integrated solution. The following popular database/file formats are supported: MS Access, MS SQL Server, MySQL, MS Excel, dBase, HTML, XML and more.

Benefits:

  • Designed to simplify the transfer of data between different programs. Manual transfer is not only time-consuming, it is error-prone. Removes this barrier by providing an extremely fast, reliable and automatic way to move data.  
  • Using VisualETL, you can build data interfaces between two applications in a matter of minutes without writing a single line of code. 
  • Allows you to run a transfer in batch mode.  This makes it straightforward to set up fully automatic batch procedures for repetitive tasks. 
  • Can save hours and even days of manual labor, while at the same time eliminating error.
  • Provide end users with a tool to transfer and transform data from one format to another with a point and click user interface. Avoid writing code completely. This gives power to end users to quickly combine data from various sources.

Features

  • Supports the most popular formats – dBase, FoxPro, MS Access, Text (Comma Delimited, Tab Delimited, Fixed Length, Custom Delimited), Excel, MS SQL, MySQL, HTML, XML and ODBC.  
  • Any file format can be converted to any other file format. 
  • Easy to use Drag-and-Drop interface – no programming required. 
  • Advanced features for complex conversion jobs. 
  • Filter or Query you data from a simple query builder window. 
  • Browse window to view Source and Target Data. 
  • Pre-configure and run transfer profiles. 
  • Batch mode to run multiple transfer profiles. 
  • Save transfer profiles to desktop shortcuts. Run transfer profiles from these shortcuts or by command line. 
  • Color-coded status log file automatically written. 
  • Automatically execute a program or task before or after transfer. 
  • Overwrite or Append data. 
  • Auto Mapping feature. 
  • Delete Source record after transfer in order to archive old records to a history file. 
  • Ignore Duplicate Records during transfer. 
  • Search and Replace data during transfer. 
  • Start with Position / End at Position - If you wish to work with only a certain section of a field or extract specific characters. 

Many Data Formatting options for use during transfer on a field-by-field basis

  • Sentence Case, Title Case, Lower Case, Upper Case 
  • Concatenate or merge fields 
  • Trim Leading or Trailing Spaces 
  • Trim or add leading zeros 
  • Format Date fields 
  • Increment to next available ID. 
  • Increment ID starting with - You may specify any alphanumeric expression to begin incrementing from.
  • Explicitly round a numeric field to a certain number of decimal places

How VisualETL works

Using VisualETL is as easy as 1-2-3. Just pick your source, pick your target and then map.

Supported database/file formats

The following database/file formats are supported:

  • MS SQL Server
  • MS Access
  • dBase
  • FoxPro
  • MySQL
  • XML
  • HTML
  • MS Excel
  • Text
  • ODBC

More database/file formats will be added in future releases.

System requirements

VisualETL runs on Windows 2000, Windows XP and Vista. VisualETL requires a minimum of 512MB RAM and a Pentium class PC. Disk space requirement is 35 MB.

 

 

Bookmark this page
BlinkList Delicious Digg Facebook Fark Furl Google Bookmarks Livejournal Ma.gnolia Netvouz Newsvine Reddit Spurl Stumbleupon Wists Yahoo My Web


 visualetl

© Copyright Nexmation, LLC, 2008. All Rights Reserved.

Nexmation, LLC IT Consulting

Home Features Screen Shots Download Order Support license Articles Site Map

Sales Jobs - Medical Jobs - IT Staffing  - ERP Jobs