We’re excited to announce the Public Preview of the Azure Databricks connector in Energy Platform. The brand new connector is a game-changer for organizations seeking to seamlessly combine Azure Databricks with Microsoft’s low-code ecosystem-including Energy Apps, Energy Automate, and Copilot Studio. This connector bridges the hole between superior analytics and enterprise course of automation, enabling safe, ruled, and real-time information entry – with out the complications of customized connectors or information duplication. That is all made doable by the foundations of the Databricks SQL information warehouse, a product purpose-built for analytics, and Azure Databricks, a primary get together service totally built-in inside the Azure and Microsoft ecosystem.
The Problem Earlier than: Workarounds, Information Silos, and Governance Gaps
Earlier than this connector, connecting Energy Platform purposes to Azure Databricks was irritating. Groups needed to depend on customized connectors, REST APIs, or oblique information exchanges by storage accounts and orchestrated pipelines. These workarounds usually led to information duplication, required handbook upkeep, and weren’t capable of leverage governance supplied by Unity Catalog. In consequence, this slowed groups’ potential to innovate.
What’s Now Potential: Actual-Time, Safe Information for Each Energy Platform App
The brand new Azure Databricks connector solves all of those challenges.
No Information Duplication: All interactions occur in actual time, immediately in opposition to Azure Databricks tables-eliminating the necessity for information exports, making certain a single supply of reality.
Authentication: The connector leverages Microsoft Entra ID (previously Azure AD) for safe authentication, supporting each user-based OAuth and repair principals.
Governance: Depend on Unity Catalog’s fine-grained entry controls immediately inside Energy Platform apps-no twin safety fashions or handbook coverage syncs required. Auditing capabilities can be found by Question Historical past.
Straightforward Setup and restricted upkeep: From Energy Apps, Energy Automate, or Copilot Studio, merely choose the Databricks connector, authenticate, and begin constructing. No customized API plumbing or upkeep required.
This allows organizations to construct data-driven experiences that leverage the complete energy of their information inside Azure Databricks. Let’s have a look:
I. Energy Apps: Construct low-code canvas apps that may learn and write (create, replace, and delete) information in real-time.
II. Energy Automate: Create workflows that execute SQL instructions in opposition to your information in Azure Databricks information
III. Copilot Studio: Construct customized brokers with Azure Databricks because the information supply
Fixing Actual-World Use Circumstances: Quicker Innovation, Maintained Governance, and No Information Duplication
Now, Azure Databricks clients who leverage the Energy Platform connector can expertise a simplified potential to construct Energy Platform purposes with their information in Azure Databricks.
Reworking Warehouse Security: Coty’s Energy Platform Success Story
Take Coty, who’s a worldwide magnificence powerhouse identified for its iconic manufacturers and daring innovation. They leverage Energy Platform to construct business-critical Energy Apps and automation workflows.
A very good instance is their software to trace warehouse security incidents, developed by one in all their Digital Resolution Builders, Victor-Hugo Fantasia, which performs a vital position in retaining warehouse staff protected. Earlier than Energy Platform, warehouse groups used to depend on handbook reconciliation throughout paper types and siloed Excel recordsdata to log security occasions. This led to frustration, delays and misplaced information.
Now with Energy Platform, staff can report security incidents in seconds. If any high-risk incidents are reported, automation workflows instantly set off notifications to security leads. All submissions feed real-time dashboards and supply managers a 360-degree view into security efficiency.
This easy answer has pushed compliance charges up dramatically, reduce information reconciliation time, and enabled every day security evaluations, empowering groups to handle hazards quicker and enhance web site security throughout the board.
“I by no means thought connecting to our information lake might be as simple as connecting to a SharePoint checklist. With the Azure Databricks connector in Energy Apps, our group can now spin up customized apps to seize and approve planning information, monitor security incidents in actual time, streamline transportation buyer claims, and feed actual‑time dashboards utilizing minimal code, with nearly no studying curve. This streamlined strategy will considerably cut back implementation time and allow us to give attention to fixing enterprise issues quicker!”
— Michael Gibson, Provide Chain Digital Options Supervisor, Coty
Empowering Groups with Expertise: UK Energy Networks’ Wider Name Dealing with App
Or take UK Energy Networks, a number one electrical energy distributor identified for its dependable service and dedication to powering hundreds of thousands of houses and companies throughout the UK. In an business the place fast response and clear communication are essential, UK Energy Networks has embraced know-how to assist its groups and ship higher outcomes for purchasers.
A chief instance is their Energy App developed particularly for Wider Name Dealing with (WCH), which is a system designed to assist name handlers throughout excessive demand intervals attributable to opposed climate. The WCH Energy App transforms how UKPN helps affected clients. As a substitute of counting on handbook processes, the app supplies an enhanced, streamlined strategy to proactively handle communication and help with these impacted by outages or disruptions. Name handlers can simply replace clients, coordinate responses, and guarantee well timed info and assist, all from a central, user-friendly platform.
“Integrating the Databricks connector inside the Energy Platform has been game-changing for us at UKPN. It permits us to harness Azure Databricks’ superior efficiency and massive information capabilities alongside the agility of low-code options, delivering important worth throughout the enterprise.
This integration has additionally helped us keep momentum in our Digitisation technique, enabling us to seamlessly re-point current Energy Platform deliverables from legacy back-ends to cutting-edge applied sciences.”
— Karime Slimani, Lead Information Engineer, UK Energy Networks
How It Works: Safe, Ruled Connectivity-No Customized Code Required
Organising the Azure Databricks Energy Platform connector is designed to be easy and safe:
Open Energy Apps or Energy Automate
Go to the ‘Connections’ web page inside this software
Click on ‘+New Connection’ and seek for Azure Databricks
Authenticate to Azure Databricks utilizing OAuth or a Microsoft Entra Service Principal
Begin constructing – canvas energy apps, automation workflows, and copilot studio brokers with Databricks as a information supply
Strive It Out: Get began with Azure Databricks Energy Platform Connector
The Energy Platform Connector is now obtainable as Public Preview for all Azure Databricks clients. Discover extra within the deep dive weblog right here and to get began, try our technical documentation.
