We have a 3rd party vendor that handles our vending machines for our tooling, and the powers that be have decided that they want that 3rd party system to talk to Epicor and modify data in the database.
I do know that it is 100% possible just by connecting to the SQL Server and throwing SQL commands at it, but I also know that is a sure-fire way [if not a practically guaranteed way] to break Epicor. So, my question is: Is there a proper way to go about this? IE: If a 3rd party system wanted to modify the data for a part in Epicor, is there a “best-practices” way to do that? Is there additional licensing required for that? (Does that require the SDK license?)
Either way you have to use the Epicor business objects to interact with the database, otherwise, things like database integrity, warranty, support, guaranteed future upgrades etc go out of the window.
It has been mentioned on another thread to do with interfacing an external ordering system to Epicor, but another option is to put the data into one of the UD table using REST / DMT/ Service Connect or custom code using the business objects and then use a method directive on the ‘Update’ method for the UD table to call the relevant business objects to populate Epicor.