Tuesday, August 16, 2011

Calling X++ from sql server

As part of our implementation I was trying to figure out how to call X++ classes from within sql server stored procedures. The purpose behind this was to help integrate with our Allen Bradley machines on the shop floor. We did not use this method but I thought it was really neat that I could make all of the calls this way if needed....

I wrote a SQL Assembly file that when called from a trigger fires the stored procedure that connects to a web service. The web service calls CallStaticClassMethod to get the class, method and params.

More to follow.

No comments: