Hi we know (or believe) ssas saas gets stood up separately when a company migrates to sql saas.
But what happens to ssis and ssrs? from what i remember there is no such thing as ssis in azure. And the recommendation on sssrs is to move all those objects to pbi as paginated reports. we already understand sql server on an azure vm in the cloud can serve up both ssis and ssrs.
Do i understand this correctly? I'm not sure if i picked the correct forum. i thought there was going to be an azure sql saas and ssas saas 2025 now available but i dont see a forum with that name.
February 6, 2025 at 4:00 pm
Hi we know (or believe) ssas saas gets stood up separately when a company migrates to sql saas.
But what happens to ssis and ssrs? from what i remember there is no such thing as ssis in the cloud. And the recommendation on sssrs is to move all those objects to pbi as paginated reports.
Do i understand this correctly? I'm not sure if i picked the correct forum. i thought there was going to be an azure sql saas 2025 now available but i dont see a forum with that name.
Are you getting SSAS and SAAS mixed up, perhaps?
Did you do any research before posting your questions?
February 6, 2025 at 4:06 pm
A SSAS model is called a Semantic Model in Azure:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand
February 6, 2025 at 4:09 pm
i did once before on this very subject but its been a while. and sometimes things change. and sometimes the ms documentation is so geared to selling and filled with links to links to links etc that i like to hear it from the few experts here directly. but i can do better.
February 6, 2025 at 4:17 pm
thx phil, thats what i thought. without data factory which i saw last time can "call" ssis, its not happening. we dont pay for data factory.
February 7, 2025 at 8:48 am
Assuming you're trying to move away from a self-hosted model, there is a halfway house. We have found that Azure DBs (ie, DB as a service) are extremely expensive if you want a fairly high level of performance. So we have decided to use Azure VMs for our database hosting. You can fire up a Windows Server / SQL Server 2022 image VM in minutes.
Once you do this, you have all the SQL Server functionality you had before, at a cheaper price than equivalent spec AzureDBs. But yes, you are responsible for DBA and networking config. This gives us SSIS (which we went back to after trying Data Factory, which we also found to be expensive). We no longer use SSRS or SSAS, having migrated our reporting to the Power platform, which was not difficult. Though I wish I could still use VS for report development, rather than Report Builder (which feels like VS for Idiots).
February 7, 2025 at 8:12 pm
thx phil, yes we already use an azure vm machine 2022 as a dev box. And have exercised everything but ssas on that box to this point.
February 10, 2025 at 3:46 pm
Hi everyone
From my experience, migrating SSIS and SSRS to a SaaS-based SQL platform like Azure SQL Database requires careful planning, as these services aren't natively included. Here’s how I see
SSIS – As already mentioned, Azure Data Factory (ADF) is the recommended approach if you want to run SSIS packages in the cloud. However, ADF can be expensive, and not all companies are willing to pay for it. If cost is a concern, sticking with an Azure VM running SQL Server remains a viable option, as it retains full SSIS functionality.
SSRS – Microsoft’s direction is clear: Power BI Paginated Reports is the recommended replacement for SSRS in a cloud-native setup. However, if your organization has a strong dependency on SSRS, then hosting SSRS on an Azure VM is an alternative.
Hybrid Approach – I agree with what Phil mentioned about cost-effectiveness. Azure SQL DB can become quite expensive for high-performance workloads, and using **Azure VMsAzure VMs with SQL Server all
Ultimately, the best approach depends on your organization’s budget, workload, and how much maintenance responsibility you're willing to take on.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply