Search code examples
sql-serverrestt-sqlssisdata-warehouse

Using SSIS :What is better between using REST API or querying a database directly?

I am working on creating a data warehouse for a client. To extract data, I can use :

  • Direct T-SQL queries to the production database
  • API/JSON

I want to know what is better concerning the data quality and performance between these two alternatives ?

Solution

  • If you are importing data from a SQL Server instance to another SQL Server instance (DWH) and you have the possibility to use SSIS, go with T-SQL or direct bulk operations you can find as components in the VS toolbox. SQL Server Source and SQL Server Destination should meet your requirements.