Datawarehouse for FE data

@Ellen Hackeman
I have. What do you want to know?

@Ellen Hackeman
Jan.22 post getting some love! =D

First the obvious: you cannot connect a data warehouse to RE NXT.

But you can create a few data sync-ing program (flow) to periodically sync FE data into a data warehouse.

I utilize a Azure SQL Server and define FE (and RE) database tables we need on the database. Then I use Microsoft Power Automate to create multiple data sync-ing flows that call SKY API endpoints and a SQL function call OPENJSON to insert the data into the tables in 4 hours sync intervals throughout the day. Some data will be iterative load, while some will be full dump each time depending on # of records. For example, we have 2.8M transaction distribution records, that is a iterative load, while we have 26K accounts which is a full dump each time. Here's a few screenshots:

@Kyle Lewis
Blackbaud Add-ins Send HTTP request

https://learn.microsoft.com/en-us/connectors/blackbaudskyaddins/#send-an-http-request