On Epicor Kinetic SQL Server Stored proceedures, cursors, triggers?

there is *.app files will be imported in to Epicor Kinetic using “Import Utility”. How can I save those imported *.app files in to *.bak files? is there any REST API to save all bak files?

I am engineer of 17 years of experience. If i get the access of SQL Server where Epicor Kinetic data is there. If I get the MS SQL Server access in read access mode, if I understand all the stored proceedures, cursors, trigger and all, can it help below?

My intention is to learn

If I have Epicor Kinetic product. I have to configure it to new “Supplier” or “Manufacturer”. I need to know , what and all default tables are there? When and which table data get inserted at the time of Pre-MRP and POST-MRP? How can I configure database? Is there any documentation?

1 Like

Welcome to the forum @manjeshhb!

To be perfectly honest, thinking in terms of tables, especially if you want to update the database, will work against you in Kinetic. Learning what’s in the tables is a very valid pursuit, but in the 17+ years of working with Epicor products, I have learned that it is a service oriented package more than a database package. I treat it more like Microsoft Exchange. I would never just add data to tables and expect to work not knowing what Microsoft coders do. If I want to add a new supplier or manufacturer, I use the service, which is with a .NET object in Functions/Directives or REST with the UI and external programs.

There’s an on-going conversation on how to export customizations, and @klincecum has written some code to do the export but there is no importing back in at this time.

3 Likes