import data into Axapta automatically

Finance and Operations/AX Developer Forum
1

I need to know how to import data into Axapta automatically, we will have an existing system pumping data into SQL Server, we then need an automated process to import data from table(s) periodically (once or twice a day) into Axapta.

2

Hi, When it comes to importing data into Axapta it is always better to do this from inside Axapta - mainly for RecId generation, data validation etc. For automation this could be run as a batch. For inspiration, you might want to check this - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxap/html/axp_usingwebserv.asp and also article titled ‘Periodic Processing in Axapta’ there. Hope this helps, Harish Mohanbabu