10.2.200.12
Hope everyone is having a great day! I have a question on development I wanted to ask the community: If you have or had complex Progress programs for creating files for later reporting, data for other programs, etc., what have you found to be the best path for conversion of these programs for use in E10? I’ve been debating writing C# programs using access to SQL stored procedures, REST calls, embedded customization, but haven’t settled on a particular path. I’ve been reading a lot from other users in the community about keeping code like this within Epicor or using REST access, but that could be cumbersome to call a lot of business objects compared to a stored procedure that could access many tables at once. I’d really appreciate hearing your thoughts. Thanks!
Stay away from SQL. REST or WCF is the way to go. Many reasons (see many posts about this including this one Direct access to Microsoft SQL Database? - ERP 10 - Epicor User Help Forum)