Work with: Text, XML, Excel, Access, DBF, Foxpro, Paradox, ODBC, BDE, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.

ETL for Interbase and Firebird

Visual Importer ETL Imports/Exports data into/from InterBase/Firebird with ease.

It is a powerful Data transformation tool to import data into InterBase/Firebird tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV and majour databases.
It provides adjustable import parameters, including source date formats, loading data from multiple tables using mask and using sql statement as a data source.
Data can be Imported into InterBase/Firebird manually or by using command-line.

Key Features

• Works directly with : MS Excel 97-2007, MS Access, DBF, TXT, CSV, Oracle, MS Sql Server, MySQL, PostgreSQL, ODBC, Interbase and Firebird, SQLite
• A number of import modes - Insert All, Insert New, Insert or Update, and others
• Adjustable import parameters for each source file
• Saving all import parameters set on current session
• Command-line interface to import data using the configuration file
• Powerful data preview module
• Incredible value for money

About Firebird

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

The Firebird Project is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000.

FREE LIKE A BIRD.

Anyone can build a custom version of Firebird, as long as the modifications are made available, under the same IDPL licensing, for others to use and build on.

FREE LIKE FREE BEER.

No fees for download, registration, licensing or deployment, even you distribute Firebird as part of your commercial software package.
Firebird's development depends on voluntary funding by people who benefit from using it. Funding options range from donations, through Firebird Foundation memberships to sponsorship commitments.    Choosing Firebird and saving or making money by your choice? Show your appreciation and encouragement by contributing money in proportion to these benefits.

More Information about Firebird Database

Generate Insert Statements

A lot of databases do not support generation of INSERT statements for the table data. However, there is a need to generate INSERT statements from the tables for porting data. Simplest example is when small or large amount of data needs to be taken out on a removable storage media and copied to a remote location, INSERT..VALUES statements come handy. There is a number of scripts available to perform this data transformation task. The problem with those scripts that all of them database specific and they do not work with textiles

Advanced ETL Processor gives you an universal solution for creating Insert statements. It works with any database or file.

Benefits and advantages

• Data from both tables and views can be scripted
• Support for text files
• Table names and column names with spaces are handled
• All datatypes are handled
• NULLs are gracefully handled
• Timestamp columns are handled
• Identity columns are handled
• Very flexible and configurable
• Computed columns are handled
• You can filter the rows/lines for which you want to generate INSERT's

Advanced ETL Processor generating insert statements

Competitive Upgrades

• Reached the limitations of your existing ETL automation tool?