There two ways of sending of HTML emails with Advanced ETL Processor by using the package or as part as transformation
Automation Package sample: Sending price list to the customers
Enabling support for HTML email is easy: just tick a check box
More advanced way of sending emails is using transformation:
Please use our support forum if you have any questions
The Greenplum Database builds on the foundations of open source database PostgreSQL. It primarily functions as a data warehouse and utilizes a shared-nothing, massively parallel processing (MPP) architecture. In this architecture, data is partitioned across multiple segment servers, and each segment owns and manages a distinct portion of the overall data; there is no disk-level sharing nor data contention among segments.
Unlike PostgreSQL, Greenplum database does not support binary option of copy command
Select Text Mode option to load data into greenplum
We did spend a lot of time optimizing our ETL software and here is what we were able to achieve so far:
Loading data into Oracle database via direct path loading from a textfile
Version 126.96.36.199: 28000 rec/second
Version 188.8.131.52: 46000 rec/second
Version 184.108.40.206: 84000 rec/second
Version 220.127.116.11: 94000 rec/second
Version 18.104.22.168: 101000 rec/second
There a lot of ways to make our software better, we will continue working on improving performance and will publish our results here.
In latest version we have introduced support for Global Variables
They are stored in the registry, this allows to use different settings on different computers.
Please be very careful with this option it is very use to make mistake and run transformation agains wrong database
Advanced ETl Processor's "Is In list" validation function is used to check if value exists in the database or file.
But In some situations it is not very efficient.
In this case there is better alternative "Is value in database" and "If value in database" transformation functions
The way it works is very simple: during execution <value> is replaced with actual value If number of records returned is more than zero it returns success otherwise failure
Based on the customer feedback in the latest version of Advanced ETL Processor we have introduced support for the web services
The simplest way to describe it as a way of communicating with the web servers. The application sends a request to the web server using XML and receives back a reply as XML. One of the examples would be converting Fahrenheit to Celsius or getting current currency exchange rate. A lot of modern websites such as Ebay, Amazon are using web services as a standard API for developers.
In order to communicate with temperature conversion web service we need to build HTTP Request Header and HTTP Request Body dynamically, There are several ways of doing it the easiest way is to use "In Place Replace transformation" function
During execution #value# is replaced with body length
During execution #value# is replaced with temperature
Note: There is a detailed example in the default repository