Process 12 million records in 37 seconds (20+ Percent faster than previous version)

A ETL PerformanceBoost

Start my 30-day free trial

(One click download, no registration required)

Great news we have just become Tableau Tecnology Partner. This is a result of  continued Tableau integration work.

TableauPartner

Our ETL Software  can be used for creating  and publishing Tableau TDE files

We also offer free licences to Tableau ZEN Masters

tableau partner

Introduction

Our software can read and create QVD files, We spend a lot of time making sure that it works as expected.

The Problem

But there is a problem: reading date fields. Our software assumes that if there is tag $date or $timestamp it is a date field. However quite often this assumpltion is wrong.  It is just telling us that it is possible to prepresent the data as date value and it does not necessaraly mean that it is actually a date field.

Tutorials

How Datetime data is stored

Datetime fields are strored as a number, 12/01/2015 and 12-01-2015 look different but intrenal numeric representaion is the same

Numeric representation of date field

The Solution

In the latest release od Advanced ETL Processor we added new option "Ignore Format". When selested data is always interpreted as a number

Ignore Format Option

Visit Support Forum Learn More Download Buy It

Removed tables

AGENT_ACTIVITY,AGENT_STATUS

New tables

EVENT_MONITORS holds data about Event Monitors
NODES Holds metadata information about 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

 

Customer Loyalty Programs

 

A Free License for IT Professionals

Send us a link to your profile and get a free license for any ETL product!

suit up
Promote our ETL Software

You can get a significant discount, and even a free license, by spreading a word about our ETL Software.

chat
Competitive Upgrades

Get 50% OFF for switching to our ETL Software from competing tools!

money

Go to top