 Hello, welcome to SSNitec, Susil this side and today we are going to see about the data sets inside the ADF. So in the last videos we have seen about the link services. So today we are going to see about the data sets. So if you haven't watched the last video so I would strongly recommend to watch that video because we are going to use the link service in this video. So let's get started with the data set. So what is data set? So data set identify the data within the link data store such as SQL table, files of folders and documents. For example, an azure storage link services like storage account to the data factory and azure block data set represent a block container and the folder that contain the input blocks to proceed. So simply you can understand data set is the collection of the data and it is using the link service to connect with the data source. If your source is the SQL server table then it will be going to build the connection by using the link service with the SQL server and after that we will pull the data from there and store inside the data set. So that is simply data set. So here you can see the data sets are very similar the connection managers in SSIS. So go to on the browser and we will see in the practical. So here if you have remember we have created this ADF pipeline that is SSU training. So in this we are going to use a activity that is copy data activity. We haven't discussed about the copy data activity. So don't worry for that. In this video we are going to only use the copy data. In the next videos we will be going to see in the details and copy data activity will be going to move the data from one location to another location that is the only use of the copy data activity. So here as you can see we have created this pipeline. So under this pipeline let me rename this pipeline from here and we can call this pipeline as copy data and after that here we can see the move and transform. So we can see the copy data we can drag and drop and after that here we can see the source and destination. So what is our requirement? So our requirement we are having this secos over and under this we are having two tables. First is the employee table and second is the employee destination table. So we just want to move the data from this employee table to the employee destination table. In the employee table we have these four rows and in the destination we don't have any rows till now. So once our pipeline will be executed then data will be loading in this table. So go to on the browser again and in this first we have to set up for the source. So our source is the employee table. So go to on the source side here it is asking for source dataset. So either we can click on this drop down and we don't have any dataset here. So we have to create the new dataset. So for creating the new dataset either we can click on this new button here or we can go in the dataset and click on these three dots and click on the new dataset. So both are same. So let me click on here. After that it is asking from where we want to connect. So we want to connect with the Azure SQL. So we can select that option and click on continue. And after that it is asking the link service. So if you haven't created any link service so let me quickly try to create the link service again. So click on new and this time this is for Azure SQL SSU. And after that here we can see we are having all these options. So we want to enter everything as manual. So we have to specify the domain name. So this is the domain name then database name. So database name is the SSU and the authentication we have to enter the ID and password. So this is ID and let me enter the password here. After that we can test the connection. So here connection succeed. So we can click on create. So it will create a new link service with the name of Azure SQL SSU. Let me click on create. So now by using this link service we are able to log in inside the SQL server. Next we want to get the data from the employee table that is the part of the dataset. So as we can see this is created that looks good. Now here we can see the table. So we want to select the table on which we want to get the data. So this is the source one. So that is why this is the employee source. We can select the employee table and here let me rename this with the employee source. After that we can click on OK. So it will create a dataset that you can see here and if we want to preview the data we can click on this preview data. So it will be going to get the data as we can see four rows we had. So let me close this. Now here we can save the changes or we can publish. So let me save all the changes. So everything is saved. Let me close this. So in the source side we need to select that employee source and it is going to point out the employee table. Now leave everything go to the destination. So in the sync side we have to create one more dataset and that dataset for the destination. So let me click on new here and now we need to select the Azure SQL database click on continue and this is for the employee destination. Now in the link service if you have remember we have already created this Azure SQL SSU then we need to select the table. So this is your employee destination table. Now we can click on OK. So this is the destination connection and if we can see here inside the destination so everything is available right here. Let me save this. So everything is saved here and in the destination everything is set up. So once we are going to debug this or execute it so data should be going to load in this destination table. So before that in this video we are more concerned on the dataset. So as you can see inside the datasets we are created these two dataset first for the source and second for the destination. So let me try to debug this and we will try to validate data will be loading in the destination or not. So as you can see it is in queue. Let me try to refresh it. So here it got filled why it got filled we can see in the error log side. So here we can see this error log we can click on that. So it is saying like this IP is unable to communicate. So if you are getting such type of error you have to go inside the your SQL Server that you can see here. Let me try to open the portal again and inside the portal here we need to go inside this SQL Server and under that SQL Server we can go in the security tab here firewall and virtual network then we need to add those IP which are unable to communicate. So we can add that here and let me save this. So once we save this we are able to access this SQL Server from the site. Now let me try to debug it again. So now here we can see it succeed. So we can go to on the SQL Server and we will try to refresh this table. So it should have the four rows. So here in the destination table we are having all these four rows. Thank you so much for watching this video. If you really like this video please subscribe our channel to get many more videos. We will see in the next video.