Datawarehouse for FE data

Ellen Hackeman

We want to connect a data warehouse to FENxt. Has anyone written Sky API calls for pulling basic G/L data into a warehouse and periodically updating?

Lauren Marcus Eisenberg

Following!

Kyle Lewis

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

Ellen Hackeman

@Kyle Lewis Thanks for the reply. We are all set at the moment. We were looking at connecting Domo and the api calls would work should we have decided to pursue. But we are going in a different direction now. Thanks again!

Alex Wong

@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

@Alex Wong
What connector do you use to make the SKY API calls?

Alex Wong

@Kyle Lewis
Blackbaud Add-ins Send HTTP request

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