Skip to main content


Smart Manufacturing Blog

Welcome to the official Smart Manufacturing Blog. Gain access to the experiences of smart manufacturers that make the world's most awesome products, and insights into cloud-based MES, ERP, Supply Chain Management, Industrial IoT (IIoT), and Analytics solutions.

Forrester Wave Rankings

Plex Named Strong Performer

in The Forrester Wave™: Digital Operations Platforms For Manufacturing Businesses, Q3 2020.

Do More with Your Data with IntelliPlex and Upgraded SQL

Cloud ERP Manufacturing
May 9, 2013

As everyone knows, if data is good, then big data is really good!

IntelliPlex has gone a long way toward helping companies in the Plex Manufacturing Cloud produce and distribute meaningful reports and handy, at-a-glance dashboards. This useful tool provides state-of-the-art graphical presentation capabilities, Active Reports that travel with you (even without an Internet connection) and Accelerated Views that make it easy for non-programmers to build custom, near-real-time reports.

But IntelliPlex isn’t the only way to get custom data out of Plex. Because the Plex Manufacturing Cloud is built on SQL (Structured Query Language) Server databases, anyone who can – or who would like – to write their own SQL queries and reports can easily do so.

Transact-SQL is one of the world’s most ubiquitous, powerful and elegant programming languages; it’s very easy to learn, and with even a basic understanding of SQL, it’s possible to slice and dice that big data quickly and easily.

And that’s now easier than ever with our recent release of the dramatically upgraded SQL Development Environment. The new interface is a quantum leap forward, providing features like:

  • An enhanced editor with colorized keywords, indentation
  • Tree views of database objects (stored procedures), views, and personalized execution history
  • Detailed dialogs for fast code previews and easy reuse
  • Improved SQL parsing and error reporting with notification dialogs
  • Run queries against test as well as near-real-time report server databases
  • Multiple export options

Custom stored procedures can be used as data sources for IntelliPlex reports and dashboards, as well as VisionPlex screens that can be launched directly from the menu with standard look-and-feel, including navigation links to other screens.

It’s your data – and the bigger it is, the more you should be able to leverage it to help inform your business decisions whenever you want.

The SQL Development Environment is like the Plex Manufacturing Cloud: always there and ready to serve when called upon.

About the Author

John Dancoe Senior Product Manager, Plex Systems

John Dancoe, a charter member of the Plex Systems Product Management team, is responsible for the Quality, Engineering, and Program Management areas of the Plex Manufacturing Cloud. John joined Plex Systems in 1997 as a software architect, engineer, and implementation project manager. Prior to joining Plex John spent more than fifteen years in the manufacturing sector, holding positions including Chief Engineer, and Senior Process and Tooling Design Engineer, at two of the first companies to implement Plex ERP software.


Ready to start solving problems before they become problems?