Web activity response timeout improvement

Web activity response timeout improvement

This article is contributed. See the original author and article here.

Web activity is helpful when invoking an external endpoint from within an ADF pipeline. While Azure Data Factory/ Synapse pipelines offer various orchestration activities, web activity helps provide extensibility when building data pipelines that span across different services. 


 


Web activities work exceptionally well with APIs that follow the asynchronous request-reply pattern, a suggested approach for building scalable web APIs/ services. In such scenarios, it automatically polls for the status endpoint (when it receives HTTP 202) till the API returns HTTP 200. It behaves synchronously and waits till the response is HTTP 200 before kicking off the down-stream activities. 


 

async-request.png



Most Azure-based APIs are async request-reply pattern and gels with the existing web activity behavior. 


 


Problem


But in case you have API endpoints that do not follow the above pattern and expect the caller to wait for a response till the processing/ actions are done. As default action, the web activity will timeout within 1 minute if it does not receive any response.  


 


Improvement


We are introducing a response timeout property ‘httpRequestTimeout’ in Web activity that will let you provide larger timeouts for such synchronous APIs.  


 


Screenshot 2022-03-17 at 9.33.41 AM.png



 


Reference: 


Web Activity – Azure Data Factory & Azure Synapse | Microsoft Docs

Total Economic Impact of Dynamics 365 Supply Chain Management

Total Economic Impact of Dynamics 365 Supply Chain Management

This article is contributed. See the original author and article here.

As discussed in our previous blog, Microsoft Dynamics 365 was recognized as a leader in Gartner’s 2021 Magic Quadrant for Cloud ERP for Product-Centric Enterprises. This month, we want to further substantiate our value proposition to customers by sharing the results of a recently commissioned Total Economic Impact (TEI) study conducted by Forrester Consulting on behalf of Microsoft. The study examines the potential return on investment (ROI) that enterprises may realize by deploying Microsoft Dynamics 365 Supply Chain Management.

Methodology and purpose

TEI is a methodology developed by Forrester Research to assist companies with technology-related purchase decisions by helping technology vendors effectively communicate the value proposition of their solutions. The purpose of a TEI study is to provide business decision-makers with a framework to evaluate the potential financial impact of implementing Dynamics 365 Supply Chain Management.

Forrester Consulting interviewed five organizations that used Dynamics 365 Supply Chain Management to conduct the TEI study. The characteristics of these businesses and the results of the interviews were then aggregated to develop a composite organization. The key findings of the study are based on the composite organization and are summarized below.

Key findings

Dynamics 365 Supply Chain Management is a solution that is helping product-centric organizations to revamp their existing enterprise resource planning (ERP) platform and it enables customers to considerably increase supply chain visibility. It also empowers users to plan better, improves organizational agility, and maximizes asset uptime, allowing companies to operate smoothly and profitably.

Forrester’s study revealed five quantifiable impact areas: increased production volume, reduced downtime, improved quality, reduced infrastructure cost, and increased developer productivity.

Let’s look at each of these areas in more detail to examine how Dynamics 365 Supply Chain Management delivers value across enterprise supply chains.

Increased production volume

Dynamics 365 Supply Chain Management empowers users to improve demand planning by enriching demand forecasting with AI. It also allows companies to deliver production schedule visibility to the shop floor and to dynamically rebalance production schedules based on real-time material, labor, and equipment availability. These improvements translate into more responsive planning and scheduling, an improved synchronization of supply and demand, and the identification and minimization of production bottlenecks. The result for customers is increased production throughput that was worth $24.3 million over a three-year time horizon.

Reduced downtime

Our solution also enables users to create a connected factory and proactively manage the shop floor using a real-time view of production and inventory. This is one reason why customers surveyed by Forrester reported substantial increases in data collection from their supply chains. This data improves visibility into asset utilization and resource availability and provides a systematic means of identifying root causes of machine downtime.

Dynamics 365 Supply Chain Management also provides the ability to rapidly respond to quality issues and parts obsolescence with engineering change management. The organizations in Forrester’s study leveraged these capabilities to reduce costly downtime of business-critical production equipment, which improved overall equipment effectiveness (OEE) and ensured that production lines can run as scheduled 24x7x365. For an organization with 500 manufacturing machines, this reduction in downtime was valued at more than $1.5 million over three years.

Improved quality

Interviewees further noted that Dynamics 365 Supply Chain Management allowed their organizations to uncover new pathways for improving product quality. In particular, real-time production data provided the means for understanding when variations in raw material quality or machine operating characteristics were impacting quality. And, because they were able to make immediate decisions, they could ensure that quality was maintained.

By taking actions to improve adverse conditions in real-time, scrap rates declined, and root causes were identified, allowing these organizations to avoid unnecessary losses while simultaneously improving production quality. Over three years, the improvements to product quality reduced costs by more than $6.8 million.

Reduced infrastructure cost

A critical improvement point for the organizations studied by Forrester were the gains realized by retiring multiple legacy applications that were often on-premises, highly-customized, disparate, and disconnected. By migrating systems and processes to a modern cloud-based solution, users were able to pay less for server maintenance and system administration as well as avoid the significantly higher cost that would have been incurred to scale their prior solutions. These infrastructure cost reductions totaled $11 million in three years.

Increased developer productivity

Dynamics 365 Supply Chain Management takes advantage of Microsoft Power Apps to reduce customization costs by utilizing low-code/no-code extensions. Plus, it delivers operational application services by running on the Microsoft Azure cloud, significantly reducing the need for developers and technical staff to focus on system administration. By freeing up these resources to deliver other, higher-value work, the financial impact of productivity improvements is projected to be approximately $0.7 million over three years.

Unquantified benefits

Study participants also reported other substantial organizational benefits that were unquantifiable in nature. These include increased flexibility to adapt, improved ability to deliver on-time, improved customer satisfaction, better forecasting capabilities for improved supplier collaboration and planning, and improvements to team members’ day-to-day work realized by breaking down siloes between teams and functions.

The big picture

As we have seen here, Forrester’s study uncovered five quantifiable impact areas as well as several unquantified benefits. When these are considered in combination, Dynamics 365 Supply Chain Management delivered a total economic impact of $44.33 million in financial savings over three years. At $23.27 million, the investment provided a ROI of 90 percent and took 22 months to pay back.

Read the full report: A Total Economic Impact of Microsoft Dynamics 365 Supply Chain Management

What’s next?

Dynamics 365 Supply Chain Management is an agile and composable ERP solution. It enables manufacturers, retailers, and distributors to create a connected, resilient, and digital supply chain by enhancing operational visibility, improving planning agility, and maximizing asset uptime. In addition, it unifies data from almost any source in real-time and generates intelligence by leveraging AI and machine learning to proactively detect opportunities and develop a long-term competitive advantage.

We recently sat down with an analyst from Forrester to discuss the Total Economic Impact of implementing Dynamics 365 Supply Chain Management. You can view the discussion in our on-demand webinar: Build a resilient and sustainable supply chain. If you are ready to see what our modern, cloud-based supply chain management solution can do for your organization, we invite you to start today with a free Dynamics 365 trial.


Sources:

Forrester. The Total Economic Impact of Microsoft Dynamics 365 Supply Chain Management. August 2021.

The post Total Economic Impact of Dynamics 365 Supply Chain Management appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Benefit from Azure Arc-enabled SQL Managed Instance, even without a direct connection to Azure

This article is contributed. See the original author and article here.

Azure SQL Managed Instance is an intelligent, secure, and scalable cloud database service with the broadest SQL Server engine compatibility with all the benefits of a fully managed and evergreen platform as a service. With Azure Arc, you will now be able to deploy, manage, and monitor Azure SQL Managed Instance in an environment of your choice, outside of Azure. Azure Arc-enabled SQL Managed Instance has near 100% compatibility with the latest SQL Server database engine, and it will enable existing customers to lift and shift their applications to Azure Arc data services with minimal application and database changes while maintaining data sovereignty. 


 


Azure Arc-enabled SQL Managed Instance can be deployed at the edge, in your own datacenter, and in public clouds using Kubernetes and the infrastructure of your choice. Azure Arc-enabled SQL MI receives updates on a frequent basis, including servicing patches and new features similar to the experience in Azure. You will be able to scale your databases up and down dynamically in very much the same way you would do it in Azure, depending on the available capacity and resources of your Kubernetes clusters. 


 


Azure Arc-enabled SQL Managed Instance provides also other cloud benefits such as fast deployment and automation at scale. You will also be able to use familiar tools such as Azure portal, Azure Data Studio, and Azure CLI when you deploy, manage, and monitor your Azure SQL Managed Instance in your own environment, and you will be able to use tools like Azure Monitor for comprehensive operational insights across all your databases across hybrid and multicloud environments. 


 


Directly connected mode is one of the two different connectivity modes in Azure Arc-enabled data services. In this connectivity mode billing and inventory data is sent to Azure automatically. The data in your databases is never sent to Azure. 


 


How about a scenario where your data center does not allow connectivity to any public internet, or you have an edge location which does not have connectivity to the Internet, or the connectivity may be intermittent with long periods of outages?


 


In this scenario, you can deploy Azure Arc data controller in indirectly connected mode. Most of the services such as self-service provisioning, automated backups/restore, and monitoring can be run locally in your Kubernetes infrastructure. You would be using tools such as Azure Data Studio, Azure CLI, or Kubernetes native tools for self-service provisioning. Automatic upgrades and patching can be implemented by pulling the container images of Azure Arc-enabled SQL MI from Microsoft Container Registry, and pushing them to a local, private container registry that the data controller has access to. 


 


Indirectly connected mode supports automatic local backup and restore, and you can use the locally deployed Grafana and Kibana dashboards for monitoring. 


 


Read more about the connectivity modes of Azure Arc data services and try out Azure Arc-enabled SQL Managed in your own environment!


 


Marko Hotti


Sr. Technical Product Manager


Azure Arc-enabled SQL MI and SQL Server


Azure Data


 


 


 


 


 


 

3 ways to meet new hybrid expectations with Microsoft Teams and Microsoft 365

3 ways to meet new hybrid expectations with Microsoft Teams and Microsoft 365

This article is contributed. See the original author and article here.

Five years ago, we embarked on an exciting journey with Microsoft Teams, building a hub for collaboration and teamwork. Video meetings were not the workplace norm, but it was clear from the beginning that the combination of async and sync collaboration in a single product presented a unique opportunity to reimagine how we work, learn, and connect with others.

The post 3 ways to meet new hybrid expectations with Microsoft Teams and Microsoft 365 appeared first on Microsoft 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.