Lonnie Bowling

ACE to execute a SQL query?

Discussion created by Lonnie Bowling Champion on Feb 24, 2011
Latest reply on Feb 25, 2011 by Lonnie Bowling

Hi Everyone,


I have been presented with an interesting challenge and wanted to get some opinions.  My client needs to update PI tags from an Oracle database.  I know I could use the RDMS interface, but am considering ACE.  The issue is that the data from the database has to be processed with some fairly complex logic before updating the tags and doing this in VB.net would be much simple that creating some nasty SQL statements or stored procedures.  Could I just setup an ACE module and schedule it every 10 minutes, connect to the database, look for new data, process and update output tags?  Seems simple enough,  how would this approach compare to using the RDMS interface (I don't have any direct experience with it)?