Hello all,
Looking into converting one of our companies from their JobBoss system to Epicor. Has anyone accomplished this in the past and if so, what type of tools did you use? I’m assuming the DMT tool might be the best route, but wanted to know if others have done this in the past. Thanks!
Move a small company on JobBoss into our Epicor environment in 2019. Used SQL to get the extraction and transformation of data and then DMT to insert into Epicor.
Also did that a few years ago. DMT was the way to go, csv artifacts are a great fit for an audit trail. Except for a couple of things that DMT bugged out on, which I moved over REST and that wasn’t a big deal. I probably have notes and work lurking way way back in a git repo…
We moved from JobBoss to Epicor back in 2016. Like @kananga and @Nicholas_Mueller said, you can pull data from JobBoss using SQL tools, and upload with DMT.
Thank you everyone. Looks like running SQL scripts and importing with the DMT is the way to go.
I havr a powershell scrip that allows you to automate the process based on the DMT PS code, but allows you to run through a list of sps or views to build d the data,.
Out at the moment but can share the link
That would be awesome. Thanks!
Here is a link. It should point you in the right direction.
If it does not work drop me a line.