Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft SQL Server Connector
  3. Connections for Microsoft SQL Server
  4. Synchronization tasks with Microsoft SQL Server Connector
  5. Mappings and mapping tasks with Microsoft SQL Server Connector
  6. Replication tasks with Microsoft SQL Server
  7. Data type reference

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Introduction to Microsoft SQL Server Connector

Introduction to Microsoft SQL Server Connector

You can use Microsoft SQL Server Connector to connect to Microsoft SQL Server databases from
Data Integration
. You can read data from or write data to the Microsoft SQL Server databases.
You can also use a Microsoft SQL Server connection to connect to the following databases:
  • Microsoft Azure SQL Database
  • Audit-enabled Azure SQL Database and pre-V12 Azure SQL Database
  • Azure SQL Database from Secure Agents deployed on Azure virtual machines
  • Azure SQL Database managed instance
  • Amazon RDS SQL Server and Azure SQL Server private endpoints on virtual networks
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.

0 COMMENTS

We’d like to hear from you!