• Advanced ETL Processor - Themes

    {multithumb enable_thumbs=0}Latest version of Advanced ETL Processor introduces support for themes


    {multithumb enable_thumbs=1 num_cols=4}Click on thumbnail to see the screenshot

    mt_gallery:Advanced ETL Processor Themes

    Download Free Trial Learn More About Our ETL Software
  • Advanced ETL Processor generates GUID's

    The new version of Advanced ETL Processor introduces support for GUID generation, Random number generation, and base 64 Encoding/Decoding.

    GUID generation A globally unique identifier (GUID) is a unique reference number used as an identifier in computer software. The term GUID also is used for Microsoft's implementation of the Universally Unique Identifier (UUID) standard.

    The value of a GUID is represented as a 32-character hexadecimal string, such as {21EC2020-3AEA-1069-A2DD-08002B30309D}, and is usually stored as a 128-bit integer. The total number of unique keys is 2128 or 3.4×1038. This number is so large that the probability of the same number being generated randomly twice is negligible.
    Random Number Generation Random returns a random number within the range 0 <= X < Range
    Encode Base 64
    Decode Base64
    Base64 is a group of similar encoding schemes that represent binary data in an ASCII string format by translating it into a radix-64 representation. The Base64 term originates from a specific MIME content transfer encoding.

    Base64 encoding schemes are commonly used when there is a need to encode binary data that needs to be stored and transferred over media that are designed to deal with textual data. This is to ensure that the data remains intact without modification during transport. Base64 is commonly used in a number of applications including email via MIME, and storing complex data in XML.
    Download Free Trial Learn More About Our ETL Software
  • Advanced ETL Processor performs XSLT transformations

    Great news Advanced ETL Processor support XSLT transformations now

    A lot of XML files have very complex structure and XSLT allows to transform the data into more readable format:


    XML can be transformed before loading the data or if user wants to process/validate XML which is stored in the database field two new data transformation functions can be used

    XML Transfomation Functions

    XML Editor

    We would like to thank our customers for providing useful feedback

    Download Free Trial Learn More About Our ETL Software
  • Annoncing Active Table Editor - Version 5

    After months of hard work  Active Table Editor version 5 is available for download. It introduces an enormous amount of useful changes, improvements and bug fixes:

    •  New repository structure compatible with Database browser, Advanced ETL Processor and future release of Visual Importer ETL
    • Individual menu item sorting
    • Linked Reports
    • Ability to print individual records
    • Various bugs fixes and improvements

    Upgrading Repository

    Support will provide assistance to existing customers who pay for support and maintenance.

    Reporting problems

    Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

    New version of Active Table Editor

  • Auto Complete Function

    Based on our user's feedback in the latest version of Visual Importer ETL we introduced  "Auto Complete Function",the rest of the products to follow.

    Auto Complete Function

    Following forms and dialogs support now Auto Complete Fuction: Table Browser, SQL Before, SQL After, Calculation, Expression Builder
  • Automatic File Decompression

    Advanced ETL processor provides extended support for automation of comression and decompression operations , it supports wide range of archive file formats such as

    for compression

    Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;
    BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
    7z archive *.7z
    Tar archive *.tar
    GZip archive *.gz;*.gzip;*.tgz;*.tpz
    Swf archive *.swf

    for decompression

  • Automatic log and repository maintenance

    Keeping an eye on ETL logs is extremely important, over time they can become too big and consume a large amount of disk space. Clear log action is here to help our users to address this problem.

    clear log action

    clear log action variables

    We would like to thank you Todd Mathews from Ims fast pak for providing us with useful feedback

    Download Advanced ETL Processor Enterprise now!
  • Bulk load data into Microsoft SQL Server Compact

    Advanced ETL Processor offers full support for Microsoft SQL Server Compact Edition.

    Users can now perform complex transformations of Microsoft SQL Server Compact Edition data, Import, Export, Transform and Validate any data with ease.

    About Microsoft SQL Server Compact

    SQL Server Compact 3.5 SP2 is a free, easy-to-use embedded database engine that lets developers build robust Windows Desktop and mobile applications that run on all Windows platforms including Windows XP, Vista, Pocket PC, and Smartphone.

    Available on both 32-bit and x64 platforms, SQL Server Compact 3.5 helps you drive new levels of performance within your organization through data.

    Download Free Trial Learn More About Our ETL Software
  • Case package Action

    Based on our user's feedback in the latest version of Visual Importer ETL we introduced  "Case package Action"

    That makes it possible to execute different work-flow action depending on variable value.

    Using Case Action

    Download Free Trial Learn More About Our ETL Software
  • Changes to software registration process

    Starting from the middle of March 2019 users would need to enter the license code and control number to register the software.


    We used a very old licensing system and we wanted to change it for a very long time. License type can be now clearly seen on the about box and maintenance tab. This change applies to all our software products.

  • Clone row

    New data transformation function creates copies (clones) of a row and outputs them directly after the original row to the next steps.

    Clone Row

    Clone row properties Dialog

    Clone Row Properties

    Download Free Trial Learn More About Our ETL Software
  • Creating Telegram bots

    The latest version of our ETL Software support reading and posting Telegram messages using Bot API. This opens a new window of opportunity for chat automation.

    Usage example:

    Note: The user must talk to the Bot first

    Telegram package

    Upgrade procedure

    You would need to run the following SQL against the repository to enable Telegram connections 

    Insert into OBJECT_TYPES
    ('911','Telegram Connections');

    Insert into OBJECT_TYPES
    ('912','Telegram Connection');

    'Telegram' as NAME,
    911 as OBJECT_TYPE
    where OBJECT_TYPE=320

    We would like to thank Vassalli from Galvolux for providing us with useful feedback

    Download Advanced ETL Processor Enterprise now!
  • Data Import Wizard

    New version Database Browser is available for download. In this version we have introduced data import wizard.

    Data Import Wizard

    About Database Browser

    This easy to use tool allows the user to connect to any database and browse or modify data, run SQL scripts, export and print data. And the most important thing it is Free-ware.

  • Database browser version 4.0

    A new version of Database browser is available for download

    In this release, we have introduced support for tabs

    Support for tabs

    A full list of changes

    + Support for multiple tabs
    + Connections and Execution history are stored in a separate database now
    + New connection dialogue
    + Comments for connections
    + Create date, update date and user name information for connections

  • Debugging data transformations

    A new version of Advanced ETL Processor is available for download

    In this release, we have introduced debugger and greatly enhanced the development of Data transformation packages

    New SQL execution log

    A full list of changes

    + Package debugger was introduced
    + Breakpoints were introduced
    + Execute single package object option was introduced
    + Project Tree View -  COLLAPSE/EXPAND buttons were added
    + More generic log viewer
    + Ability to group packages, SQL scripts reports, and emails was added
    + Package objects have objects tree for the selection now
    + Execution agent writes startup error messages in the log file
    - Disappearing tree nodes problem was addressed
    - "Progam" file was created on drive c
    - Double attachments
    - XML XSLT transformation fix
    - Some auto format issues were addressed
    - Minor interface tweaks
    - Addressed issues related to running execution agent on win64

    Great work! That might be a World’s Record for publishing a new version of a major application.

    Download Free Trial Learn More About Our ETL Software
  • Differentia Consulting becomes a partner of

    Differentia Consulting is Elite QlikTech partners offering development, installation, training, and support for QlikView Business Intelligence software.

    Differentia Consulting becomes a partner of

    Differentia Consulting has provided consulting, solutions, resourcing, support, and training services to many different clients since 2002. We are long standing partners of IBM and Oracle, and a QlikView Elite Solution Provider with QlikView customers from all sectors and core technologies (Oracle, SAP, Infor, IFS, Microsoft, SAGE, Siebel, SalesForce, SugarCRM, etc). Differentia Consulting has an ERP heritage; however,  the company has expanded into the agile analytics space both from a software resale and value add consulting perspective

    Differentia Consulting has an excellent reputation for enabling organizations to improve their performance primarily through the analysis of existing business problems and the development of plans for improvement utilizing disruptive and Lean IT tools such as QlikView.

  • ETL Version Control why you need it

    We do a lot of consultancy work and we decided to introduce version control after one of our customers modified transformations beyond use. Version control helped us to restore the project to its original state. Another situation when version control is very useful is a large project with multiple developers.

    Advanced ETL Processor version control tab

    More about ETL-Tools

    Latest ETL Software changes

    + New Version control tab was introduced
    + Version control can submit several objects now
    + Version control dialogue can delete multiple objects now
    - Various bug fixes

    Download Free Trial Learn More About Our ETL Software
  • ETL with support for dynamic file names

    Another improvement in our ETL Software

    If you used our ETL tools for a while you know it is possible to load data from multiple files or even tables using a mask.
    How you can save data into separate files using the source file name as a part of the target file

    • {GetSystemVariable('SOURCE_FILE_NAME')+'.good'}
    • {GetSystemVariable('SOURCE_FILE_NAME')+'.very_very_bad'}

    Advanced ETL Processor Screenshot

    ETL with Dynamic File Names

    We would like to thank Steve Vaughn from Meridian Enterprises   for the most useful feedback

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now

  • Fields Selector Transformation

    New version Advanced ETL Processor is available for download. In this version, we have introduced "Fields Selector Transformation".

    It allows the user to choose which fields to pass to the next transformation step

    Fields Selector

    We would like to thank our customers for providing useful feedback

    I have to work with very wide files 1000+ columns (satellite data capture) and I only use a few of them for the transformation. I asked DBSL to add the ability to select fields to process and they did it for me in 2 days. I wish more companies worked like this

    Download Free Trial Learn More About Our ETL Software
  • Getting Started with ETL

    In the latest version of Advanced ETL Processor, we have introduced 20 new data transformation examples. Everyone knows how difficult it is to get started with a new tool. These demos will help you to became Datawarehousing Expert in no time.

    ETL Transformation Editor

    1. Adding Footer Lines
    Demonstrates how to insert new lines after the last line in the group
    11. Compare Two Files
    Creates a new file which holds new and changed lines
    2. Create XML file using functions
    Demonstrates creating XML files using functions
    12. Create XML files
    Demonstrates creating separate XML files for every single record
    3. Creating a list of processed files
    Files are processed using mask example has two data writes one writes transformed data another creates a list of processed files together with the number of records
    13 Database to images
    Saves blobs into separate files
    4. Dynamic file names
    Multiple files are validated, for every file two output files are created with good data and bad data.
    Source file name is the part of output file source_file.txt => source_file.good_data => source_file.output_data
    14. Excel to access
    Loads data from excel with multiple data files unlike DTS or SSIS data is loaded  correctly
    5. Generate inserts
    Create SQL insert statements using a text file as a data source
    15. Generating records
    Demonstrates generation records using Pivot another way of doing is to use clone row transformation
    6. Grouper
    Data grouper demo
    16. Images to database
    Loads images into a database blob field

    7. Multiple Source Files
    Demonstrates using calculation together with variables in dynamic file generation.

    17. Lookup demo
    Simple lookup transformation

    8. Pivot example 18. Reading XML file
    XML file processing
    9. Previous value
    Demonstrates using calculations and running totals
    19. Simple Transformation
    Basis data transformation sample
    10. Sorting data
    Simple sorted demo
    20. UnPvot
    Demonstrates working with unpivot data transformation
    Download Free Trial Learn More About Our ETL Software

We have 298 guests and one member online