I have the following situation: I have a component in my Flaw that has, among others, a column continent:


( Read more... )

SQL Server Integration Services (SSRS) is a part of SLQ Server that allows to build various reports.
The SSRS is a separate Windows Service (EXE file) on an MS SQL Server and should be started separately:
A SSRS report is contained in a special file format RDL. Here is an example of an RDL file (during the design stage; not on runtime stage):Here ( Read more... )

This task is described in the following Udemy lesson: https://www.udemy.com/course/learn-azure-data-factory-from-scratch/learn/lecture/23931350#overview :
We already have a set of streams; no we have to finish it with final “sink” stream.

See more in Word file at https://docs.google.com/document/d/1mFTNMsZ9RJcOz5ilXcApZcTGoMtfPIzJ/edit?usp=sharing& ( Read more... )

This task is described in the following Udemy lesson: https://www.udemy.com/course/learn-azure-data-factory-from-scratch/learn/lecture/23931346#overview .

Let’s suppose that we have the following Data Flow item:
It contains several columns; partially a Country:

( Read more... )

This switch is off by default:


( Read more... )

A problem: we have a Data Flow; and we want to leave only rows where:

Column continent is equal to 'Europe'

And column country_code is not NULL

To do this, add a filtering operation into the Data Flow:

( Read more... )

To do this, add a Parameter and then use the parameter in Base URL field:

( Read more... )

A problem: I need to read data from an HTTP location and put them into Azure Storage

A solution: create a “source” Linked Service that points to the HTTP site; and a Data Source that points out to a specific file inside the HTTP site. Then create a “sink” Linked Service that points out to the Azure Storage; and a Data Source that points out to a ( Read more... )

A problem: I have a collection of data stored in a JSON file:

…

[

{

"sourceRelativeURL":"cloudboxacademy/covid19/raw/main/ecdc_data/cases_deaths.csv",

"sinkFileName":"cases_deaths.csv"

},

{

"sourceRelativeURL":"cloudboxacademy/covid19/raw/main/ecdc_data/hospital_admissions.csv",

"sinkFileName":"hospital_admissions ( Read more... )

A problem: I have an ADF Pipeline. I would like that the Pipeline was automatically started every 15 minutes starting with a date Start Date and till a End Date.

A solution: create a Trigger of type Tumbling window:

( Read more... )