The ArchestrAnaut

In our work we do a lot of interfacing with SQL databases (usually MS SQL Server).  Being able to interface with SQL from IAS is a big weapon in one’s arsenal.  You can retrieve data from a table or view, execute stored procedures and functions, and virtually anything else you can dream of doing with T-SQL.

We’ve wrapped most of the code to do the SQL DB interfacing into a DLL for simplicity and error trapping.  However, this post is intended to give a basic example on executing a simple query from an IAS script using the .NET objects.

Read the rest of this entry »

IAS is as flexible as or more flexible than any other platform out on the market in terms of the breadth of programming possibilities. The concept of inheritance makes it possible to make changes at a template level and all of its children (templates & instances) will be changed too. Equally as powerful is IAS’s inclusion of .NET in their QuickScript language.

Read the rest of this entry »

Andy & I have always been fairly frustrated with the Wonderware Alarm Logger service.  It almost seems like an afterthought for System Platform (just look at the service name:  New_AlarmLogger).  Perhaps the most frustrating part is trying to integrate it into a system with redundant App Servers.  To the developers:  please integrate this into the System Platform in a future release.

Read the rest of this entry »