Blog & Company Updates

Can You Do Traditional BI in the Cloud?

With all the focus on cloud and Azure, have you ever wondered if you can run your traditional BI workloads within Azure? You may ask, should we be putting our traditional BI workloads that we’ve been using like the SQL Stack, SSIS, SSAS and relational databases in Azure; can we even do that?

The answer – yes; there are components and capabilities with Azure, and you can utilize those to migrate what you’re doing on-premise to Azure. The first way you can do this is to run them via SQL VMs within the Azure cloud. You can spin up SQL Server and everything you need there. As far as SSIS, analysis services and SQL Server, you can solve it just like you did on-prem, but run it within the cloud. Then you can take advantage of everything you get within an IaaS implementation.

The good news is now you can run all these components as Platform as a Service (PaaS) as well. So as SQL Server we can use Azure SQL Database. For workloads with larger-sized volumes, distributed queries or distributed big data within a SQL environment, Azure SQL Data Warehouse is a great solution.

Previously, we couldn’t run SSIS packages within the cloud, but with capabilities within Azure Data Factory, we can now do this as a platform, without having to manage the server, cutting down on maintenance tasks and the daily chores of checking our server.

With SSAS, we have Azure Analysis Services, which works like a tabular instance of SSAS on-prem. We can employ tabular models there and run them in the cloud. So, we can orchestrate all these things together and take advantage of the PaaS capabilities that we get there. Once we’re there, we gain the ability to orchestrate Data Lakes and put real time and advanced analytics on top of it.

 

If you’ve been waiting for good Platform as a Service offerings to go to the cloud, the time is now. And Azure is the answer.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

Author

  • 3Cloud is a “born in the cloud” Gold-certified Microsoft Azure technology consulting firm and Azure Expert Managed Services Provider that provides cloud strategy, design, implementation, and managed services to clients across multiple industries. Founded by former Microsoft technology leaders, 3Cloud combines a team of highly experienced cloud architects and technologists with a strong network of Microsoft sales and engineering relationships to deliver the ultimate Azure experience for clients. 3Cloud is headquartered in Chicago, Illinois with offices in Dallas, Texas and Pittsburgh, Pennsylvania and supports clients throughout North America and Europe. To learn more, visit www.3cloudsolutions.com.

3CloudCan You Do Traditional BI in the Cloud?