SQL Bridge is my favorite part of Ignition. It was our first product back when I was the only "salesperson." Back then it was a standalone product called FactorySQL and was the product that bootstrapped us forward.
FactorySQL resulted from a call by many of our customers (back when I was an integrator) to track, analyze and make available ever more complex data from ever more sources and to provide accessibility to the data from web pages. Prior to that we developed a lot of one-off C, Delphi and VB applications, but these were albatrosses around the neck. What I really wanted was a reasonably priced, simple, commercial-off-the-shelf solution and I was pretty confident I'd find it. Yet four months later I reversed that idea, was disillusioned and was pretty sure I wouldn't find it. Therefore we had no choice but to develop something in-house.
I drew up the original concept on paper and Colby developed it. We gained indispensable field experience deploying it to a wide variety of industries and applications which allowed us refine, add versatility, and battle harden it. I was giddy at the realization my integration business could now have a total monopoly. No where else could you get FactorySQL's functionality at any price. It was intoxicating, but that wore off when I realized you either get in the software business with both feet, or you get out (I could write a book on that subject alone). So I chose the software business.
Back to being the first "salesman." It was a real kick demonstrating FactorySQL to integrators. In the first place, like myself in the beginning, few had much familiarity with SQL. I took great pleasure in showing them how easy, inexpensive and useful SQL databases can be. While demonstrating FactorySQL the "light bulb" would inevitably go off and uniformly I'd get the "what's the catch?" question. I did this by demonstrating the 1-2-3 drag-drop-log ease of use. Then I'd show triggers, bi-directional mirroring, recipes, mapping addresses between different brands of PLCs, wide column logging, automatic sequencing, all types of stuff. I could do it in minutes. I don't sell anymore but it was fun while I did.
In 2010 FactorySQL was renamed SQL Bridge which is part of Ignition. That offered a host of new benefits such as ability to run on any platform like OSX, Linux or any version of Windows, support for OPC-UA, built-in drivers for most popular protocols, online editing, and more. But it now shares the limelight with a stable of other cool modules and that's mostly why I wrote this piece. SQL Bridge is the integrator's swiss army knife (it was my ace-in-the-hole) but it could be forgotten as the limelight now favors the rising stars (newer modules). And that would be a pity.
Heck, we're the first culprits. Just go to our website and look up SQL Bridge. If you can find it at all you'll likely come away thinking it's only a logger or historian. So I'm telling you now it's more. It's the integrator's swiss army knife. It's the integrator's secret advantage (experience shows not every integrator "gets it").
You can get your own reality on this by downloading Ignition from our site and installing it (five minutes max). First set up a database (MySQL is free and sets up in minutes). Then go into the "Configuration" page and create a database connection. Open the designer and go straight to "Transaction Groups" in the project tree (SQL Bridge manifests itself in the designer as Transaction Groups in the project tree and as a the History tab of the Tag editor). Using the included help system you'll figure it out quick and if not look it up in our free Ignition University.
