Advantages of Integration with Azure

• The sophisticated analytical solution can be built.
• Critical data get secure and role-based access.
• By adding an activity by which data gets loaded on a model can be done with Azure Data Factory.
• You can use custom code in order to a lightweight orchestration of model.

Quick to Deploy

A server can be created within minutes using the Azure portal. A declarative template can be provisioned to servers by using PowerShell and Azure Resource Manager Template. Multiple servers can be deployed using single template along with other Azure Components. The tabular model can be created right in Azure portal once severe is created, automatically relationship between tables are created

Scaling

Azure Analysis Service is available in 3 different tiers which are Developer, Basic and Standard. Plan cost varies with respect to processing power, size of memory and CPU's in each tier You need to select a plan within the tier when you create a server. Only within the same tier, you can change the plan but you can't move from higher to lower tier. You can pause, scale up or scale down your server.

Tabular Model Migration

If SQL Servers Analysis Service model solutions already exist at your on-premises, Azure Analysis Service can be migrated without any significant changes.

Connection with other popular data sources

You can connect your data sources through on-premises and cloud. You get hybrid solutions by the combination of both on-premises and cloud data sources.

Use of known Tools

• SQL server management studio
• SQL server data tools for visual studios
• Powershell
• SQL server management studio

Tabular Model Migration

• Authentication of users is done with direct Azure default directory.
• Data security is taken care by encryption of your data .
• On-premises data sources are secured by creating queries with encrypted credentials.

Next