How can I integrate the MPS with MS SQL Server?
1 个评论
(1) The MATLAB function hosted on MPS must be triggered in some fashion, e.g. from a C# application, Java application, etc. MPS hosted functions do not operate in a cron-job or scheduled task fashion. Assuming the function is triggered by an external cron job or scheduled task, the MPS function can read/write data from SQL Server using Database Toolbox functions and the ODBC driver for SQL Server. (2) In order to call the MPS function you would have to create a C# SQL CLR Stored Procedure in Visual Studio. In your code, you would make a HTTPWebRequest to call the MPS function through the REST API. This is POST call and the specifics of the JSON input/output payloads can be found in the MPS documentation here . You can then call this CLR Stored Procedure in your T-SQL query.
回答(1 个)
0 个投票
类别
在 帮助中心 和 File Exchange 中查找有关 Deployable Archive Creation 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!