Actian Blog / Must-Have Features of a Hybrid Cloud Data Warehouse

Must-Have Features of a Hybrid Cloud Data Warehouse

3D Illustration Of Server Room In Data Center Full Of Telecommunication Equipment,concept Of Big Data Storage And  Cloud 
Computing Technology.

Are you considering a hybrid cloud data warehouse for your company?  Do you know what features to look for?  If you want to maximize the value of this important infrastructure investment and give yourself the flexibility to adapt to changing business needs in the future, you need not just pick any solution; you need to pick the right solution to meet your business needs. Here is a list of the top must-have features of a hybrid cloud data warehouse solution.


This should go without saying – your data warehouse stores a lot of valuable and sensitive information about your company, your products, your customers, and your operations. Because a hybrid cloud data warehouse is hosted outside of your company’s physical data centers, you need to be confident that the solution you choose has the robust security features to safeguard your company’s data.  Actian Avalanche has achieved SOC 2 Type 1 (a standards-based audit of system compliance) and utilizes SSL Encryption, Data Masking, and allows access only to whitelisted clients.

Multi-Cloud Deployment

Public and private cloud offerings in the marketplace are continuously changing, and your company’s preference of cloud providers is likely to shift over time based on cost, performance, and risk factors.  Your hybrid cloud data warehouse should support multi-cloud deployment.  This means it can both operate in different cloud environments and span across them.  Many companies are adopting multi-cloud deployments, stratifying data across Azure, and AWS environments.  This adds one more layer of redundancy to protect the company against business disruption and enables cloud costs to be optimized. This multi-platform approach also protects organizations from vendor lock-in.


Very few companies are ready to make the shift to “cloud-only” IT environments. You will need a “hybrid” data warehouse solution to optimize workloads across different public cloud environments and to enable highly sensitive business data to be stored in an on-premises or private cloud environment.  Actian Avalanche, in addition to being a high-performance cloud data warehouse, also runs on-premises with federated query capability – giving you a choice about where to store your data while still leveraging cloud processing power for running queries.

Integrated Connectivity

Pre-built data integration and connectors to major commercial SaaS offerings can significantly reduce implementation costs and time to value for your hybrid cloud data warehouse.  Most companies are moving away from home-grown IT systems towards 3rd party offerings such as Salesforce, ServiceNow, NetSuite, etc.  This strategy makes even more sense if you can easily plug the operational data sources into your hybrid cloud data warehouse.


The reason you are implementing a data warehouse is that you have a lot of data and want to use it to drive business value.  Actian Avalanche can scale to hundreds of users and hundreds of Terabytes of data.  This scalability means that you have plenty of room to grow and expand how you use your data in support of digital transformation, data-driven decision making, and real-time operational analytics without worrying about performance issues.

Decoupled Storage and Compute

The storage and compute capacity needs of your hybrid cloud data warehouse aren’t equal.  Storage needs grow incrementally over time as you produce more data.  Compute needs are variable based on your business activities. To learn more about this topic, check out a related blog, “Put the Analytics Compute Where the Data Lies.” You need to be able to size storage and compute capacity independently to suit workload volume, performance demands, variable usage, and avoid the cost burden of under-utilized capacity.

Ability to Suspend Compute

Do all your business applications really run 24×7?  Most don’t.  Even if you have a global business, you probably have reduced or no business activity on the weekends and during other periods of the year.  Actian Avalanche enables you to suspend compute activities (effectively turning the system off) when you aren’t using it while maintaining the database, and you are ready to get moving again when business activities resume.  This is an important feature for cloud cost optimization – you only pay when you are using the data warehouse service.

These are the “must-have features” of a hybrid cloud data warehouse solution.  Actian Avalanche supports each of these and a whole lot more.

To discover how Avalanche can help your company deliver high-value data management solutions, visit

About Pradeep Bhanot

Product Marketing professional, author, father and photographer. Born in Kenya. Lived in England through disco, punk and new romance eras. Moved to California just in time for grunge. Worked with Oracle databases at Oracle Corporation for 13 years. Database Administration for mainframe IBM DB2 and its predecessor SQL/DS at British Telecom and Watson Wyatt. Worked with IBM VSAM at CA Technologies and Serena Software. Microsoft SQL Server powered solutions from 1E and BDNA.

facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo