What is most valuable?
I've found that the data compression and ETL are the most valuable features for us.
In 18.104.22.168 Pivotal confirmed that even restoring schema level backup is possible from a DB backup.
- restoring schema from a DB level backup has been tested and working fine .
ORCA - the Pivotal Optimizer does a good query plan but does not works with all business logics. This needs to be tested based on your requirement.
How has it helped my organization?
Loading batch data has really improved the efficiency of our organization.
Running Extracts has drastically improved the timings. Being MPP which is a bulk operator - we were able to do 1.5 million calculation in 15 minutes.
What needs improvement?
Scaling of the solution needs to be improved.
HD connection is available where as, not to any file system.
Connecting Greenplum with Gemfire(In-Memory) to load, sync, and reconcile data would be really valuable.
For how long have I used the solution?
I've used it for nearly for 3 years
What was my experience with deployment of the solution?
We had deployment issues after installing new patches. Every new patches has some or other business hit where the release notes needs to be reviewed.
What do I think about the stability of the solution?
How are customer service and technical support?
They have a quick turn around but to dig into the actual information takes time, based on the Severity. Technical Support
First level of technical support would not be that effective (based on own observation).
Which solution did I use previously and why did I switch?
We were using Sybase and handling massive data, bulk operation was not possible.
How was the initial setup?