Swiss Re selected Azure Synapse Analytics with Power BI for enterprise Analytical & BI solution for faster, more efficient analysis and deeper insights. After implementing Azure Synapse Analytics with Power BI, it loads data almost 40 percent faster than that of loading data in on-premises system allowing to load fresh data more often. โThis not… Continue reading Azure Synapse Power BI: How Swiss Re uses Azure Synapse Analytics with Power BI for faster, deeper and better insight
Tag: analytics
Azure Synapse Tutorial: Three In ONE Service
This Azure Synapse Tutorial contains below topic: What is Azure Synapse Analytics? Azure Synapse Analytics brings together data integration, data warehousing and big data analytics under an umbrella dramatically reducing the time to build an analytics solution & accelerating the time to insight. Azure Synapse Analytics Workspace: Video Link for this Azure Synapse Tutorial: More… Continue reading Azure Synapse Tutorial: Three In ONE Service
MERGE command in Azure Synapse Analytics Dedicated SQL pool
In this article we will understand the features of MERGE T-SQL command and have a quick demo on Source table to Sync with target dimension table in Azure Synapse Analytics Dedicated SQL pool. MERGE T-SQL command for Azure Synapse Dedicated SQL pools is now Generally Available MERGE T-SQL feature: It combines INSERTs/UPDATEs/DELETEs into a single… Continue reading MERGE command in Azure Synapse Analytics Dedicated SQL pool
Microsoft Azure Unified Data and Analytics Architecture
๐๐ข๐๐ซ๐จ๐ฌ๐จ๐๐ญ ๐๐ณ๐ฎ๐ซ๐ ๐ง๐๐ญ๐ข๐ฏ๐ ๐ฎ๐ง๐ข๐๐ข๐๐ ๐๐๐ญ๐ ๐๐ง๐ ๐๐ง๐๐ฅ๐ฒ๐ญ๐ข๐๐ฌ ๐ฉ๐ฅ๐๐ญ๐๐จ๐ซ๐ฆ: ๐๐ซ๐๐ก๐ข๐ญ๐๐๐ญ๐ฎ๐ซ๐ Let’s have a quick view on the sample use cases and architectural components of this Unified Data and Analytics platform using Azure native data services. This architecture consistent of all components From data source to staging blob storage via ingestion and Subsequently clean and transformation, Stores… Continue reading Microsoft Azure Unified Data and Analytics Architecture
Azure Data Factory and Synapse Analytics introduces a response timeout property HTTP Request Timeout in Web Activity
Recently Azure Data Factory & Azure Synapse made API response timeout improvement in Web Activity by introducing a response timeout property ‘Http Request Timeout‘ in Web activity to provide larger timeouts for synchronous APIs. Web activity is used to invoke an external API endpoint from within an ADF/Synapse pipeline. It works well with async or… Continue reading Azure Data Factory and Synapse Analytics introduces a response timeout property HTTP Request Timeout in Web Activity
Azure Data Factory and Synapse Analytics provides new tabbed layout UI to setup of Azure Integration Runtime
Now Microsoft Azure Data Factory & Synapse Analytics provides Clean & Simple new tabbed layout UI to create/edit Azure Integration Runtime. This new tabbed UI makes it easy and simple to create/edit the Azure Integration Runtime. This new UI layout is available both in Azure Data Factory and Azure Synapse. There are 3 integration runtime… Continue reading Azure Data Factory and Synapse Analytics provides new tabbed layout UI to setup of Azure Integration Runtime
Azure Data Factory data flows: ‘incremental extract’ feature allows to read only changed rows on Azure SQL DB sources
Azure Data Factory introduced new feature in data flow: ‘incremental extract’ allows to read only rows that changed (delta or incremental data) on Azure SQL DB sources using mapping data flow. Currently this feature is in Public Preview. This feature is one of the ways to the implement ‘Incremental ETL’ and ‘CDC – Change Data… Continue reading Azure Data Factory data flows: ‘incremental extract’ feature allows to read only changed rows on Azure SQL DB sources
Microsoft Azure Data Factory: Data Integration and Transformation for Warehousing and Analytics
Microsoft Azure Cloud Data Warehousing & analytics reference architecture: integrates large amounts of data from multiple sources into a Cloud Data Warehouse for analytics using Azure cloud native data services. In this reference architecture, we will use Azure Data Factory for data integration & transformation: “Azure Data Factoryis the cloud-based ETL and data integration service… Continue reading Microsoft Azure Data Factory: Data Integration and Transformation for Warehousing and Analytics
Azure Stream Analytics job now has new output option: Azure PostgreSQL (Preview)
Quick Update: Microsoft introduced new output option of Azure Stream Analytics job to Azure PostgreSQL (Preview): This new output option to Azure PostgreSQL allows customer to write output streaming/analytics data into relational database. With this new output, Azure Stream Analytics jobs write to Azure PostgreSQL Single Server, Flexible Server (Preview) and Hyperscale (Citus), supporting high throughput… Continue reading Azure Stream Analytics job now has new output option: Azure PostgreSQL (Preview)