Following formats are supported: Delimited Text, XML, Insert Script, QlikView QVX Files, QlikView QVD Files, Excel.
All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.
Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you
This article describes how you can export all tables from any database into text files
The first step is to download and install Advanced ETL Processor Professional
Then we need to create an ETL package. Let call it Export Package.
Let's run the Package
This solution is not database specific
Most databases can generate DDL for any object but not a lot of them allow generation of INSERT statements for the table data. The workaround is to use ETL Tools for transferring data across servers. However, there exists a need to generate INSERT statements from the tables for porting data. The simplest example is when a 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 in handy.
There is a number of scripts available to perform this data transformation task. The problem with those scripts that all of them are database specific and they do not work with textiles
Advanced ETL Processor gives you a universal solution for creating Insert statements. It works with any database or file.
Advanced ETL Processor generating insert statements
We are constantly working on optimizing the performance of our ETL software. The typical ETL process is very similar to a river. Narrow parts prevent water from flowing freely. But if there is no water widening narrows parts will not help. The data flow starts with the data reader. So it is important to make it very fast. It is so important to measure performance correctly. We always use the same table structure and the same file format for testing. We did spend a lot of time optimizing SQLite data reader and manage to make two times faster
Advanced ETL Processor Enterprise version 220.127.116.11 does 123,000 records per second and extracts 14mln records in 1 minute and 53 seconds
Advanced ETL Processor Enterprise version 18.104.22.168 does 364,000 records per second and extracts 14mln records in 38 seconds.
Copyright © 2022 ETL-tools.com. All Rights Reserved.