Integration: Microsoft SQL Server Database

This article will help you learn about how Daasity replicates data from a Microsoft SQL Server database, limitations to the data we can extract and where the data is stored.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

Integration Overview

Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

Integration Availability

This integration is available for:

  • Pro V2

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to

Integration Details

Daasity connects to Microsoft SQL databases via an ODBC connector.  Some key notes on the Daasity method for data replication:

  • A user will be needed that has read permissions in the Microsoft SQL database.  This user will access via ODBC and execute the data replication
  • Data replication is performed by running SQL queries against the Microsoft SQL database
  • The DDL is read at time of initial setup and sets the definitions for all the tables.  If tables are added, deleted or modified please contact Daasity Support

Related Resources