I’m trying to write to an external database to create a record from a customization/bpm. I’d like to use the external program’s assemblies to perform this. Is this possible? If so, this would be better for us than using direct sql.
Depends, On Prem or Cloud?
On Prem → Most likely Yes
Cloud → Also Most likely yes, but more work
1 Like
If you have the ability to write to the external database by making calls to a REST API, that would be a good option. It’s always good to avoid referencing external assemblies if you can.
2 Likes
@klincecum We are on prem. @andrew.johnson That would be ideal but the external program does not have an api to connect to.
If possible, how would you create the connection to the external db?
If you’re willing to write directly to the database, then you can do what @andrew.johnson recommends with suggestions in this thread.
Kinetic 2022.1 C# BPM SQL Call Stored Proc - Kinetic 202X - Epicor User Help Forum (epiusers.help)
1 Like