Posts

Stepping into Event Streaming with Microsoft Fabric

(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media logs, website user interactions, and financial transactions. So, working with streaming datasets can place you in a different category of data engineering professionals, where you tend to understand the difference between Lambda and Kappa architectures, Kafka is more than a book writer to you, and topics are not only found in human conversations.  In my post last week ( https://datanrg.blogspot.com/2025/06/salesforce-cdc-data-integration.html ), I talked about Salesforce Change Data Capture (CDC) event data streaming, where the initial event destination was file storage in Azure. But what if we anticipate a higher volume of incoming Salesforce source data or the addition of a new data feed? This could create the need for an alternative method of managing incoming events. Image by  Florian Kurz  from  Pixabay

Salesforce CDC Data Integration

Logging in Azure Data Factory data flows

Dealing with Changing Data Formats: Schema Drift in Azure Data Factory

Data Masking with Azure Databricks

What I learned volunteering at a children's summer camp

Extracting PostgreSQL database metadata for presentation in Excel format

Don't Trust the Defaults

Handling physical deletes from the source and continue populating your analytical data store

Azure DevOps: Enterprise Power BI report deployment with connections to Shared datasets

Adding microseconds to a timestamp in Azure Data Factory

Using Azure Data Factory to read and process REST API datasets

Metadata-driven pipelines in Azure Data Factory | Part 4 - Analytical Processing

Thinking about data points and more …

Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source

Azure DevOps: Merging code to Main branch from a specific branch only

Including reference data into a database deployment process or passing lookup tables to Production

Metadata-driven pipelines in Azure Data Factory | Part 3 - Column Metadata

Populating PostgreSQL JSONB column using Azure Data Factory Data Flow

Metadata-driven pipelines in Azure Data Factory | Part 2 - Feed Configuration

Metadata-driven pipelines in Azure Data Factory | Part 1 - Data Copy

Fixing a giant or running a SQL Server project deployment with Temporal tables

Trusting the Fine Print or connecting Azure Data Factory with Salesforce

Can I create a CI/CD pipeline to deploy Python Function to Azure Function App using Windows self-hosted Azure DevOps agent?

“Could not find the modules: 'Az.Accounts' with Version: ''” error message and a story to remember

Fail activity in Azure Data Factory and Why would I want to Fail

Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?

Lambda Architecture in data systems and possible meaning of this name

Data Modeling at your fingertips

New Azure Data Factory home page, what's in it for me?

Executing Azure Data Factory pipelines by Power App / Automate Flow

Azure Function Drain mode