Hello,
the end user I currently work for has a solution built around AX2012 for feeding data into a data warehouse. It is a bit archaic and dates back all the way to AX3.5 days.
To summarize there are a number of MSSQL DTS (Data Transformation Services) packages which query various AX tables (mainly CofA, Dimensions, ledgertrans), populate intermediate tables with the required data and then perform certain additional conversions before finally exporting the data to flat files. The packages are launched relying on SQL Server jobs and the whole process is managed by a green screen scheduler running on mainframe technology. The process is cumbersome and a real pain to maintain.
The reason DTS this was chosen over implementing all the transformation logic in X++ was performance. Though this reasoning was a decade ago and may now be obsolete.
We are currently thinking of implementing some major changes in the extraction logic and that is a good opportunity to possibly rebuild everything. My question is: what alternatives would you consider? A couple of options I see are moving all the logic into X++ or utilizing Biztalk. We are in the process of considering an upgrade to 365 possibly with 12-18 months. Is there a better alternative in 365? Perhaps it is better to stay with the cheap and dirty alternative for now and rebuild when we upgrade to 365?
Best regards,
Grzegorz
