Versions Compared

Old Version 1

changes.mady.by.user admin

Saved on

compared with

New Version Current

changes.mady.by.user admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL to the Core

Easy Heading Macro
headingIndent40
navigationTitleOn this page
selectorh2,h3
wrapNavigationTexttrue
navigationExpandOptiondisable-expand-collapse

Built-in Embedded SQL

Every FactoryStudio system includes a full-featured embedded SQL engine. This provides several advantages

including

:

  • A safe and secure location for your entire project configuration.
  • It can be used as the historian database to log tags, alarms, and events on small to medium systems (up to 10GB of data).
  • On
Large
  • large systems, it can be used as a local Store and Forward location, when the remote database is not available.
  • It provides an ideal system to store local runtime settings, retentive information, local recipes, schedules
and
  • , tables, and queries when preparing reports.

Multiple Database Connections

FactoryStudio provides seamless integration with any third-party database, including Microsoft SQL Server, Oracle, MySQL, Informix, SQL Lite, PostgreSQL, and others.

Advanced DataGrid

FactoryStudio provides a fully-featured DataGrid object

to

that present tables and queries from databases, as well

show

as shows the contents of any tag, assets,

asset

or real-time

object

objects.

Just drop

Drop the table, query, or tag

to

in the Grid Data Source to create front-end visualization

or

, edit any real-time object, or edit any database

.In this section

.

..

Page Tree
rootIntegrated Modules





Real-time Queries and Tables

Any data source with ODBC, OLE-DB, or ADO. NET support can be connected with the application; an . An easy syntax allows you to create or customize any query or table search with real-time tags. 

Client-Server Architecture

Real-time queries can be processed either at from the server or from the client computer, asynchronously or synchronously. To achieve a better performance, multiple requests from distributed clients are cached and synchronized at in the server.

Data Gateway

Connecting client queries through Firewall protected security zones, such as moving data between the Automation Network and the IT network, is no longer an issue. FactoryStudio provides a built-in firewall friendly data gateway. Data queries from clients are routed in a secure way through any FactoryStudio system. 


Tip
titleThe Convergence of SQL database, HMI software and .NET

Scheduling , Process Recipes and processing recipes and real-time data consolidation is made easy.



See “SQL Queries” for more information.