Import production data

Hi,

I managed to extract production data from our manufacturing PLC (number of cases produced, time, etc…) and store it in a SQL Server database. The process is real-time. The next step is to bring that finished inventory to Epicor automatically. Preferably I would like this to be linked to a job# so in essence I would be mimicking the “Job Receipt to Inventory” transaction.

Can anybody point me to the direction on how to program this: SQL, BPM? I have heard about Service Connect but I don;t have the module and it seems expensive.

Thank you,

Daniel