This product is great for data warehousing, it provides seamless integration with many different RDBMS platforms (Oracle, MySQL, SQL Server etc).
The support team are extremely helpful in assisting you during your implementation journey. I have not found any downsides to this software package so far! It is very easy to setup as well - no need for custom connectors or drivers. We use it at work to store all of our historical transactional data into one place which makes analysis much easier than having multiple systems that each hold only parts of the information we require.