Real integration, automation, and reporting projects — what the problem was, how we fixed it, and what you can take from it. Written by the people who built them.
A fabrication shop moved job tracking to the cloud, but its label printers sit on the shop network where the cloud can't reach them. Here is how a small device next to the printers solved it without a VPN or firewall change.
Read article →Your team works in Excel on SharePoint, but reporting needs the data in SQL. Here is how we keep the two in sync automatically, and why we moved an older sync off stored passwords and onto Microsoft Graph.
Read article →Your Azure token works, but D365 F&O still says no. Here's the second registration most API setups miss, with least-privilege access.
Read article →We resell a cloud backup service, and every billing cycle meant reading vendor receipts and retyping them into QuickBooks Online invoices. Here is how we automated it end to end, and the safeguards that let us trust it.
Read article →Every week someone opens a workbook, filters it by region, saves copies and emails each regional team. We automated the whole routine on the client's existing SQL Server, with a safe test mode and a log of every decision.
Read article →