SSIS Catalog Migration Wizard (SCMW) grants you more control to migrate SSISDB catalog objects from one server to another. SCMW file type SCMW file type is an export format of the SSIS Catalog Migration Wizard. It can act as a backup or a stage deployment file for cross-server migrations. Associate SCMW file type to this …
Confluent Cloud provides ksqlDB, a streaming SQL engine for Kafka. It is an easy-to-use yet powerful interactive SQL interface for stream processing on Kafka, In this article, we will see how to automate Confluent ksqlDB deployments using ksql-migrations.
In this article, we will see how to call a notebook from another notebook in Databricks and how to manage the execution context of a notebook.
Azure Data Factory uses Integration Runtimes as a compute infrastructure to execute data movement and data transformation activities. This article describes how to set up Azure Data Factory Shared Integration Runtime.
To secure connection details in data factory, we can store credentials in the Azure key vault and access them in Azure data factory. This article describes how to access Azure key vault secrets from Azure data factory linked services.
This article describes how to get local time zone date in Azure SQL database using an user defined scaler function and AT TiME ZONE.
Microsoft has enabled support for accessing Microsoft Graph API from Azure data factory. In this article, we will see how to call Graph API from Azure data factory using the managed identity.
This article describes how to share Power BI reports with external users using Azure B2B.
In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.
Migrate Azure data factory from one resource group to another using these 3 simple steps.
Are you planning to migrate your SSIS Catalog to a newer version of SQL Server? You might like to know if your SSIS Catalog has any issues. Some of the most common issues in SSIS catalog could be: SSIS projects have orphan environment references. Project or package parameter refers to environment variables that do not …