Oracle-to-ADLS batch pipeline using Azure Synapse Analytics ingests data from on-premises Oracle via Self-hosted Integration Runtime and Synapse Copy Activity into ADLS Gen2 Raw zone as Parquet. Synapse Spark Pool transforms raw data through cleansing and conversion, landing curated silver and aggregated gold zones in ADLS Gen2. Synapse Serverless SQL Pool serves analytics queries to Power BI dashboards, with Azure Monitor tracking pipeline health and performance. This medallion architecture separates ingestion, processing, and serving stages, enabling scalable data transformation while maintaining data lineage and governance. Fork this diagram to customize connector settings, add incremental load logic, or integrate additional data sources into your Synapse workspace.