Below is 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 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 shortnener  


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 primary key

Visit Support Forum Learn More Download Buy It
Advanced ETL Processor Standard

Recommended product for desktop users who require advanced data transformation

From only 340$ per license

Read More

Advanced ETL Processor Professional

Recommended product for development environment

From only 480$ per license

Read More

Advanced ETL Processor Enterprise

Recommended product for complex enterprise environment

From only 690$ per license

Read More

We have 169 guests and one member online