Smart Management Frameworks

Your Netezza Systems,
Running Themselves.

SMF automates the complex, time-consuming management tasks that keep Netezza systems performing, available, secure, and well-governed — without continuous manual effort from your team.

Request a Demo Included in Managed Support

Automation Built Specifically for Netezza

IBM PureData for Analytics and Netezza Performance Server systems are remarkably fault-tolerant and require far less routine administration than traditional RDBMS platforms. But when something does go wrong — or when performance gradually degrades — resolving it requires deep, specialist expertise that most organisations cannot justify keeping on permanent staff.

Smart Management Frameworks fills that gap. It automates the processes that keep your Netezza systems performing at their best: replication, access control synchronisation, performance tuning, housekeeping, governance, and data curation — all running continuously in the background.

The result: better uptime, better performance, stronger security, and a far smaller administrative burden on your data team.

SMF is included free in our Managed Support tier
8
Modules: replication, access control, governance, curation, and more
24/7
Continuous background automation
Minutes
Disaster recovery MTTR with Smart Database Replication
0
Manual access sync errors when Smart Access Control is running

What SMF Does for Your Systems

Each module targets a distinct area of database management. They can be deployed individually or together as a complete management suite, controlled through the SMF Control Studio web interface.

Netezza Replication

Near real-time database replication for DR, workload distribution, and migration

Keeps a continuously synchronised copy of your production databases on a standby system using nzbackup/nzrestore and Syncthing. In the event of a disaster, recovery is measured in minutes rather than hours. Without a disaster, your standby system earns its keep by carrying read-heavy workloads to maximise throughput and concurrency on your primary system.

Near real-time sync MTTR in minutes Workload distribution Supports CP4D and PureData

LDAP Sync

Active Directory and LDAP user and group synchronisation

Automatically synchronises user accounts, groups, and database permissions from your Active Directory or LDAP directory — continuously, without manual intervention. Eliminates the risk of stale access credentials and the delays caused by manual provisioning.

Entra ID / Active Directory LDAP support Automatic sync Eliminates stale access

Event Manager

Real-time event processing and alerting

Monitors system and database events in real time and triggers configurable alerts and automated responses. Provides a centralised event processing layer across all other SMF modules — ensuring your team is notified of issues before they become outages, and that predefined remediation actions fire automatically where appropriate.

Real-time monitoring Configurable alerts Automated responses Cross-module events

Data Curation

Automated data aggregation, archiving, and lifecycle management

Manages the lifecycle of ageing data automatically. As detailed data ages beyond configurable thresholds, Data Curation aggregates it in place, archives the original detailed records to a Lakehouse or other file system for slower retrieval if needed in future, and then deletes the originals from the database — keeping it lean without manual housekeeping. Data quality checks are also applied as part of the curation pipeline.

Automated aggregation Lakehouse archiving of detail Data lifecycle rules Data quality checks

Data Governance

PII classification, policy enforcement, and owner notification

Classifies sensitive data — including PII — across your databases and enforces configurable governance policies against it. When a policy is breached, the data owner is automatically notified. Provides the audit trail and policy enforcement layer needed for regulatory compliance without requiring manual monitoring by your data team.

PII classification Policy enforcement Automatic owner notification Compliance audit trail

Metadata Scanner

Database metadata discovery and cataloguing

Automatically discovers and catalogues database metadata — schemas, tables, columns, data types, and object relationships — providing a continuously updated view of your data estate. Supports data discovery workflows and provides the foundation for governance, curation, and quality initiatives.

Automated discovery Schema cataloguing Column-level metadata Continuous updates

Query History

Query history tracking and deployment to PostgreSQL servers

Captures and stores query history from your Netezza systems, making it available for analysis, performance investigation, and capacity planning. Query history can be deployed and queried via PostgreSQL servers, making it accessible to standard BI and reporting tools without requiring direct Netezza access.

Full query capture Performance analysis PostgreSQL deployment Capacity planning

Admin

System administration and configuration

Central configuration and administration of the SMF platform — managing database connections, module settings, user access, and system-level configuration. Accessible through the SMF Control Studio web interface, which provides a unified dashboard for all modules without requiring CLI access.

SMF Control Studio Connection management Module configuration Web-based interface

What SMF Delivers for Your Organisation

MTTR Measured in Minutes

With Smart Database Replication maintaining a live hot standby, recovery from hardware or software failure takes minutes rather than the many hours required by conventional Netezza backup and restore procedures.

No More Manual Access Sync

Eliminate the risk of data exposure from stale access credentials. Smart Access Control keeps your Netezza permissions continuously aligned with your corporate identity directory without any manual steps.

Peak Query Performance, Automatically

SuperTuning identifies exactly which objects need attention and performs only the necessary operations — maximising query performance without the overhead of blanket statistics collection or reorganisation routines.

Governance and Compliance, Automated

The Data Governance and Data Curation modules enforce data policies and lifecycle rules continuously in the background — alerting on violations and applying remediation automatically — without any additional staff effort.

Get SMF Free with Managed Support

Smart Associates is the only independent Netezza support provider to include the full Smart Management Frameworks suite at no additional charge in our Managed Support tier. You get expert break/fix support and continuous system automation for a single flat-rate fee.

View Support Tiers

Managed Support includes all of:

  • 9×5 or 24×7 expert break/fix support
  • Remote hardware support and on-site cover
  • Scheduled health checks and performance reviews
  • Smart Database Replication
  • Smart Access Control
  • Data Governance and Data Curation
  • Metadata Scanner and Query History
  • Event Manager with automated alerting
  • Optional advisory and development services

SMF Now Runs on PostgreSQL — and Beyond

Smart Management Frameworks has been ported to PostgreSQL, opening up SMF's powerful automation capabilities to a far wider range of organisations. Whether you run Netezza, PostgreSQL, Oracle, or are migrating towards Databricks, Snowflake, or Redshift — SMF can be part of your management strategy.

The new SMF Control Studio provides a full web-based management interface, replacing CLI-only workflows with a modern, browser-accessible dashboard covering all modules — LDAP Sync, Event Manager, Data Governance, Data Curation, Metadata Scanner, and more.

Discuss SMF for Your Platform
🗄
PostgreSQL & NetezzaFull multi-database management from a single Control Studio
🖥
SMF Control StudioReact web application — manage all modules from a browser, no CLI required
Cloud-Aware ArchitectureBuilt for modern cloud-first environments: Databricks, Snowflake, Redshift
🔓
Open Standards FoundationBuilt on PostgreSQL and open source tooling — no proprietary lock-in

Learn More About SMF

SMF Brochure

Download the Smart Management Frameworks product brochure for a complete overview of all three modules.

Download PDF

Replication Intro Video

Watch a short introduction to Smart Database Replication, covering disaster recovery and workload distribution use cases.

Watch Video

SuperGovernance Video

See how SuperGovernance monitors database query activity and flags governance rule violations automatically.

Watch Video

See Smart Management Frameworks in Action

Let us show you what SMF can do for your specific Netezza environment — no commitment required.

Request a Demo See Managed Support