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

 

We have 200 guests and no members online