The ability to store transformation/package objects in the repository for reuse in other transformations was introduced in the latest release.
For example if there is a series of transformations (lookup, add, if null, if empty, etc) that are reused we could design once and reuse in other transformations. Works with both Visual Importer ETL and Advanced ETL Processor
People quite often ask us why our software is so cheap.
We prefer the second option.
As you can see from our support forum and website news our software is constantly getting better.
Greed as bad. The partners want to make money as well. HIgh Prices=Limited number of partners and customers
You are expert in certain area, spend years doing similar tasks.
Now you are thinking: “Let’s have a look at what I have done so far and design something which covers 90 percent of the issues. Than I will have something to sell to my 20 potential customers”
The cost of most BI software is too high for small business. There a lot of common tasks which can be automated but because the of cost of software and the cost of implementation is so high they just can't afford it.
Our software allows our partners to create prepackaged solutions for specific tasks which are easy to implement and support.
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 188.8.131.52: 28000 rec/second
Version 184.108.40.206: 46000 rec/second
Version 220.127.116.11: 84000 rec/second
Version 18.104.22.168: 94000 rec/second
Version 22.214.171.124: 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