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 18.104.22.168: 28000 rec/second
Version 22.214.171.124: 46000 rec/second
Version 126.96.36.199: 84000 rec/second
Version 188.8.131.52: 94000 rec/second
Version 184.108.40.206: 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