Hi everyone. I have been working on a proof of concept to import some log file data from our CNC machines. I have a process working using a combination of PowerShell script and SQL / BCP to import the data and it all works fine. The next stage is to make this accessible in EPICOR so I can match it…

I asked a similar question here: [image] DMT or SQL for UD ERP 10 I do not go into the SQL side to ever write things in Epicor. I have plenty of external views that I have written to read, but I use BOs and DMT to do my data injections. That being said, I have a large a…

Personally, I would look into using Rest calls to import your data into the UD Tables. there are built in business methods that will make sure that you did everything correct if you use the Rest service.

I think just don’t go there. Arguably UD tables are the lowest risk, but direct SQL is just not OK for Epicor. You could use PowerShell with REST and get the data in there, but I’ve moved over to storing this kind of data outside Epicor altogether and accessing it via External BAQ when needed whene…

PowerShell has the Invoke-RestMethod cmdlet which would make it easy to use instead of BCP. When you get to 10.2.500, you can use Epicor Functions to do the hard work for you. Pass in a Json string and load the UD table for you. And if you want to get really fancy, you could send the machine data i…

Thanks for the replies. Some ideas to consider. We are evaluating IoT at the moment, but think it’s some time off yet, but I am hopeful we will get there, things have slowed down a little in the current climate :smiley: As far as REST is concerned, I have been looking at this also, are there any g…

Writing data to UD Tables

Epicor ERP 10

Doug.C (Doug Crabtree) September 8, 2020, 2:32pm 2

I asked a similar question here:

Again, any direct injection is a “do it at your own risk” proposition.

Topic		Replies	Views
Advice with using REST to add/update a UD table Epicor ERP 10 e10 , rest	14	2365	August 31, 2020
DMT or SQL for UD Epicor ERP 10 dmt	3	975	June 18, 2020
Thought on outside process using E-10 database with UDT's (from a SQL Epicor ERP 10	16	1386	March 16, 2017
3rd party software database integration Epicor ERP 10 e10	4	864	April 7, 2020
REST uBaq to UD Table or Direct requests which is faster Epicor ERP 10 baq	5	937	August 12, 2020

Writing data to UD Tables

Related topics