How to deploy data models to Azure Analysis Services (AAS)?

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. It integrates with many Azure services enabling you to build sophisticated analytics solutions.

AAS is the cloud equivalent of SQL Server Analysis Services (SSAS).

I did a PoC on AAS, deploying data models from 3 data sources to AAS instance. 

Data sources are

1. Azure SQL (PaaS)
2. SQL VM (IaaS)
3. On-prem SQL Server

In this blog post, I tried to explain the process of deploying the data models to AAS.

Using InfoSphere Optim Test Data Management tool for extracting/converting/inserting data

InfoSphere Optim Test Data Management for z/OS tool can be used for the following tasks

   1. Extracting the data from source database (by defining Access Definition)

   2. Converting the extracted data (by column maps)

   3. Insert the converted data into target database

The JCLs can be built for each step and reused multiple times.