ODA User Guide

Data Sources

How Data Sources connect D365, Databricks, Delta Share, and ODA workflows.

Data Sources represent the original and intermediate systems that feed work performed in Optra. In this workflow, client data is first ingested from Microsoft Dynamics 365 (D365) into the client's Databricks bronze layer, where the raw operational data is retained as the handoff point between the source application and governed data workflows in Optra.

ODA does not connect directly to D365. Instead, ODA accesses the data through Delta Share, using the shared Databricks bronze data as the upstream source for Data Studio projects. This is an important architectural boundary: D365 remains the business system of record, Databricks bronze serves as the client's ingestion and persistence layer, and Delta Share provides the governed sharing mechanism that exposes the data to ODA in a controlled way.

Within Optra, Data Sources therefore act as the bridge between the Delta Shared datasets and the authoring experience in Data Studio. When users work with sources in projects, they are effectively working with data that originated in D365, was landed into Databricks bronze, and is now being made available to ODA through Delta Share for inspection, transformation, semantic modeling, and downstream job execution.

When a source is opened or refreshed, users can review its schema and sample data before configuring downstream pipeline steps.

During pipeline execution, the selected connected system provides the credentials and connection details needed to read the source through its supported connector. Delta Sharing allows ODA to consume client-managed Databricks bronze data through a governed sharing boundary.

Data Sources also provide reusable metadata for downstream pipeline steps and can be found through the platform's search and discovery features.