Here you will find the latest news and articles about our ETL Software

Our WIKI has all the information you need, if you are stuck, please post your question on our support forum and we will do our best to assist you

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

A ETL Performance Boost

Download Free Trial Learn More About Our ETL Software

Monitoring Directories for New files

Directory Monitor is windows service which executes predefined action when new file is added to the directory. Both local directories and network shares (using UNC path) can be monitored.

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

Download Free Trial Learn More About Our ETL Software

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

Download Free Trial Learn More About Our ETL Software

We have 178 guests and no members online