I have a SQL stored procedure that will write data to SQL databases. Can I call that stored procedure through AF so that I can use analytics for calculation and the write results to SQL for other application use? if so how and where?
I'm not aware of a way to call a stored procedure in another SQL server directly from AF/Analytics. However, one option could be using output tags for the RDBMS interface. You could use the AF Analysis Service to write values to a tag and then update a SQL table based on the analysis output with RDBMS. Here is some documentation on how to set up output tags with the RDBMS interface:
Output processing: updating an RDBMS with PI data
Yeah I know I can use RDBMS. I think that maybe the route I have to take for now. It is just nice because I can import the database data into AF. Would be nice to simply update data there and have it replicate back or manage it all in AF to reduce the points of failures. I have also considered using PI ACE as we are already heavy users of PI ACE but looking for a solution to replace a PI ACE equation with PI AF. Also thought of going AF SQL database to another SQL database within SQL itself using SQL agent job or SSIS.Trying to move to the future of PI! Thanks for the help!
I just thought of another option that may work. You could configure a linked server with OLEDB Enterprise where you could pull the values you're interested in and then call the stored procedure on your other SQL server. Do you think that would work?
KB01143 - How to configure a linked server with PI OLEDB or PI OLEDB Enterprise
Retrieving data ...