 Hey guys, welcome to SSUniTech, so we'll decide and today we are going to see about the parameterized linke services and we'll be going to also see about the parameters in the SEO data factory. So first try to understand about the parameter and then we'll be going to see in the linke services how we can use the parameters. So this is very important while you are going to work in the real-time environment. So go to the next slide and we'll try to understand. So what is the parameter? So the parameter you can use to pass external values into the pipelines, datasets, linke services and data flows. For the data flows we did not discuss as yet, so we'll be going to see in our upcoming videos. So here we can understand like on the pipeline level we can create the parameter. In the dataset level we can use the parameters and third we can see the linke services. So on these three levels we can create the parameter and we can use those. Next once the parameter has been passed into the resource it cannot be changed. So while we are going to pass the parameters into the resources we cannot change that. By parameterizing resources you can reuse them with different values each time. So as you can understand if we want to load the data from any source for example our source is the blob storage. So we want to load the data from the blob storage to three different environment. So first environment is the dev environment. The same data will go to the jouet environment and the same data should go into the prod environment. So here instead of creating these three linke services we can use and create a single linke service and we'll be going to utilize that in different environments. Similarly we can also create the single dataset and that dataset will be the dynamically handle these three environment. So our source is static and our destination is dynamic. So this is the actual requirement that we'll be going to achieve by next two to three videos. So in this video we'll try to create the linke service and how we can make that as dynamic. So first go inside the browser and we'll see about the source. So here as we can see this is the blob storage under the ssu testing. We are having ssu container and here we can see this table that is employee.txt table. So this table are having only two column id and name and the values that we can see right here. So we want to load this into the sico server. So inside the sico server as you can see we are having these three environment like dev environment, prod environment and uat environment. So we'll be going to load the data into these three environments. So here I have created these three databases only but in the real time you will be having these three sico servers. Here we are having only ssunited server but in the real time you will be having these three different different servers by which we'll be having these tables. As we can see here we have this employee table under the dev environment. In the uat and prod we'll be having the same employee table so that you can see and verify. So this is the requirement. So first we'll try to create the linke service and how we can make this as dynamic. So go to the browser, go to the azure data factory. So here go to on the manage and under the manage the first option under the connections we can see the linke service. So if you haven't watched the linke service video of this video series so I strongly recommend to watch that video before going forward. So here I want to create a new linke service. So click on this new. Now here we have to search so our destination that is the azure SQL. So we can search for that and click on continue. Now let me call this as dynamic linke service for azure SQL and this is for the employee table. Now let me scroll down. Here we are having the option to select the subscription server name and database name. So let me select the subscription first then the server name and then the database name. So I am going to create this with the static connection with the dev environment because here we are not going to see any option by which we can make this as dynamic. So in the real time you have to make the dynamic with the server name along with the database name as well. In our case it will be only database name is dynamic. Now we have to specify the user ID and password here. So let me provide the user ID and password. Test the connection here. Connection succeed click on create. So it will create a new linke service and this is the dynamic linke service azure SQL underscore EMV. So it is created now but this is the static. Now we want to make this as dynamic. So let me click on that again and now here we can see the database server and authentication type everything we can make this dynamic from here. If you can click on this here we can see the option to add dynamic content. Let me click on that. So here as we can see we don't have any parameter because we did not create any parameter. So either we can create the new parameter from here by clicking on this plus symbol and this parameter scope will be limited under this linke services. So we can create the parameters as I told you on the linke service level on the pipeline level and on the dataset level. So here we are going to create this as linke service level. So if you can scroll down side and here we will be having options for the parameter either we can create from there or we can create from here. So let me click on new. Now we can call this as server name. Let me add another parameter and this will be the database name. Let me add one more. So this will be the user ID or the login ID then the password. So these three parameters we have passed. So if you can go upside and here we can see the database. So let me click on that and here we can see the add dynamic content. Let me click on that. So instead of getting the static values we want to get these values from the parameter. So this is for the database. So we can click on the database. So it is getting like here you can see the link service dot database name. So it is referring like this database name parameter is coming from the linke service only. Let me click on okay. It is not selected. Let me go and select it again like the database name. Click on okay. So here we can see the database name which we have specified ssu div static value but this time it is coming from this parameter. Do the same thing for the server name as well. So server name click on okay. It is loaded. Now here we can see the username. So here we have the user ID. So we can add that click on okay. Now we can see the password. So let me add the password parameter as well. Click on okay. Everything we have selected and by default value we did not pass anything here. Now we want to test the connection. So click on the test connection. Here it is required to pass all those values. So first we have to pass the server name. So this is the server name. Then with the database name. So let me pass the database name as ssu div. Then the user ID and user ID will be pvi and then the password. So let me add the password here and click on okay. So it is testing the connection. So test connection succeed. So it is able to make the connection with the div environment. Let me try to test the another one. So click on test connection again. Here instead of div let me have the ssu uat and click on okay. So it is testing the connection for the uat and connection succeed. So that looks good. Click on test connection again and this time I want to test the connection for the prod one. Now click on okay. So it got succeed. So it is working fine. So let me click on apply. So we have making the changes under this link service and we have make this as dynamic. So if we can go here again. So here we can see the first parameter that is dynamic. The second that is again dynamic third and fourth. So we have created these four parameters and we are using these parameters under this link service. So I hope guys you have understand how we can make the link service as dynamic. In the next video we will be going to see how we can make the dataset as dynamic. So thank you so much for watching this video. If you really like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.