Inkey Solution Logo
banner

Blogs

Split the Text files using ADF Pipelines

, November 29, 202469 Views

Requirements: If the file size of an Excel file exceeds the specified criteria, we need to address the following: The Excel file contains multiple sheets, and these sheets contain inter-related data. We utilize SQL Views to retrieve data from these sheets using the “Get Data” activity in Excel. Although we can split the Excel file […]

Read more

Copying Excel files from source to destination in Excel format using ADF Pipeline

, August 16, 2024394 Views

As Azure Data Factory (ADF) does not offer Excel as a sink option, an alternative method is required to copy Excel files using ADF pipelines. Implementation Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field list to include […]

Read more

Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF

, August 2, 2024457 Views

The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data activity in Azure Data Factory (ADF) pipeline. Implementation: Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field […]

Read more

Harnessing Innovation with Microsoft Azure Services

, April 23, 2024532 Views

The world of cloud computing has completely transformed how businesses operate and innovate. Microsoft Azure stands out as a leading cloud platform, by offering unmatched scalability and agility to organizations all over the globe. Our Microsoft Azure services encompass a wide range of offerings, from deploying infrastructure to modernizing applications. Whether you’re migrating to Azure, […]

Read more

Implementing ADF Branches and Filters for Employee Training

, March 22, 2024460 Views

In one organization, there is one analysis of employee’s performance on different technologies based on the technologies they know and ratings from their manager. If they don’t meet the required criteria, then that employee will get training for those technologies. Input: emp_id MSBI PowerBI ratings from the manager 101 null x 3 101 null null […]

Read more

Copy Data Dynamically From Multiple Sources To Multiple Sinks In ADF

, December 5, 20232048 Views

In this blog we are going to learn how to implement Dynamic Mapping to copy data from multiple sources to sinks in ADF. The below attached images show that there are 2 pair of source-destination tables. Now the source table is holding some data while the destination tables is blank, but its schema is similar […]

Read more

Access SharePoint Online Data Using Postman Part 2

, March 11, 20224800 Views

Now, in this blog we will see how to access SharePoint online data.  In this example, we will resize SharePoint Online image by using the Microsoft Graph API via SharePoint using the /_api/v2.0.  We need to specify the size; large, small, and medium; in the request URL to resize the image that would give us […]

Read more

Access SharePoint Online Data Using Postman Part 1

, February 3, 202213558 Views

In this blog, we will show you how we can interact with SharePoint via Rest APIs and perform actions like adding, updating, deleting, and fetching data using Postman.   We are using two operations SharePoint App Registration and Azure AD app (Graph API).  The important factor is Authentication and Authorization while accessing SharePoint information.  Generate […]

Read more

Make Microsoft Azure Function App editable or read-only

, May 9, 201914724 Views

There are basically two ways to create and publish the Function App in the Microsoft Azure. One of the ways is to create the Function App directly in the Microsoft Azure and publishing it from there itself. The second way is to create the Function App in the Visual Studio and publishing it from the […]

Read more

Azure FunctionApp Error: The binding type(s) ‘serviceBusTrigger’ are not registered[SOLVED]

, April 11, 201914541 Views

At times we are stuck with issues which look very clear but takes everything out of you to resolve them. Recently, I had faced one of them during the deployment of one of my FunctionApp at Azure. Actually, I had to deploy a FunctionApp from the VisualStudio. I deployed it successfully but while selecting the […]

Read more

Would you like to digitize your business and put it on the cloud?
Do you need clear, concise reports for your organization?