Daasity Knowledge Base
Ask or search…
K

Microsoft SQL Server Database

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

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