Monitor and control a brewing processSimulated pharmaceutical manufacturing process with end-to-end data historization from FrameworX → PostgreSQL → Snowflake.

How-to → Examples → Industry → BottlingLine ML

Pharmaceutical

Tablet

Plant Example

Overview

The PharmaTablet example demonstrates a complete pharmaceutical tablet manufacturing plant built in FrameworX, covering three production stages: granulation, tablet compression, and film coating. Simulated process data is collected in real time, historized to PostgreSQL, and synchronized to Snowflake every 10 seconds — showcasing a full OT/IT data pipeline with no custom middleware.

Architecture

----

{info:title=Download}
[? Download PharmaTablet.dbsln|https://partners.tatsoft.com/dl/JV4rGHCGbRqF/PharmaTablet.dbsln_]
No hardware required — uses ValueSimulator to generate all process data.
{info}

----

h2. Overview

The *PharmaTablet* example demonstrates a complete pharmaceutical tablet manufacturing plant built in FrameworX, covering three production stages: *granulation*, *tablet compression*, and *film coating*. Simulated process data is collected in real time, historized to PostgreSQL, and synchronized to Snowflake every 10 seconds — showcasing a full OT/IT data pipeline with no custom middleware.

----

h2. Architecture

{noformat}
[ValueSimulator] --> [FrameworX Runtime] --> [Unified Namespace]
                                                      |
                          +---------------------------+---------------------------+
                          |                           |                           |
                      [HMI Display]            [Historian]                  [Scripts]
                                                      |                           |
                                              [PostgreSQL]               (10s cycle)
                                             PharmaDatabase                      |
                                              PharmaTable               [Snowflake DW]
{noformat}

----

h2. Unified Namespace 

Unified Namespace (UNS)

All

tags

are

organized

under

an

ISA-95

compliant

*

Unified

Namespace

*

—

a

single

logical

hierarchy

that

decouples

data

consumers

(HMI,

Historian,

Scripts)

from

the

underlying

device

layer.

Replacing

the

simulator

with

a

real

PLC

requires

only

a

device

binding

change;

nothing

else

in

the

solution

needs

to

be

updated.

||

UNS

Path

|| Equipment || Key Variables || | {{

	Equipment	Key Variables
TabletPlant/Granulation/Granulator_01

}} |

High-Shear

Granulator

|

Temperature,

Impeller

Speed,

Chopper

Speed,

Moisture,

Phase,

Batch

ID | | {{

ID

TabletPlant/Compression/Press_01

}} |

Tablet

Press

|

Turret

Speed,

Compression

Force,

Tablet

Weight,

Thickness,

Production

Count,

Reject

Count | | {{

Count

TabletPlant/Coating/CoatingPan_01

}} |

Film

Coating

Pan

|

Inlet/Outlet

Temp,

Pan

Speed,

Spray

Rate,

Atomization

Pressure,

Coat

Weight

Gain | ---- h2. Historian — PostgreSQL All process variables are continuously historized via the FrameworX *Historian* module into a PostgreSQL database ({{PharmaDatabase}}, table {{PharmaTable}}). The Historian handles timestamping, compression, and deadband filtering automatically. ---- h2. Snowflake Synchronization A server-side script ({{

Gain

---

Historian — PostgreSQL

All process variables are continuously historized via the FrameworX Historian module into a PostgreSQL database (PharmaDatabase, table PharmaTable). The Historian handles timestamping, compression, and deadband filtering automatically.

Snowflake Synchronization

A server-side script (write_postgre_to_snowflake

)

runs

on

a

10-second

cycle

,

reading

new

rows

from

PostgreSQL

and

writing

them

incrementally

to

Snowflake

.

This

creates

a

near-real-time

bridge

to

the

cloud

data

warehouse

for

analytics

and

reporting

workloads.

HMI Overview

The MainPage display shows a plant-wide process overview in a single screen, organized left to right following the physical production flow.

Two live TrendCharts at the bottom track Press parameters (Compression Force, Weight, Thickness) and thermal data (Granulator Temperature, Coating Inlet/Outlet Temps) over a 5-minute rolling window.

Requirements

Getting Started

1. Download and open PharmaTablet.dbsln in the FrameworX Designer.
2. Configure PostgreSQL — update the historian connector connection string. The table PharmaTable is created automatically on first run.
3. Configure Snowflake — open the write_postgre_to_snowflake

1. script

1. and

1. set

1. your

1. account,

1. warehouse,

1. database,

1. schema,

1. username,

1. and

1. password

1. at

1. the

1. top

1. of

1. the

1. file.

2. Start

1. the

1. Runtime

1. (F5).

1. The

1. simulator

1. starts

1. immediately,

1. historization

1. begins,

1. and

1. the

1. Snowflake

1. sync

1. script

1. activates

1. on

1. its

1. 10-second

1. cycle.

2. Open

1. MainPage

1. to

1. view

1. the

1. live

1. process

1. overview.

In this section...