- Ease of deployment
In the organizations I have worked with, SAP Sybase IQ has been used successfully as a datawarehouse solution and as data store for ad hoc querying. It delivers performance and enormous scalability.
Training and marketing are two areas where improvements are needed.
I've used it for eight years.
SAP Sybase IQ is a product which can be deployed very easily on commodity hardware.
Not really. In normal functioning SAP Sybase IQ is extremely stable.
No. I have seen deployments of datawarehouses with tens of TB's in used space and they scaled very easily to multiple applications.
It has been good, but more can be done in this area.Technical Support:
It's good, 7/10.
It's straightforward in the hands of a junior level DBA. The installer is very easy to understand as long as the user has a understanding of architecture and layout of the database server.
It's been in-house.
Understand your requirements well in terms of performance, backup, and space requirements before picking the number of licenses. If IQ is being used in a virtual environment then probably a good understanding of licensing options in a virtual environment is needed. Recently SAP has introduced some new license options, but new users should review those options with the sales team.
Estimate the storage requirements, performance requirements, and the number of users during the planning phase. Review the documentation related to hardware sizing and best practices available on the SAP website. There is a hardware estimation guide too which helps in estimating the hardware requirements. Lastly, review the multiplexing option too and understand the implication of columnar storage in a database server.