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

Good news we have just added support for Amazon S3 Storage and Azure Blob to our ETL products.

Supported  Operations: Download and Upload Files, Create and Delete BASKETS/CONTAINERS, List files.

Download Advanced ETL Processor Enterprise now!

+ Added: Support for Amazon S3 and Azure Blobs
+ Added: Amazon S3 operations: Download, upload and delete files, Create and delete baskets, Download basket files List
+ Added: Azure blob operations: Download, upload and delete files, Create and delete containers, Download container files List
+ Improved: Third party components update:

Report generator
Excel processing libraries
Cloud libraries
Text conversion libraries

+ Improved: Various bug fixes and improvements
+ Fixed: FTP errors when working with very large files
- Fixed: Repository Synchronization dialogue issues with MongoDB
- Fixed: Used by dialogue issues with MongoDB
- Fixed: Excel data reading problems

Amazon S3 Action

The Amazon S3 action dialogue allows the end user to define package action properties. It also allows browsing, downloading and uploading files and works with baskets.

Amazon S3 Action

This dialogue demonstrates a different attitude towards developers (end users). In fact, this is how development should be done. A lot of companies create MVP and nothing else. More than they are not willing to make it any better as long as management is happy to buy the software they are happy with the product. The problem is that Managers do not use the software the developers do.  This dialogue makes their life much easier.

AZURE BLOB Action

azure blob

The "how to connect" guides can be found here

www.etl-tools.com/wiki/knowledgebase/start

Upgrade procedure

You would need to run the following SQL against the repository to enable Amazon and Azure connections 

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('907','Amazon Connection')

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('908','Amazon Connections')

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('909','Azure Connection')

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('910','Azure Connections')

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=25000
WHERE OBJECT_TYPE= '907' --Amazon Connection

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '908' --Amazon Connections

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '909' --Azure Connection

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '910' --Azure Connection/

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-5 as OBJECT_ID,
PARENT_ID,
'Amazon' as NAME,
907 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-6 as OBJECT_ID,
PARENT_ID,
'Azure' as NAME,
909 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322

 

What is Syslog?

Syslog is a standard for sending and receiving notification messages–in a particular format–from various network devices. The messages include time stamps, event messages, severity, host IP addresses, diagnostics and more. In terms of its built-in severity level, it can communicate a range between level 0, an Emergency, level 5, a Warning, System Unstable, critical and level 6 and 7 which are Informational and Debugging.

Here is a simple Syslog example:

syslog example 

How our ETL-Software can process Syslog files?

Syslog is just Utf8 text file with LF as an end of line delimiter. Both Advanced ETL Processor and Visual Importer ETL can read Syslog files using dedicated reader. We recommend using Advanced ETL Processor because it gives more flexibility. 

Advanced ETL Ppocessor processing syslog file

Download Free Trial Learn More About Our ETL Software

A Small but very useful cosmetic change: Read-only objects marked using the italic font.

ReadOnlyImprovments

Download Free Trial Learn More About Our ETL Software

If you are unable to register the software try running it as administrator.

 Registration3

Registration1

Registration2

Download Free Trial Learn More About Our ETL Software

The user may receive the message above after installing 64 version of our ETL Software. This is because by default 64 bit OLE driver for MS Access is not installed on Windows. Although it is possible to install 64 bit OLE driver for MS Access by using our software we strongly recommend against it. The best course of actions is to use a proper database as repository such as MS SQL Server or Oracle.

Installing MS Access Runtime

During setup, our software will install Access runtime if selected

Installing 64-bit Access runtime on the computer where 32-bit version of MS office is already installed will lead to problems working with MS office (Repairing MS Office installation message).

CREATING REPOSITORY DATABASE

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

We have 302 guests and no members online