Evil Kraig,

Since my initial post we have developed an approach to those issue. We have started developing a data warehouse where we're extracting the needed transactions. We have not implemented this solution in production but we will in the following months.

Thank you for your post.