Great news we have just become Tableau Technology 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 assumption is wrong.  It is just telling us that it is possible to represent the data as date value and it does not necessarily mean that it is actually a date field.

Tutorials

How DateTime data is stored

Datetime fields are stored as a number, 12/01/2015 and 12-01-2015 look different but internal numeric representation is the same

Numeric representation of date field

The Solution

In the latest release of Advanced ETL Processor, we added new option "Ignore Format". When selected 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

The procedure as follows

  • Stop execution agent
  • Make a repository backup using latest release of Advanced ETl Processor Ent/Pro version 5
  • Install Advanced ETl Processor Ent/Pro version 6
  • Create Brand New repository and connect to it
  • Restore repository backup

We recommend to use separate computer for testing first

We have 402 guests and no members online