Below is a list of Miscellaneous Transformations supported by Advanced ETL Processor
ImageData Transformation FunctionDescription
Date Format Returns Date in ‘yyyy-mm-dd hh:nn:ss.fff' format. In order to load Date fields into target database, they should be converted into ‘yyyy-mm-dd hh:nn:ss.fff' format
Current Date Returns Current Date in ‘yyyy-mm-dd hh:nn:ss.fff' format
Length Returns Length of String
Literal Populates field with a constant value
User Returns Current Windows User Name
Get Excel Cell Value Transformation function
Get Excel Cell Value Returns Cell value of an Excel file
Get File Content Transformation function
Get File Content Returns content of a single file
Splitter Splits data into a number of values using Delimiter and Qualifier
Joiner Joins several values into one value delimited Delimiter and surrounded by Qualifier if specified
Accumulate Strings Transformation Function
Accumulate Strings Accumulate strings data transformation function adds strings from previous records together,
Case Data Transformation Function
Case Conditional Mapping
URL Location Transformation Function
URL Location  Use URL location transformation to determine location parameters of URL such as Country, City, Region, Post Code, Street, latitude and longitude
IP Location Transformation Function
IP Location  Use IP location transformation to determine location parameters of IP address such as Country, City, Region, Post Code, Street, latitude and longitude
URL Shortener Transformation Function
URL shortener


Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database. Typical usage of it would be extract data from Excel File, Validate Date Formats, Sort data, de-duplicate it and load it into Oracle 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 primary key

Direct link, no registration required.