Versions Compared

Old Version 5

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.

Deploy, secure, and integrate FrameworX within IT infrastructure.

Next → Control | IT | Operations | System Integrators

Learning Topics

IT professionals manage deployment, security

Learning Path - IT Professionals

Target Audience

...

, databases, and enterprise

...

integration. This guide navigates you through FrameworX documentation for IT/OT convergence

...

.

Learning Objectives

  • Implement secure authentication systems
  • Integrate with enterprise databases
  • Deploy web-based solutions
  • Configure REST APIs and web services
  • Establish cybersecurity best practices

Week 1: Foundation

Day 1-2: Database Integration

Production Database Schema

Code Block
languagesql
CREATE TABLE ProductionData (
    ID INT IDENTITY(1,1) PRIMARY KEY,
    Timestamp DATETIME NOT NULL,
    ProductCode VARCHAR(50),
    Quantity INT,
    Quality FLOAT,
    LineID INT,
    OperatorID VARCHAR(50)
);

CREATE TABLE BatchRecords (
    BatchID VARCHAR(50) PRIMARY KEY,
    StartTime DATETIME,
    EndTime DATETIME,
    Recipe VARCHAR(100),
    Status VARCHAR(20)
);

Exercise: Configure Database Connection

...

  • Server: SQLServer01
  • Database: Production
  • Authentication: Windows
  • Pool Size: 10

Create real-time query:

Code Block
languagesql
SELECT TOP 100 *
FROM ProductionData
WHERE Timestamp > DATEADD(hour, -1, GETDATE())
ORDER BY Timestamp DESC

Core Responsibilities:

  • System deployment and maintenance
  • Security implementation and compliance
  • Database integration and optimization
  • Web services and API configuration

Table of Contents
maxLevel2
minLevel2
excludeLearning
stylenone
printablefalse

Excerpt Include
For Control Engineers
For Control Engineers
nopaneltrue

Security Implementation

Authentication & Access Control

Essential Configuration:

  • [Security Module Reference] - Complete security framework
  • [Security RuntimeUsers Reference] - User management
  • [Security Policies Reference] - Policy configuration
  • [FDA 21 CFR 11 Compliance How-to Guide] - Regulatory compliance

Cybersecurity Standards

  • [IEC 62443 Compliance How-to Guide] - Industrial cybersecurity
  • [NERC-CIP Compliance How-to Guide] - Critical infrastructure
  • [Security Hardening Compliance How-to Guide] - Best practices
  • [Security Hardening Reference] - Detailed procedures

Database Integration

SQL Connectivity

Database Setup:

  • [Datasets Module Reference] - Database connections
  • [Dataset DBs Reference] - Connection configuration
  • [Visual SQL Query Builder Reference] - Query tools
  • [Datasets SQL Query Tutorial] - Step-by-step guide

Supported Databases

  • [SQL Server Database Connection] - Microsoft SQL Server
  • [PostgreSQL Database Connector] - PostgreSQL setup
  • [Oracle Database Connector] - Oracle integration
  • [MySQL Database Connection] - MySQL configuration

Web & API Services

Web Deployment

  • [Client Types Reference] - Client deployment options
  • [Desktop, Web and Mobile Clients] - Multi-platform support
  • [WebAssembly and Portable Displays] - Modern web technology
  • [Responsive Design and RESS] - Adaptive interfacesc

Cloud & IoT Integration

Cloud Platforms

  • [Azure IoT Hub Connector] - Azure integration
  • [AWS IoT Core Connector] - AWS connectivity
  • [Snowflake Cloud Connector] - Data warehouse
  • [InfluxDB Database Connector] - Time-series database

MQTT & IoT Protocols

  • [MQTT Built-in Broker Connector] - Built-in broker
  • [MQTT Client Connector] - Client configuration
  • [MQTT Tutorials] - Step-by-step guides
  • [MQTT Tools Reference] - Testing and debugging

Performance & Monitoring

System Monitoring

  • [Runtime System Monitor Reference] - Performance metrics
  • [System Monitor Connector] - Windows performance
  • [Runtime Diagnostics Reference] - Troubleshooting tools

Database Optimization

  • [Historian Storage Locations Reference] - Storage optimization
  • [Database Operations Code] - Optimization scripts
  • [Historian Database Exporter Code] - Data management

Quick Task Reference

Common TaskDocumentationReference
Configure SSL[Web Server Configuration Reference][SecureGateway Services Reference]
Setup Active Directory[Security Module Reference][Security Policies Reference]
Configure SQL connection[Dataset DBs Reference][SQL Server Database Connection]
Deploy Docker container[Container Deployment Reference][Deployment Reference]
Setup REST API[Reports WebData Reference][REST API Server Code]
Configure redundancy[Redundancy Reference][Server Configuration Reference]

...

Day 3-4: Web Deployment

Web Server Configuration

Component

Configuration

IIS Setup

Install IIS with WebSocket support

Application Pool

Configure .NET CLR version

SSL Certificate

Install and bind certificate

FrameworX Web

Enable web server, set ports

Authentication

Configure Windows/Forms auth

Client URL

https://server/frameworkxImage Removed

Lab: Deploy Secure Web Access

  1. Generate SSL certificate
  2. Configure HTTPS binding on port 443
  3. Enable Windows authentication
  4. Set up application pool:
    • .NET CLR Version: v4.0
    • Identity: ApplicationPoolIdentity
    • Recycling: Daily at 3 AM
  5. Test from remote browser
  6. Monitor performance metrics

Day 5: Security Implementation

Security Architecture Layers

Layer

Components

Implementation

Network Security

Firewall rules, VLAN segmentation

Configure DMZ, isolate OT network

Application Security

Authentication, RBAC, Audit logging

AD integration, role mapping

Data Security

Encryption at rest, TLS in transit

Configure certificates, backup encryption

Security Configuration Checklist

  1. Network segmentation implemented
  2. Firewalls configured
  3. SSL certificates installed
  4. Active Directory integrated
  5. Role-based access configured
  6. Audit logging enabled
  7. Backup strategy implemented
  8. Disaster recovery tested

Week 2: Advanced Topics

Day 1-2: Enterprise Integration

REST API Configuration

Code Block
languagejavascript
const apiConfig = {
    baseURL: 'https://frameworkx-server/api',
    endpoints: {
        tags: '/tags',
        alarms: '/alarms',
        historical: '/historian'
    },
    authentication: {
        type: 'Bearer',
        token: 'your-api-token'
    }
};

// GET current tag values
async function getTagValues(tagNames) {
    const response = await fetch(`${apiConfig.baseURL}/tags`, {
        method: 'POST',
        headers: {
            'Authorization': `Bearer ${apiConfig.authentication.token}`,
            'Content-Type': 'application/json'
        },
        body: JSON.stringify({ tags: tagNames })
    });
    return response.json();
}

Exercise: Create ERP Integration

  1. Design data exchange schema
  2. Configure REST endpoints:
    • GET /api/production/current
    • POST /api/production/batch
    • GET /api/quality/metrics
  3. Implement OAuth 2.0 authentication
  4. Schedule data synchronization (every 15 minutes)
  5. Add error handling and retry logic

Day 3-4: Cloud Deployment

Docker Deployment Configuration

Code Block
languageyaml
version: '3.8'
services:
  frameworkx:
    image: frameworkx:10.1
    ports:
      - "9000:9000"
      - "443:443"
    environment:
      - DB_CONNECTION=Server=azure-sql.database.windows.net
      - STORAGE_ACCOUNT=https://storage.blob.core.windows.net
      - IOT_HUB=frameworkx-hub.azure-devices.net
    volumes:
      - ./config:/app/config
      - ./data:/app/data

Day 5: Performance Monitoring

System Monitoring Script

Code Block
languagepowershell
$server = "FrameworX-Server"
$metrics = @{
    CPU = (Get-Counter "\Processor(_Total)\% Processor Time").CounterSamples.CookedValue
    Memory = (Get-Counter "\Memory\Available MBytes").CounterSamples.CookedValue
    Disk = (Get-Counter "\PhysicalDisk(_Total)\% Disk Time").CounterSamples.CookedValue
    Network = (Get-Counter "\Network Interface(*)\Bytes Total/sec").CounterSamples.CookedValue
}

# Send to monitoring system
Send-MetricsToSplunk -Server $server -Metrics $metrics

Database Optimization Guide

Task

Command

Purpose

Index Analysis

sp_helpindex 'TableName'

Identify missing indexes

Query Performance

SET STATISTICS TIME ON

Measure execution time

Database Integrity

DBCC CHECKDB

Check database health

Backup

BACKUP DATABASE TO DISK

Regular backups

Integration Patterns

Pattern 1: ERP Integration

Code Block
ERP ? REST API ? FrameworX ? Production

Pattern 2: Cloud Analytics

Code Block
FrameworX ? MQTT ? IoT Hub ? Analytics

Pattern 3: Reporting

...

Network Ports Reference

ServicePortProtocol

...

Purpose

...

Runtime Server9000TCP

...

Client connections
Web Client443HTTPS

...

Secure web access
SQL Server1433TCP

...

Database access
OPC UA4840TCP

...

OPC communication
MQTT Broker1883/8883TCP/TLS

...

Outbound

...

REST API

...

443

...

HTTPS

...

Inbound

IoT messaging

Recommended Learning Schedule

Week 1: Architecture review → Security planning → Network design
Week 2: Installation → Database setup → Authentication configuration
Week 3: Web deployment → API configuration → Integration testing
Week 4: Performance tuning → Monitoring setup → Documentation

Troubleshooting

Common Issues:

  • Connection timeout → [Runtime Troubleshooting Reference]
  • Authentication failure → [Security Module Reference]
  • Database performance → [Database Operations Code]
  • Web access issues → [Web Server Configuration Reference]

In this section...

Page Tree
root@parent

Troubleshooting Guide

Issue

Diagnosis

Solution

Web client connection failed

Check IIS logs

Verify SSL certificate binding

Database timeout

SQL Profiler trace

Optimize queries, add indexes

API authentication failure

Check token expiry

Refresh OAuth token

High memory usage

Performance Monitor

Adjust application pool settings

Slow page load

Network trace

Enable compression, CDN

Certification Path

FrameworX IT Specialist

  • Prerequisites: FrameworX Certified Developer + IT background
  • Focus Areas: Security implementation, database optimization, web deployment
  • Format: Online exam + security audit project
  • Duration: 4 hours

Additional Resources

...