-1

I am new to SQL Server Data Tools. After browsing the internet to learn the BI suite I found out that SSIS SSAS SSRS has more than just drag and drop. People are actually creating cubes and databases programmatically. Unfortunately, I couldn't find any resources on internet to learn how to code like this. Kindly guide me or share some links to learn to create cubes and databases programmatically.

Cœur
  • 37,241
  • 25
  • 195
  • 267
user3323487
  • 61
  • 1
  • 1
  • 10

1 Answers1

1

Using BIML you can create SSIS packages programmatically. Combining BIML and TMSL allows you to script cube creation and processing. If you're set on creating multidimensional cubes and not tabular cubes then look at MDX.

Start by downloading BIML express for Visual Studio Data Tools. Then start to look at the connector for Analysis Server and the AnalysisServicesExecuteDdl element which allows you to write TMSL inside the component. Now, using TMSL you can create a cube. Why not just use BIML for everything and skip TMSL? Using TMSL instead of the available BIML elements for handling cubes removes the need to have BIML Studio ($$$) installed.

Magnus Lander
  • 96
  • 6
  • 1
    sorry for the late reply but thanks alot for help ! – user3323487 Mar 06 '20 at 07:29
  • can you please explain that as my new role of BI Consultant 3 months in my career will it be worth my while learn BIML and TMSL or should i work with without it? As of now there is no resource in my comany who knows BIML and TTMSL, bu i want to advance my skills and see my self as full stack BI developer. – user3323487 Mar 06 '20 at 07:41
  • 1
    I think there are simpler tools depending on the solution you want to build. Starting off with writing BIML and TMSL might be a lot. But if you want to be able to control the ETL in detail this is the way to go. For TMSL I usually use a combination of writing the code myself and using [Tabular Editor](https://www.sqlbi.com/tools/tabular-editor/). For SSIS I always use BIML. But if the client allows cloud solutions check out the different etl tools for Azure (Data Factory) and Google. – Magnus Lander Mar 10 '20 at 22:12