Company News And Articles
Generic company news, product release notes, and practical articles about ETL, automation, data transformation, and DB Software Laboratory products.
Browse product updates, ETL guides, automation examples, and practical notes from DB Software Laboratory.
Articles Library
Filter by topic or search by product, feature, and format.
Showing 127 articles
Escaping Strings
A lot of our users ask us how to deal with special characters. for example "End of the line" can be in the middle of notes fields and it has to be deleted or...
Price Update Effective 1 August
DB Software Laboratory product prices will increase from 1 August. Current pricing remains available until 31 July.
Advanced ETL Processor - 6.5.2
Advanced ETL Processor 6.5.2 adds the ability to hide connections from the objects tree and Local System Account support during setup.
Advanced ETL Processor Enterprise 6.5 Is on Product Hunt
Advanced ETL Processor Enterprise 6.5 is now on Product Hunt, with Clarion TopSpeed support and faster large-repository navigation.
New Website Design
We have spent the last three weeks updating the ETL Tools website design across more than 1300 pages, excluding the support forum and wiki.
Advanced ETL Processor - 6.5.0
We’re pleased to announce the release of Advanced ETL Processor 6.5.0. What’s New in This Version Added: Clarion Top Speed Source in Reader Improved: Object...
NHS Income Planner
Managing NHS contracts, forecasting activity, and staying compliant with evolving national rules can be complex and time-consuming. That’s where a cloud-host...
Benefits of Using Advanced ETL Processor
Advanced ETL Processor helps teams automate ETL workflows with self-hosted control, 550+ functions, 130+ actions, and no subscription or row fees.
Working With BDE Databases in ETL Jobs
Work with BDE databases, Paradox, dBASE, and legacy Borland data in ETL jobs while planning safer exports, validation, and migration.
Cloud Storage Browser
Working with multiple cloud platforms can quickly become complex when you rely on separate tools and manual file handling. A Cloud Storage Browser simplifies...
URL Logger 2.0 Release
URL Logger 2.0 introduces powerful new features and performance improvements for capturing and managing webhook data. What is URL Logger URL Logger is a univ...
Advanced ETL Processor - 6.4.7
We’re pleased to announce the release of Advanced ETL Processor 6.4.7. What’s New in This Version Added: Parquet Source in Reader Added: Delimited File → Pa...
Cloud ETL vs On-Prem ETL for Medical Organizations
Healthcare IT teams face unique challenges when managing patient data. Between strict compliance requirements, patient data privacy concerns, and rising oper...
Choosing the Best ETL Software in 2025
In 2025, businesses are more data-driven than ever before. From CRMs and analytics platforms to marketing tools and ERP systems - every part of your organiza...
Automate Excel Tasks Without Excel Installed
What is Excel Automation? Excel automation is the process of using software or scripts to handle tasks in Microsoft Excel automatically-without manual effort...
Running ETL Packages from Active Table Editor
Several of our customers have asked us recently how to run Advanced ETL Processor or Visual Importer ETL Package from Active Table Editor or any other applic...
Edit QlikView QVD and QVX Files With Q-Eye
Edit QlikView QVD and QVX files with Q-Eye to inspect records, check metadata, export data, and make controlled Qlik file fixes.
Excel Spreadsheet ETL Transformation
In many organizations, Excel spreadsheets are everywhere-and for good reason. A modern ETL tool must integrate reliably with Excel to meet business needs. Am...
Creating Tableau TDE files
A Tableau data extract file (TDE ) is a compressed snapshot of data stored on disk and loaded into memory as required to render a Tableau viz. All versions o...
Visual Importer Enterprise vs Advanced ETL Processor Enterprise
ETL Features Visual Importer Enterprise Advanced ETL Processor Enterprise $330 $690 Data Sources Multiple Delimited or Fixed width Text files Multiple Excel...
Advantages and disadvantages of working with XML
Working with XML offers both flexibility and complexity. While it's widely used for data exchange, its effectiveness heavily depends on how well the XML is d...
Automate FTP Uploads and Downloads
FTP protocol is used daily by most businesses around the world. Our ETL Software makes it easy to automate FTP Uploads and Downloads. Complete FTP Automation...
Automatic File Compression
Visual Importer ETL provides extended support for automation of compression and decompression operations, it supports a wide range of archive file formats su...
Automatic File Decompression
Advanced ETL processor provides extended support for automation of compression and decompression operations, it supports a wide range of archive file formats...
Automating sending HTML Emails
There two ways of sending HTML emails with Advanced ETL Processor by using the package or as part of the transformation Automation Package sample: Sending pr...
Cloud Storage Automation
Good news we have just added support for cloud storage to our ETL products. Supported Cloud Storage Operations: Download and Upload Files, Create and Delete...
Create Tableau Hyper files
We are happy to announce that the latest version of Advanced ETL Processor supports the creation of Tableau Hyper files What’s Hyper? Under the hood, Hyper i...
Customer Feedback on MYOB and FTP Automation
Customer feedback on using Advanced ETL Processor for MYOB XML exports, FTP uploads, order downloads, processing, and database updates.
Data Synchronization part 1
This article was created to assist our customers with data synchronization. In our examples we will be synchronizing between different physical SQL Servers...
Data Synchronization Part 3: Large Table Sync
Data synchronization for large tables using high-water marks, package variables, SQL ranges, and safer incremental loading in repeatable ETL workflows.
Data Warehouse Performance: How to Estimate Query Time
Learn how to estimate data warehouse performance using row size, table size, disk speed, query testing, and practical ETL checks.
Generate QVD Files for QlikView ETL Workflows
Generate QVD files for QlikView from Excel, SQL, text, XML, QVX, and other sources using repeatable ETL workflows with validation.
Loading Data from Excel and Access Files
Advanced ETL Processor Reader Object is capable of extracting data from MS Excel files and MS Access databases. See it yourself, Download Advanced ETL Proces...
Loading Data Into a Data Warehouse: ETL Guide
Learn how loading data into a data warehouse works: extraction, cleansing, transformation, validation, loading, and automation with ETL software.
Load Data into SQL Server with BCP and ETL Automation
Load data into SQL Server faster with BCP bulk copy, batch size settings, constraints, staging tables, validation, and no-script ETL automation today.
Management Console Improvements
The latest release of our ETL software includes improved Management console. It was redesigned using bootstrap 4.This allows our users to work with managemen...
One day we will be able to process one million records per second
We did spend a lot of time optimizing our ETL software and here is what we were able to achieve so far: Loading data into Oracle database via direct path loa...
Run SQL Queries on Excel Files
What is the point? Yes, it is possible to Run SQL Against Excel but quite often it just does not work, for example "Total Pay" is missing from the last scree...
Say No to TypeGuessRows=0, IMEX=1, and Excel ODBC Bugs
TypeGuessRows=0 and IMEX=1 do not reliably fix Excel ODBC import bugs. Use Advanced ETL Processor to load Excel data without registry hacks.
Skipping ETL transformation execution on bank holidays
This article is here to help our banking clients 1. Create a table to hold the list of bank holidays CREATE TABLE [dbo].[BANK_HOLIDAS]( [BANK_HOLIDAY] [date]...
SSIS Alternative
Advanced ETL Processor is a powerful and feature-rich alternative to SSIS. Its advanced capabilities and intuitive design make SSIS look basic by comparison...
Star Schema Optimisation: Faster Data Warehouse Queries
Star schema optimisation guide for faster data warehouse queries: reduce fact table size, choose better keys, tune indexes, and load cleaner data safely.
Things to avoid while designing data transformations
When the transformer is connected to data writer it takes a list of fields from data writer, transformation below will work only if the list of fields from b...
Transform Paradox Tables
Based on the customer feedback in the latest version of Advanced ETL Processor we have introduced support for BDE. This allows loading data from Paradox and...
Transform SQLite data faster
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...
Transforming Syslog files
What is Syslog? Syslog is a standard for sending and receiving notification messages-in a particular format-from various network devices. The messages includ...
Upload files to Amazon S3 and Azure Blobs
Good news we have just added support for Amazon S3 Storage and Azure Blob to our ETL products. Supported Operations: Download and Upload Files, Create and D...
User interface improvements
A small but very useful cosmetic change: Read-only objects marked using the italic font
Using stored procedures to load data
Here is an example of how to load data using the stored procedure. Using this approach gives the user the ability to perform complex transformations inside t...
Working with large lists of values
Advanced ETL Processor's the “Is In List” validation function checks whether a value exists in a database or file. Although effective in many situations, it...
85 Tutorials and counting
Finally, after many weeks of testing a new release of Advanced ETL Processor is ready for download. This version includes more than 80 examples. Complete lis...
Add sheet from one workbook to another automatically
A new release of Advanced ETL Processor is ready for download. In this version, we have extended the functionality of the Excel Operation package action : It...
Advanced ETL Processor - 6.4.6
We’re pleased to announce version 6.4.6 of Advanced ETL Processor. In this release, we've added a highly requested feature: Reusable scripts. We've also add...
Advantages and Disadvantages of Using Cloud Based ETL Solutions
When evaluating data integration tools, many companies consider the advantages and disadvantages of using cloud based ETL solutions. Cloud ETL platforms off...
Automate working with Excel Files
Are you struggling to process too many Excel files manually? Do you want to automate working with Excel and save money? Contact us today and we will do our b...
Automatically process Apache Kafka messages
Advanced ETL Processor Enterprise version 6.3.10.0 is available for download In this version, we have added support for Apache Kafka messaging. Our ETL softw...
Automatically Process RabbitMQ Messages
Advanced ETL Processor Enterprise version 6.3.9.0 is available for download In this version, we have added support for RabbitMQ messaging. Our ETL software c...
Automating Entire Business Processes
When it comes to data integration and processing, Advanced ETL Processor emerges as a powerful tool that automates entire business processes. In this article...
Benefits of Using a Self-Hosted ETL Solution
When managing business data pipelines, one key decision is whether to use a cloud-based or self-hosted ETL tool. Understanding the benefits of using a self-h...
ChatGPT is wrong about ETL Software
User: Which software can convert QVD to TDE file? ChatGPT: There is no direct software that converts QVD (QlikView Data) files to TDE (Tableau Data Extract)...
Connecting to MySQL using SSH
Advanced ETL Processor Enterprise version 6.3.11.9 is available for download In this version, we have added Support for SSH Connections to MySQL, Postgres an...
Combining multiple data sources into a single excel file
A new version of Advanced ETL Processor is out with a much more anticipated new feature: the ability to work with multiple excel sheets within a single trans...
Creating Hyper Table
Use Advanced ETL Processor 64 bit to create a hyper table in four easy steps. 1. Open writer properties dialogue 2. Enter the new table name 3. Define Table...
Create Excel Files Automatically
If you frequently generate Excel reports or data exports, Advanced ETL Processor can save hours of manual work. It’s a powerful, self-hosted automation tool...
Convert Excel Dates
Question from the customer I have an excel file coming in with a row with a date formatted as DD-MMM. AETL is reading this as a String and not returning the...
Creating beautiful html tables
Advanced ETL Processor - 6.4.2.42 is ready for the users. A new version of Advanced ETL Processor is out with two more examples: 0098 Creating HTML Table 009...
Data Synchronization part 2
In the previous article, we demonstrated how easy it is to synchronize the data between different databases. The proposed approach has some disadvantages Wri...
Dealing with access violations
What is an Access Violation? Let's say for example we have two programs A and B. Access violation happens when program A tries to access memory reserved for...
Embracing Zero ETL: Revolutionizing Data Integration
Introduction Data integration plays a crucial role in modern organizations, enabling them to harness the power of their data for insightful decision-making...
ETL Tools Examples
Explore Practical ETL Workflows Discover how Advanced ETL Processor simplifies data integration tasks. Below are examples demonstrating its capabilities in v...
Excel file makes AI Cry
The Excel Challenge Imagine that you have an Excel file with 50 sheets, every one of them has 5-10 tables and your job is to load it into the database. There...
Extracting data from Tableau hyper files
through the Hyper API integration our ETL software can now read Tableau Hyper Data Extract (.hyper) files as a data source This applies to 64bit versions onl...
Floating ETL Designer Tabs
A new release of Advanced ETL Processor is ready for download. In this version, we have added the ability to detach tabs This feature was introduced based on...
Extracting MIME Data
What is MIME data MIME stands for Multipurpose Internet Mail Extensions. MIME is an Internet standard that extends the format of email messages to support te...
Generating ETL Documentation
Based on the customer feedback we have introduced the ability to save packages and transformations as bmp files. That makes creating ETL Documentation much e...
Generic REST API Writer
Advanced ETL Processor Enterprise version 6.3.11.7 is available for download In this version, we have added Rest API Writer Full list of changes: + Added: Re...
Extracting data from Excel sheets, tables and ranges
Advanced ETL Processor - 6.4.3.0 is ready for the users. A new version of Advanced ETL Processor with extended support for Excel: Add support for extracting...
How to Avoid Processing Data Files Multiple Times
Preventing duplicate processing of data files is crucial to ensure data integrity and efficiency in ETL workflows. Here are several strategies to avoid proce...
Integrating ChatGPT for Data Validation in ETL Workflows
Integrating ChatGPT for Data Validation in ETL Workflows We are currently assisting one of our ETL customers in integrating ChatGPT-powered data validation i...
How to Implement SCD Type 2 in SQL Server
Slowly Changing Dimension Type 2 (SCD Type 2) is a common data warehousing technique used to preserve historical changes in dimensional data. This article ex...
Introducing Dynamic Package Actions
Introducing Dynamic Package Actions We are currently in the process of adding Dynamic Package Actions to all our ETL Products , which come with four types of...
Monitor Office 365 Emails
Advanced ETL Processor Enterprise version 6.3.11.0 is available for download In this version, we have added Office 365 Monitor Usage example: Full list of ch...
No software is perfect
When we initially developed our ETL Software , we made certain design decisions that we later reconsidered. One of these was the handling of variables. While...
Office 365 Email Reader
Advanced ETL Processor Enterprise version 6.3.11.2 is available for download In this version, we have added Office 365 Email Reader Why it is important: Micr...
Real Life ETL Example
In this real life ETL example , we’re not talking about fancy data fabrics, data lakes, or trendy buzzwords. We’re talking about something simple - but effec...
Reporting Engine Update
We have updated Reporting Engine in all our ETL Products. Changes are: Added Ability to Embed PDF files into Report Added Combo Box Report Object Added List...
Tableau hyper upload testing
The problem One of our customers was having problems publishing tableau hyper files to the tableau online server. We asked them to grant us access. That was...
The total number of workflow actions has now reached 136
The total number of workflow actions has now reached 136 In the latest version of Advanced ETL Processor (6.4.5.9 - 03/02/2025) , we have introduced several...
The Ugly Truth About AI
Everyone’s talking about AI, but the Ugly Truth About AI is that results only look magical after a lot of careful, boring groundwork. On real projects-like p...
Translate Documentation with Confidence
If you’re exploring Translating Documentation Using LLM , this guide shows how to do it quickly, safely, and repeatably with Advanced ETL Processor. As an I...
Updating large Excel files
Performance tip When working with a very large Excel file untick "Recalculate Excel file". Most of the time it is not necessary and for the large files, it m...
Upgrade today to take advantage of AI-Powered ETL
Integration with Google Gemini AI - Advanced ETL Processor Enterprise Version 6.4.5.14 This release adds support for Google Gemini AI , expanding the AI-driv...
Use Microsoft Graph API to process office 365 emails
Advanced ETL Processor - 6.3.8.0 is ready for the users. A new version of Advanced ETL Processor is out with a much more anticipated new feature: the ability...
User fields
Based on the customer feedback we have user fields to properties dialogues. Package example Repository upgrade script Complete list of changes 13/06/2022 6.3...
AI-Powered PDF Data Extraction & ETL Automation Tool
The Problem Extracting data from PDF documents-especially complex or form-based PDFs-can be frustrating, time-consuming, and unreliable. These documents ofte...
Using Get Excel cell value transformation function
Workflow There two transformation functions dedicated to working with Excel cells "Get Excel cell value" and "Get Excel cell value dynamic". They work in a d...
Using OAuth 2.0 to work with Microsoft Email
A number of our customers have contacted us regarding working with Microsoft email servers. The problem Microsoft has recently disabled access via IMAP4, POP...
Why Securely Deleting FTP Files is Important
If your team moves data via FTP/SFTP, securely cleaning up files after ingestion isn’t optional-it’s essential. With Advanced ETL Processor, you can automate...
What is wrong with the XML
Extracting data from XML can be a very complex task, but the complexity of this task depends on people who design XML in the first place. In this article, we...
Working with HTML table
Extracting data from HTML tables Transforming HTML tables can be a real challenge. First of all HTML document can have multiple tables, Than a table might ha...
Why we created Dynamic Actions
As you may be aware, no software is perfect-including ours. When we initially developed our ETL software, we made certain design decisions that we later came...
Major Release of Advanced ETL Processor 6.4.0.0
Advanced ETL Processor - 6.4.0.0 is ready for the users. A new version of Advanced ETL Processor is out with a much more anticipated new feature: Block trans...
New Deep Bin release
Changes are: Overall look and feel improvement Third-party components update. Type-ahead inputs work much better now My Details, Settings and Change Password...
CHOOSING THE BEST ETL SOFTWARE IN 2024
The best thing about being in business today is there are so many tools and software available for practically every function and aspect of your business. An...
Tired of SSIS
Advanced ETL processor vs SSIS - Development Efficiency against wasting time Many organizations rely on SSIS (SQL Server Integration Services) for data integ...
IMEX=1
Solving Excel Data Import Issues in ETL Workflows Common Issue: When importing data from Excel, columns sometimes return nulls or long text values get trunca...
Choosing the Best ETL Software with AI Integration in 2025
Today’s businesses rely on a wide array of digital tools to manage operations-Salesforce, Google Analytics, HubSpot, Marketo, Zendesk, and more. The challeng...
What is ETL?
Extract, Transform, and Load (ETL) is a key data integration process used to consolidate information from various sources into a centralized system known as...
How to enable TLS 1.2 for SQL Server Connections
all our ETL products support TLS 1.2 now. To make it work you have to enable TLS 1.2 and disable the rest of the protocols (on the server and client) We reco...
Advanced ETL Processor - 6.4.5.47
A new version of Advanced ETL Processor is now available. In this release, we've added a highly requested feature: a mailbox folder selection dialog for emai...
Advanced ETL Processor - 6.4.5.52
We’re pleased to announce version 6.4.5.52 of Advanced ETL Processor. In this release, we've added a highly requested feature: Posting Messages to MS Teams...
Advanced ETL Processor Enterprise version 6.4.5
Major Release: Advanced ETL Processor Enterprise This release introduces substantial enhancements to dynamic package actions, making them more intuitive and...
Transition to New Payment Partner
Transition to New Payment Partner Customer notice We would like to inform you that we are in the process of transitioning our payment processing partner from...
New URL Logger release
URL logger version 1.1.0 is available for download Changes are: Export to Excel Import From Excel Addressed sorting issues Customisation using JSON files Abo...
Process webhook data
Url Logger - 1.0.4 is ready for the users In this version we have added support for custom script execution. This opens a whole new world of possibilities, f...
9 new products
We have just launched 9 new products And the most exciting news is that All of them work on both Windows and Linux. Please get in touch with us if you want t...
Webhooks
A new release of URL Logger is ready for download. In this version, we have improved the setup process and added email notifications What are the webhooks: I...
New release of Active Table Editor
Active Table Editor 64-bit version is available for download About Active Table Editor Active Table Editor allows the administrator to log in and design the...
Advanced ETL Processor - 6.3.7.10
Advanced ETL Processor - 6.3.7.10 is ready for the users. New data source "HTML Table" and new package action "Extract MIME Data" Other changes are: Added: H...
Wiki Update
our new Documentation WIKI is officially available to everyone Visit Wiki Site
Database Browser version 5.3.3.1
Database Browser version 5.3.3.1 is available for download Changes are: Added support for SSH Connections to MySQL, Postgres and MongoDB Redesigned Database...
Q-Eye 6.5.1.0
A new version of Q-Eye is available for download: In this version, we introduced the ability to filter and sort data. Download Q-Eye
Q-Eye 6.5.0.10
A new version of Q-Eye is available for download: In this version, we introduced the ability to delete marked records. Download Q-Eye
New version of Licensing Server
Changes are: Third-party components update My Details, Settings and Change Password screens converted to modal dialogues for user convenience About: Licensin...
Licensing Server version 2
Licensing Server version 2 is available for download. It is our first product that works on Linux. More products to follow. Note: Licensing server is usually...
Q-Eye version 6.5.0.9
Q-Eye version 6.5.0.9 is available for download Changes are: Improved: Look and feel Added: New themes Office 2016 White, Office 2016 Gray and Office 2016 Bl...
Advanced ETL Processor - 6.3.7.14
Advanced ETL Processor - 6.3.7.14 is ready for the users. A new version of Advanced ETL Processor is out with a much more anticipated new feature: the abilit...
No articles match the current filter.