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 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'

In a lot of organizations, Excel is everywhere and Excel is everything. It is extremely important for modern ETL tool to work with Excel correctly.

Of all Microsoft Office applications, Excel is one of the most important ones for all kind of businesses. This is because it provides an enormous capacity to perform everything from simple day to day operations to complex statistical analysis. It comes packed with lots of useful formulas, charts and other tools that simplify the process of recording, analyzing and performing calculations of data. This is the reason why it is used daily in millions of workplaces all over the world. Almost everyone who deals with data has used the Excel interface at some point. 

Our software can process and create Excel files automatically, the possibilities are limitless

Download Advanced ETL Processor Enterprise now!


Loading Data from excel file

We worked with a lot of finance and accounting companies and the first question they always ask: How do we export the data to Excel?

How our ETL software work WITH excel as data-source

To harness the full power of Excel, you need to have an ETL tool that is capable of handling input from Excel files. Owing to the many ways you can use Excel to achieve your desired results, you need an ETL tool that is flexible enough to understand the different ways data can be processed. This is where our Advanced ETL Processor really shines. It is able to work with Excel as a data source and take inputs from Excel files depending on your specific preferences. Here are some of the things you can do with this ETL tool:

  • Use a mask to load data from multiple Excel files
  • Use a mask to load data from multiple Excel sheets
  • Use a mask to load data from multiple excel ranges
  • Skip the header and footer in the Excel file
  • Read a single cell from an Excel file
  • Accurately read data from Excel 100% of the time
  • No need to install additional drivers to read Excel data

This ETL software is built by people experienced in managing data warehouses hence you can be sure that it comes packed with features that you will actually use in your day to day operations. Whatever you need to get data from Excel files, you will find it in our Advanced ETL Processor.

Using Excel as a data target

In addition to allowing you to get data from Excel, our Advanced ETL Processor enables you to export data to Excel files. Once again, this tool is designed to give you full functionality when you need to Export data to Excel. Whether you are looking to create a new Excel file for your data or you want to add the data to an existing file, the Advanced ETL Processor is all you need. Here are some of the things you can do with it when using Excel as a data target:

  • Create a new Excel file with your data
  • Insert the data into an existing Excel file
  •  Clear an Excel sheet or range
  •  Append data to an Excel file
  •  Choose the cell where you will start adding data on an existing Excel sheet
  •  Replace data in an excel sheet with new data

Generating excel file

Workflow operations

In addition to the above data operations, you can also perform a number of workflow operations on Excel sheets. Here are some of the operations that you can perform:

  • Check if the sheet is present within excel file
  • Delete a sheet on an Excel file
  • Rename a sheet in an Excel file
  • Insert an empty sheet
  • Check an entire Excel file

Whatever data operations you want to do on Excel files, our Advanced ETL Processor will help you do it easily and effortlessly. Click the button above to download it for free and try out some of the amazing features.
The Advanced ETL Processor is the ultimate ETL tool when it comes to working with Excel files.

Excel operation

GREAT PERFORMANCE - THOUSANDS OF RECORDS PER SECOND

Loading Data from excel file Thousands of Records Per Second

TRANSFORM EXCEL FILES - ANY WAY YOU WANT

Advanced ETL Processor has more than 500 transformation and validation functions. if something is missing we will add for you. Data can be sorted grouped and filtered, the possibilities are limitless. 


Transform Excel files anyway you want

 COMPLETE EXCEL FILES PROCESSING AUTOMATION

Advanced ETL Processor offers varions automation actions such as: file operations, email processing, FTP operations, compression and even encription. 

Automate Excel Attachments Processing

Contact us now!

Related Articles

VIDEO TUTORIAL

Download Free Trial Learn More About Our ETL Software

All our ETL products support TLS 1.2 now.

That does not mean that the software is actually using it.

To enable you have to install a lot of patches from Microsoft. they must be installed on both the client and the server.

https://support.microsoft.com/en-gb/help/3135244/tls-1-2-support-for-microsoft-sql-server

Then you have to enable TLS 1.2 and disable the rest of the protocols (on the server and client)

We recommend using IISCripto for it

https://www.nartac.com/Products/IISCrypto 

iiscrypto

And the last step is to reboot the computer

Download Free Trial Learn More About Our ETL Software

Latest versions of Advanced ETL Processor  and Visual Importer ETL loads data up to two times faster

Old version:1640 records per second:

Old Version

 New version:4091 records per second:

New Version

Note: Only If your table has TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX), XML, IMAGE or BINARY(MAX) fields. 

Download Free Trial Learn More About Our ETL Software
Here is a basic example of creating a temporary folder

The Script calculates directory name and saves it into a variable. The variable than used to create the directory

temporary folder package

temporary folder script

begin
SetVariable('',GetTemporaryDirectory('c:\tmp'));
Result:=True;
end;

temporary folder file operation

Full List of "temporary" functions:

GetWindowsTemporaryDirectory

The GetWindowsTemporaryDirectory function returns windows temporary path.

GetTemporaryFile(Extension)

The GetTemporaryFile function returns a temporary file path. The file is located in windows temporary directory

GetTemporaryFileInDirectory(Directory,Extension)

The GetTemporaryFileInDirectory function returns temporary file path. The file is located in the directory

GetTemporaryDirectory(Directory)

The GetTemporaryDirectory function returns a temporary directory name in a specified directory

WIKI ARTICLEs:
Download Free Trial Learn More About Our ETL Software

We have 204 guests and one member online