← sources

Secondary data warehouse

source: reddit (reddit:database)published 2026-11-18 18:08ingested 2026-11-19 02:39

retained text

We are looking for a simple secondary data warehouse...

We are not IT professionals, and we do not want to hire an external expert for every single task.  
We need an application designed for individuals with a general understanding of IT.

We intend to use this secondary data store to cross-reference data from various sources, perform simple calculations, and send cleaned data to secondary applications.

Requirements:  
\- 90% of our data is in MS SQL.  
\- We need simple, direct integration with MS SQL (IP, port, password), the ability to select tables to transfer to the secondary data store, and the option to set a refresh frequency...

The secondary data warehouse must include:  
\- The ability to create simple queries, apply filters, and establish relationships between tables...  
\- The ability to easily integrate with external applications (CRM, BI, AI agents, reporting, etc.)...

What do you recommend?

document fetched 2026-11-19 00:39 · canonical https://reddit.com/r/Database/comments/1xzm8f0/secondary_data_warehouse