XMLAToSQL

Code that can be deployed as an Azure Function to read from the Azure Analysis Services XMLA endpoint and bulk-inserts into Azure SQL

Deployment

Download Repo
Open Visual Studio Code and open this repo
Open UpdateSQL/run.ps1 and replace all values that are in <>
click F5 to test locally
right-click the UpdateSQL Folder and say deploy to Azure Function (Requires to corresponding Visual Studio Code extension)

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
.vscode		.vscode
UpdateSQL		UpdateSQL
.funcignore		.funcignore
.gitignore		.gitignore
Microsoft.AnalysisServices.AdomdClient.dll		Microsoft.AnalysisServices.AdomdClient.dll
Microsoft.AnalysisServices.Platform.Core.dll		Microsoft.AnalysisServices.Platform.Core.dll
Microsoft.AnalysisServices.Platform.Windows.dll		Microsoft.AnalysisServices.Platform.Windows.dll
Microsoft.Identity.Client.dll		Microsoft.Identity.Client.dll
README.md		README.md
host.json		host.json
profile.ps1		profile.ps1
proxies.json		proxies.json
requirements.psd1		requirements.psd1