Custom service using set based operations

Sometimes you just need a fast way to get data from F&O for real time processing of data. We were debating the architecture and exporting data to a data warehouse was not meeting one of the requirements which was speed. They need the data to be up to date in real time. My solution to this was to use set based operations to fill a temporary table and to expose the data in the temporary table in the service. I am very happy with the performance of this service and definitely recommend using this pattern to everyone out there.

Let's start.

Create a temporary table.

Create a temporary table with the fields that you will need to expose. Set the Table Type property to TempDB.

Create a custom service

The service will expose the data as an endpoint.

To be continued...