I have been following this post since I have struggled getting external data from an Azure Database. The stored procedure lives in the Azure DB and has to be a stored procedure, not a just a Query. In the past, I used System.Data.SqlClient and the now the new Microsoft.Data.SqlClient – neither of …

[image] tomdomurat: Epicor deprecated the ability to call external DLLs from a Function (according to them “a secuirty risk”). There is no online service that (intentionally) allows the ability to upload DLLs to their systems. [image] tomdomurat: So, what is the definitive answer to call…

And since your data is in Azure DB already, this would be a great opportunity to use Azure Functions. [image] How To Call A Stored Procedure From Azure Functions - Azure Lessons In this Azure tutorial, we will discuss How To Call A Stored Procedure From Azure Functions. Along with this,…

[image] tomdomurat: I have been following this post since I have struggled getting external data from an Azure Database. I’ve requested a split to a new thread. We’ll see if we can help you there.

If you absolutely must call via System.Data.SqlClient, you can, but you’ll have to load it dynamically through reflection. I would encourage you to evaluate your other options first and see if there is something more appropriate and “Epicory” :rofl: If you do end up needing assistance with the r…

I also have a question. Could you not use a trigger to pop your stored procedure, and define that trigger in the external db to pop off on some write to the external source?

Let me clarify that this in on-premises and not cloud. Also, the forms will most likely never be converted to Kinetics forms. I am aware that there are technically better ways of doing this like a webservice API, but for now I just would like it to work like before without a complete re-write. Th…

[image] Call store procedure in Kinetic Function not working Kinetic ERP I helped @xvhelp privately because I thought he was doing something a bit different. Turns out he was not. He was calling a stored procedure in another database and just wanted to patch up his code …

Right. I tried using that code and it did not work in 2022.2. It gave me errors.

[image] tomdomurat: It gave me errors. Do tell. I know for a fact it works in 2022.2.

Either from a Data Directive or a Data Directive calling an Epicor Function. It will compile and save, but throws me the error. I reported the issue to Epicor Technical Support and they tell me that external custom DLLs cannot be used. Supposedly, they tell me it is a “security risk”. Server Sid…

External Datasource Run Stored Procedure

Kinetic ERP

klincecum (Kevin Lincecum) May 5, 2023, 6:39pm 8