All Units

Introduction 

  1. Architecture

Core Concepts 

  1. Installation
  2. Configuration

Data Connectivity 

  1. Basics
  2. Mitsubishi Electric FA
  3. OPC Classic
  4. OPC UA
  5. DeviceXPlorer
  6. SNMP
  7. Modbus
  8. Web Services
  9. Databases
  10. Other Connectivity Options

Dashboard Visualization 

  1. Basics
  2. Symbols
  3. Commanding
  4. Navigation
  5. Aliasing
  6. Asset Navigator
  7. Alarm Viewer
  8. Grid Viewer
  9. Trend Viewer
  10. Recipes
  11. Schedules
  12. Fault Viewer
  13. Camera Integration
  14. Helper Controls
  15. Advanced Controls
  16. 3D Graphics
  17. Security
  18. Cloning

Clients 

  1. Basics
  2. Desktop Deployment
  3. Web Browser Deployment
  4. Mobile Deployment
  5. KPI Self-Service Dashboard

Data Historian 

  1. Basics
  2. Visualization
  3. Calculations
  4. Data Exchange
  5. Advanced Architectures

Asset Organization 

  1. Basics
  2. Defining Assets
  3. Commanding
  4. Asset Templates
  5. Visualization
  6. Bulk Asset Configuration
  7. Advanced Topics

Alarming & Notifications 

  1. Basics
  2. Hyper Alarm Server
  3. Hyper Alarm Logger
  4. Alarm Visualization
  5. AlarmWorX64 Server
  6. AlarmWorX64 Logger
  7. Converting AlarmWorX64 to Hyper Alarm Server

Helper Modules 

  1. Recipe Management
  2. Scheduling
  3. Triggers
  4. Localization
  5. Unified Data Manager
  6. Workflows
  7. Expressions

Security 

  1. Basics
  2. Security Server
  3. Audit Logging
  4. Securing Data in Transit
  5. Securing Data at Rest

Cloud & IoT 

  1. Basics
  2. Broker Configuration
  3. Data Connectivity
  4. IoTWorX

Reporting 

  1. General
  2. Report Data Formats
  3. Advanced Topics

Automated Transactions 

  1. Basics
  2. Process Files
  3. Processing Data Sources
  4. Notifications
  5. Advanced Topics

Business Intelligence 

  1. Basics
  2. Data Flows
  3. Data Models
  4. Data Views
  5. Visualization

Project Management 

  1. Project Backups

Fault Detection & Diagnostics 

  1. Basics
  2. Fault Rules
  3. Diagnostic Models
  4. Cost Analysis
  5. Visualization

SPC/SQC Analysis 

  1. Basics
  2. Visualization

Energy Analysis 

  1. Basics
  2. Energy Calculation
  3. Visualization
← Return to Data Connectivity
SECTION 10

Databases

Total: ~21

Database integration to the likes of MS SQL Server, Oracle, and others is essential to a variety of applications. It is particularly useful for interfacing to track and trace, MES, or other 3rd party systems which may handle process data directly.

Database Connectivity

Connectivity to databases is a standard protocol in the ICONICS solution stack, and a variety of platforms are supported. This integration is frequently used for 3rd party relational database systems integration.

2:12 min

Connecting to SQL Server Databases

An overview of how to connect to and access data from Microsoft SQL Server databases, as well as specifics related to SQL Server as opposed to other databases.

2:11 min

Connecting to Oracle Databases

An overview of how to connect to and access data from Oracle databases, as well as specifics related to Oracle as opposed to other databases.

1:59 min

Connecting to OLEDB Databases

An overview of how to connect to and access data from databases via the OLEDB connector. This connector is useful for other databases not specifically listed individually.

2:20 min

Select Statement Queries

This video explains how to create a SELECT statement for your data source as well as configure a user-defined parameter.

2:19 min

Insert, Update, and Delete Queries

Beyond simple SELECT statements, learn how to integrate INSERT, UPDATE, and DELETE queries into your application, both configuration and runtime use.

3:47 min

Using Stored Procedures

Stored procedures can be accessed and used just like any other SQL query. Learn how to use them including parameterized procedures.

2:54 min

Data Manipulators

Data Manipulators provide powerful direct access queries that can be applied to the SQL database via runtime commanding and automated transactions.

2:48 min