Data Source

data-source-in-ssas

Entry Point

Welcome to The Second Phase Of the SSAS Tutorial

We Read The Data From Various Sources

You have become familiar with the primary  SQL Server Analysis Services (SSAS) concepts.

Now let me do the whole project process and work in the SSAS Cube environment in 6 efficient steps based on these concepts.

This practical section is equal to reading a 400-page book in the field of Microsoft Analysis Server, which I have prepared smartly and usefully in the form of these six steps!

I promise you that you will learn all the parts necessary for every Analysis Services project up to the point of delivering an actual industrial project.

Goal

Read initial data for analysis of them

Data Type

OLTP or Data Warehouse

The data source can either be OLTP data that we receive directly but must clean before analysis or data from a clean data warehouse.

Another point is that these data are not necessarily all from one place and may come from various sources.

Data Reading Environment

SQL Server 2019

We will read the data from here and store the final results of the analysis here.

Download

Database Name

AdventureWorksDW2019

It was the AdventureWorksDW2019 we downloaded together in the last segment (SSAS Tutorial) and restored in the SQL server environment;

Now, we should read it here.

Download

Data Analysis Environment

Visual Studio 2022

We are going to perform analyses on data.

Download

Tools

Data Sources

Theory Prerequisites

SSAS Tutorial for Beginners

Concepts: Architecture | OLTP | Data Warehouse

Create Data Source

Now that we have prepared everything, it is time to start our work.

Do you remember what we meant to do in the first step?

In this step, we will read the data from various sources.

We should specify the source of the data for the visual studio.

What was the source of our data in this training?

It was the AdventureWorksDW2019.

So we specify the data source at first.

So let’s go!

#1

First, Right-Click on “Data Sources” and select the “New data source” option.

create-data-source-in-ssas-01

#2

Click next In the Data Source Wizard window.

create-data-source-in-ssas-02

#3

Select the second option and click on the “New” button in this section.

We want to create a new connection.

create-data-source-in-ssas-03

#4

The Connection Manager window opens;

This window is where you need to specify your server name to connect.

  • Click the “Server Name” to see the list of servers.

  • Click the “Connect to a Database” to see the list of databases on that server.

  • Click the “Test Connection” to ensure that the connection between the data and server works properly.

create-data-source-in-ssas-04

#5

If everything is alright and the connection is made, we get a message indicating that the link has been created successfully.

Click on “ok” and hit “ok” again.

create-data-source-in-ssas-05

#6

You see here that the name of my server and its database appears.

Click next.

create-data-source-in-ssas-06

#7

Select the option of “use this service account” and click “Next.”

create-data-source-in-ssas-07

#8

Here I should specify a name for the data source, and I enter “AdventureWorksDW2019”. Then,

I hit “finish.”

We need this name in the next step.

create-data-source-in-ssas-08

Summary

Let’s summarize our discussion up to here:

What was the output of this step?

Specification of the source of the data we will perform analysis on, which was AdventureWorksDW2019 in our case.

First, we specified which server this database is on, then selected our desired database from that server.

#Final_Result

What you see right now is what you see by the end of this step in this section.

create-data-source-in-ssas-final-result
Previous Lesson
Next Lesson

Written by: Moslem Afrashteh

Get Exclusive SSAS Tips

That I Only Share With

Email Subscribers

Related Posts

Leave A Comment