Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets. Therefore, it is an all-in-one software that will be very useful in your work, no matter what it is related to.Extraction:?? Multiple Delimited or Fixed width Text files?? Multiple Excel files Multiple Excel Spreadsheets?? Multiple MS Access Databases?? Multiple DBF Files?? Any ODBC source?? Multiple Tables Validation:?? 190 Validation Functions?? String Validation?? Number Validation?? Date Validation?? Time Validation?? Validation Against list of values?? Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC Transformation:?? 36 Transformation Functions?? String Transformation?? Number Transformation?? Date Transformation?? Sorting?? Grouping?? Deduplication?? Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)?? Deriving a new calculated value (e.g., sale amount = qty * unit price)?? Joining together data from multiple fields?? Summarizing multiple rows of data (e.g., total sales for each store, and for each region)?? Generating surrogate key values?? Transposing or pivoting (turning multiple columns into multiple rows or vice versa)?? Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)?? Customised TransformationLoading: ?? Multiple Data Targets?? Sql scripts execution before and after loading?? Delimited or Fixed width Text file?? MS Access Database?? Microsoft Excel File?? DBF File?? ODBC source (Using ODBC API)?? Oracle 7-10G database (using OCI API)?? SQL server 7- 2005 (using BCP API)?? ODBC source (Using ODBC API)Limitations: