WeChat-Image_20220609143550

Watch Out Google Group “Moderation”, It May Holds Your Group Emails Without Notifications.

Google Group owners are able to moderate the messages sent to their members to protect them from junk mail. Moderation is not active by default and should be set up as appropriate by the group owner. Owners and managers are generally granted permission to determine which messages should be allowed to be sent to group Read More

WeChat-Image_20220609143550

How to Load Data from an OData Feed into Power Query Desktop and Online

Summary Item Description Release State General Availability Products Power BI (Datasets)Power BI (Dataflows)Power Apps (Dataflows)ExcelDynamics 365 Customer InsightsAnalysis Services Authentication Types Supported AnonymousWindowsBasic (requires Gateway)Web APIOrganizational Account Function Reference Documentation OData.Feed, ODataOmitValues.Nulls  Note Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities. Load data from an OData Read More

WeChat-Image_20220609143550

Understand OData Connection Manager in SSIS

Applies to: SQL Server (all supported versions)  SSIS Integration Runtime in Azure Data Factory Connect to an OData data source with an OData connection manager. An OData Source component uses an OData connection manager to connect to an OData data source and consume data from the service. For more info, see OData Source. Adding an OData Connection Manager Read More

WeChat-Image_20220609143550

How to Import Data from OData to Azure Data Factory

by Gauri Mahajan In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories. Introduction Data practice has the following major part – Data Collection, Data Preparation and Curation, Data Management, and Data Consumption. Typically, data consumption is viewed as a practice of accessing data Read More

WeChat-Image_20220609143550

How to Set up SQL Data Sync Between Databases in Azure SQL Database and SQL Server

In this tutorial, you learn how to set up SQL Data Sync by creating a sync group that contains both Azure SQL Database and SQL Server instances. The sync group is custom configured and synchronizes on the schedule you set. The tutorial assumes you have at least some prior experience with SQL Database and SQL Read More

WeChat-Image_20220609143550

Features Comparison: Azure SQL Database and Azure SQL Managed Instance

APPLIES TO:  Azure SQL Database  Azure SQL Managed Instance Azure SQL Database and SQL Managed Instance share a common code base with the latest stable version of SQL Server. Most of the standard SQL language, query processing, and database management features are identical. The features that are common between SQL Server and SQL Database or SQL Managed Read More