Cloud Storage

  • Good news we have just added support for cloud storage to our ETL products.

    Supported Cloud Storage Operations: Download and Upload Files, Create and Delete Folders, List files.

    Download Advanced ETL Processor Enterprise now!

    Online storage systems, or “cloud” services as they're also known, allow you to store digital media online by uploading via your computer or mobile device. Though transferred and accessible via the web, the data is actually physically held in datacentres located around the world, often owned by whoever provides the particular service you use (Google, Microsoft or Dropbox).

    Following clod storage providers are supported:

    1. DropBox
    2. Google Drive
    3. Microsoft OneDrive
    4. Box
    5. Amazon Cloud Drive
    6. Hubic
    7. HiDrive
    8. Yandex disk

    Cloud Storage Action

    The cloud storage action dialogue allows the end user to define package action properties. It also allows browsing , downloading and uploading files and works with directories.

    Cloud Storage 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 I do.  The cloud storage dialogue make my life much easier

    Tom Barker, 
    Director of Information Technology

    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 cloud storage connection

    Insert into OBJECT_TYPES
    (OBJECT_TYPE,OBJECT_TYPE_NAME)
    Values
    ('905','Cloud Storage Connection')

    Insert into OBJECT_TYPES
    (OBJECT_TYPE,OBJECT_TYPE_NAME)
    Values
    ('906','Cloud Storage Connections')

    INSERT INTO OBJECTS_TREE
    (OBJECT_ID,
    PARENT_ID,
    NAME,
    OBJECT_TYPE
    )
    Select
    OBJECT_ID*-4 as OBJECT_ID,
    PARENT_ID,
    'Cloud Storage' as NAME,
    905 as OBJECT_TYPE
    From
    OBJECTS_TREE
    where OBJECTS_TREE.OBJECT_TYPE=322

    UPDATE OBJECT_TYPES
    set OBJECT_TYPE_GROUP=24000
    WHERE OBJECT_TYPE= '905'

  • 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 214 guests and one member online