AZURE

 TASK : Convert the XML format data into JSON Format and retrieve only the required data from it using Azure Logic apps. Sample XML data: This is the sample data, we need to convert this data into JSON first after that we need to perform Transformations. Expected output: Solution: Here I have taken a total of 4 activities HTTP trigger, Get blob content, and Compose. To trigger the logic app I have taken an HTTP trigger. Here I am retrieving an XML file from the blob by using the Get blob content Activity. After getting file content from the blog we need to convert the data format XML to JSON. So I have taken Compose activity and I have written Expression to convert XML to JSON. Expression :         After this activity, the entire data will be converted into a JSON format as mentioned below But we need to get the data from ENO to Position Title for that I have taken one more Compose activity and there I have written one expression to get the required data. ...

TASK: Loading Multiple JSON Files Into Azure SQL Using AZURE DATA FACTORY SOLUTION: In Azure first we need load the given files into blob ,after that we need to create a pipeline . The following will show you that entire pipe line diagram.  Here I have used several activities namely GETMETA DATA, FILTERS,FOREACH,COPY ACTIVITY, STORED PROCEDURES etc.           GETMETA DATA   à  it will give different properties of data , and it will give    acknowledgement for loaded multiple files.           FILTERS   à  Filters will used to filter the files based on the given requirements like   ‘File starting name’, ‘file ending name’ and some string functions etc.         FOR EACH   à  For each activity is loop the process means if we need to do same  operation more than one time at that time we will use FOR EACH Activity.       COPY ACTIVITY   à  ...