News

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

    Screenshots

    {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
  • Removed tables

    AGENT_ACTIVITY,AGENT_STATUS

    New tables

    EVENT_MONITORS holds data about Event Monitors
    NODES Holds metadata information about the computer where software is installed and running
    NODES Holds metadata information the software installed on the computer, used pause execution

    Modifications

    Following fields were removed from QUEUE and QUEUE_HISTORY tables

    NUMBER_OF_EXECUTIONS,APPLICATION_NAME,EXECUTE_ON_COMPUTER and COMPUTER_TO_EXECUTE_ON

    Following fields were added to QUEUE and QUEUE_HISTORY tables

    APPLICATION_SUBMITTED,APPLICATION_EXECUTED and APPLICATION_EXECUTED_PLATFORM

    EXECUTE_ON_COMPUTER was removed from SCHEDULE table and APPLICATION_PLATFORM was added

    Download Free Trial Learn More About Our ETL Software
  • The new version of Advanced ETL Processor Enterprise is available for download

    In this version, we concentrated on fixing small bugs and extending the functionality of Management console

    management console

    Other changes are:

    + Added: Event monitors editor to Management Console
    + Added: Incremental Search to Object Selector to Management Console
    + Improved: Restoring backups (Some users add fields to repository tables and that led restore failures)
    + Improved: Look and feel of Pivot object on win2008 server
    + Improved: Look and feel of UnPivot object on win2008 server
    + Improved: Look and feel of Application options dialogue on win2008 server
    + Improved: Look and feel of Smtp connection dialogue on win2008 server
    + Improved: Object Selection Dropdown always shows the correct icon now (Scheduler Dialogue and Event Monitor Dialogue)
    + Improved: Removed "Every" field from event_monitors table
    + Improved: Third-party components update (Data Grid)
    + Improved: Empty Data Grids show the message
    + Improved: Execution log within Package editor looks the same way as execution log (Tree)

    Download Free Trial Learn More About Our ETL Software
  • 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
  • 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:

    <table>
    <record>
    <field1>value1<field1>
    <field2>value2<field1>
    <record>
    <record>
    <field1>value1<field1>
    <field2>value2<field1>
    <record>
    <table>

    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
  • 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

  • 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
    
  • 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;
    *.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;
    *.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;
    *.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;
    *.otg;*.odp;*.otp;*.odf;*.odb
    BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
    7z archive *.7z
    Tar archive *.tar
    GZip archive *.gz;*.gzip;*.tgz;*.tpz
    Swf archive *.swf

    for decompression

  • 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

    Direct link, no registration required.
  • Today we have great news indeed: Both Visual Importer ETL and Advanced ETL Processor can publish tde files to Tableau server now. That will please a lot of Tableau fans.

    tableau partner

    Publish Tableau File  Other changes are:

    • Added:   Tableau Server Connection
    • Added:   Publishing Tableau TDE files
    • Improved: Updated Tableau Client

    Download Free Trial Learn More About Our ETL Software
  • 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
  • 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
  • The latest release of our ETL software is using SQLite as a repository backup database.

    Following products are affected:

    • Advanced ETL Processor Ent and Pro
    • Visual Importer ETL Ent and Pro
    • Active Table Editor

    If you have just updated the software we recommend making repository backup immediately.

     As a result of format change backup and restore operations are must faster.

    Repository Synchronization Wizard can use the backup as a source for Synchronization

    This allows to create standard solutions and sell them to the end-users. They can be easily updated later when necessary.

    Backup

    Direct link, no registration required.
  • Starting from the middle of March 2019 users would need to enter the license code and control number to register the software.

    Registration1

    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.

  • 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
  • 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
    (OBJECT_TYPE,OBJECT_TYPE_NAME)
    Values
    ('911','Telegram Connections');

    Insert into OBJECT_TYPES
    (OBJECT_TYPE,OBJECT_TYPE_NAME)
    Values
    ('912','Telegram Connection');

    INSERT INTO OBJECTS_TREE
    (OBJECT_ID,
    PARENT_ID,
    NAME,
    OBJECT_TYPE
    )
    Select
    OBJECT_ID*-6 as OBJECT_ID,
    PARENT_ID,
    'Telegram' as NAME,
    911 as OBJECT_TYPE
    From
    OBJECTS_TREE
    where OBJECT_TYPE=320

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

    Direct link, no registration required.
  • 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.

  • 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

  • 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 is Elite QlikTech partners offering development, installation, training, and support for QlikView Business Intelligence software.

    Differentia Consulting becomes a partner of ETL-Tools.com

    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.

Page 1 of 4

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies