SCADA Developer Network

We received too many requests for installing IntegraXor on virtual machine, on the other hand we’ve been suffered on piracy issue which appeared to be a happy problem. However, we decided not to against the trend of installing servers on VM, as such we are pleased to announce that we begin to authorize IntegraXor license on any virtual machine starting major version of 3.72.

• Support of virtual machine installlation.
• Side-by-side installation with different versions on separate installation path is now allowed.
• Changed of CLSID due to security issue.

• Fixed some minor bugs.

AUTOMATICON is the most important trade fair for automation, control, measurement and robotics in Poland. It was held at EXPO XXI Warsaw International Expocentre, Warsaw, Warszawa, last month 20-MAR-2012 to 23-MAR-2012. Both the exhibition & accompaying seminars attract thousands of high level specialists from industry from all over Poland & the neighbouring countries. And one of the impressive booth was setup by ABMICRO.

Even more interesting is they have setup an Crane Model featuring IntegraXor! It must be attractive to visitors to the exhibition when showing around the SCADA mimic on iPad or tablet.

The SCADA mimic screen produced by ABMICRO is simply professional. Thumbs up!

We haven’t added much features but mainly upgrading the version for efficiency & reliability. Since Ester is around the corner and we have nothing new to excite you, for a surprise, we would like to take this opportunity to show you one of the long hidden feature, SQL Query Tool.

To find this Ester Egg, open up Project Editor with any project, then you need to open up File Pane under View menu (or press Ctrl+Shift+F). Drill down to open up SQL folder and click on query.sql. Ta da! you shall see the following SQL Query Tool shows on your screen.

Well, not exactly, you won’t see the query result at the bottom right corner yet. Now you need to click on the drop down list to pick your desired database for query. And then highlight the SQL statement before clicking the Executing button.

This SQL Query Tool is being used by our in-house engineers and why aren’t we sharing out in the past? It’s simply because this feature is not fully developed so we are not officially supporting it yet. It’s very convenient and useful if you use it gently, below are the found bugs that yet to fix:

• Short cut key for Execute (F5) doesn’t work, you must click on Execute button.
• Any highlight of the SQL statement or text will stop the keyboard navigation, click any where to proceed.
• No notification when illegal statement is executed. And previous result appears freeze.
• Few relevant menu items/icons are disabled.

Although this SQL Query Tool is not fully developed, but it’s not a toy and it will execute any command truthfully, so be warned not to execute any destructive SQL statement on site machine. Also, avoid to do a "select * from log" which may cause P.E. to hang up on big database, but use "select top 100 * from log" instead. If you find this SQL Query Tool useful & like it, simply write to support@integraxor.com to say some good words and the relevant programmers will certainly improve it in the next few release.

Two most wanted new features are included in this release and they are SQL driver and Tag Expression which were also announced in Beta news earlier. As usual, this public release also addressed several minor issues, so be sure to download a copy and enjoy greater stability and features.

You will be amazed by the power & versatility of Tag Expression.

Now you can integrate run-time tag with any database table entry like a breeze.

Windows shell explorer has slightly amended to tackle change of action problem upon re-installation.

We would also like to take this opportunity to alert user to avoid using Security Level which we planned to totally supersede by using Security Label. This is in conjunction with our goal to support more sophisticated but simplified security user system, we will remove security level from IntegraXor but concentrate on enhancing Security Role/Label with more versatile security control. Please avoid to use security level but use only security label to avoid future compatibility issue. If your existing project have already used security level, please write to us so we will help to upgrade your project.

Unlike many SCADA system only supports proprietary database system, IntegraXor once again open up another channel to integrate with external database system via SQL Driver. This driver is a little special as it’s not communicating with hardware devices but to a rational SQL database system that supports ODBC, by associating a specific database table column with a real-time I/O tag.

User only require to enter a very simple syntax to query the database, the same syntax can be used to query across any databases with ODBC driver, so user only need to learn once for all. Furthermore, user can choose to enter the syntax directly or use the built-in builder to click through a few options to compose the needed syntax. Download this gift that we managed to wrap in the very last minute before long holiday. Merry Christmas & Happy New Year!