Manage updates with the Download AppPublisher's Description
From DB Software Laboratory:
Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.
Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.What's new in this version: Version 3.7.0.10 has format field name dialogue improvements.
More Products to Consider
-
View, navigate, and print PDF files.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Take an open-source approach to office productivity.DownloadInstalled
Smart Install -
Convert Adobe PDF file to MS Word file format.DownloadInstalled
Smart Install -
Open, edit, and save files using the new file formats in 2007 v...DownloadInstalled
Smart Install -
Create and share content with the help of a comprehensive set o...Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Automate loading data into Oracle, SQL Server, ODBC from flat f...DownloadInstalled
Smart Install -
Convert PDF files to Microsoft Word format.DownloadInstalled
Smart Install -
Perform multi-dimensional analysis with dynamic SQL generation.DownloadInstalled
Smart Install -
Keep track of how you use your PC.DownloadInstalled
Smart Install -
Let your business benefit from the e-commerce convenience.DownloadInstalled
Smart Install -
Create, view, edit and share word, spreadsheet and presentation...DownloadInstalled
Smart Install - Transform the data to fit your needs and load it into your data...Download
This download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install - Learn to use Microsoft Office applications as business intellig...Download
Installed
Smart Install -
Create, manage, and collaborate with others on presentations.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
- Learn about Data Analyzer 3.5.Download
Installed
Smart Install -
Develop your own custom solutions visualizing various data.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install - Create reports that works with the Great Plains 8.0 sample data...Download
Installed
Smart Install -
Convert JPG, BMP, TIFF, PNG images to PDF files.DownloadInstalled
Smart Install -
Solve the problem of transferring data between various data sou...DownloadInstalled
Smart Install -
Create, encrypt, and merge PDF files.DownloadInstalled
Smart Install -
Get an application for pet-sitting business.DownloadInstalled
Smart Install -
Render PDF files within applications that support the print fun...DownloadInstalled
Smart Install - Manage business customers and integrate media channels to a sin...Download
Installed
Smart Install - Keep track of your inventory and finances.Download
Installed
Smart Install
-
All versions:
4.5 starsout of 2 votes
-
Current version:
0 stars Be the first to review this product -
My rating:
Write review
Results 1-2 of 2
-
"Outstanding ETL Tool"
Version: Advanced ETL Processor 3.7.0.3
Pros
Advanced ETL Processor has comparable features to products that cost thousands more. It enabled me to perform a complex conversion in days vs the normal months that previous conversions took. It has a large number of build in functions that can be used in the data transformation process. If the build in functions are not enough you can access the "Calculations" function. This function lets you use a scripting language to perform logical and other calculations.
One huge benefit of this product is the responsiveness of support. They are always very prompt in returning assistance. Beyond excellent support the developers also listen to needs and enhancement request. It is typical to see an enhancement in the next version or two after we discussed it - a matter of a day or two!
This tool is a valuable part of my conversion process. I am glad I found it.Cons
The scripting language is somewhat difficult to figure out. However, support has been very patient helping me figure out the parts I struggled with.
The documentation consist of a PDF document. I would like to see it in a Windows Help format or live online from their website. I would also like to see more real life examples.Summary
An outstanding value for the cost. Advanced ETL Processor is a very powerful ETL tool at a fraction of the cost of other ETL tools.
-
"Potential to save signifigant time processing extracts."
Version: Advanced ETL Processor 2.4.0.8
Pros
Easy to use
Support is great
Automation of data proccessing frees time for other tasksCons
Documentation is a little out of date
Summary
This product has the potential to be quite a time saver. It is fairly easy to use and does not take long to get things set up. The documentation is not quite what I had hoped for however the support for this product has been great. Typical requests/questions have been answered same day. I am looking forward to all of the time (money) this will save me.
