Data Integration
Sample description for Data Integration

OPC Data Quality in PI System: Handling Bad and Questionable Values
Learn how the PI Interface for OPC DA handles bad and questionable data quality, why numerical values aren't stored for bad quality, and best practices for configuration.
Ben Taylor

Troubleshooting DCOM E_ACCESSDENIED (0x80070005) for PI OPC Interface
Resolve the persistent DCOM E_ACCESSDENIED (0x80070005) error when connecting your PI OPC Interface to an OPC DA server with this comprehensive troubleshooting guide.
James Kowalski

Troubleshooting FactoryTalk Historian 7.0 External License Errors
Resolve the "Error getting external license" in FactoryTalk Historian 7.0 that prevents PI Point creation. Learn to assign license tags correctly in the FactoryTalk Administration Console.
Ben Taylor

Troubleshooting Aspentech IP 21 OPC DA Real-Time Tag Browsing
Troubleshoot issues browsing real-time tags from Aspentech IP 21 OPC DA servers. Learn to diagnose with PI OPC Client Tool and resolve common configuration challenges.
Wei Zhang

Troubleshooting PI Interface for OPC DA: Access is Denied (80070005)
Resolve the common 'Access is denied (80070005)' error when PI Interface for OPC DA fails as a service. Learn to configure DCOM security and user permissions.
Emily Watson

Troubleshooting PI DataLink 'Attribute Not Found' with SQL-Backed AF Attributes
Resolve PI DataLink's 'Attribute Not Found' error when accessing AF attributes linked to SQL databases. This guide covers common causes and systematic troubleshooting steps.
James Kowalski

Finding the Last Good Value for PI Tags with SQL Queries
Learn how to find the last known good value for PI Tags using SQL queries via PI OLEDB Provider or PI SQL Data Access Server, enhancing data quality analysis.
Erik Johansson

PI OLEDB Provider: Installation, Connectivity, & Modern Alternatives
Confused about PI OLEDB Provider? Learn its installation, connection methods, and compare it with PI OLEDB Enterprise, PI ODBC, and PI SQL Client for optimal PI System data access.
Isabel Fernandez

PI OLEDB Linked Server Queries Hanging: Diagnosis and Resolution
Diagnose and resolve common issues causing PI OLEDB linked server queries to hang indefinitely in SQL Server, often requiring a full SQL Server restart. Learn expert configuration and troubleshooting steps.
Arief Wibowo

Real-Time PI System Data to Apache Kafka: A Deep Dive
Learn how to stream real-time PI System data to Apache Kafka using PI Integrator for Business Analytics or PI Web API for modern dashboards and analytics.
Rafael Costa

Preventing PI to PI IO Timeout During Backfills
Learn how to prevent misleading PI to PI Interface IO Timeout events on target PI tags during backfills by configuring the Location3 attribute.
Siti Rahman

PI UFL Connector vs. Interface: Demystifying REST & Data Collection
Demystify the PI UFL Connector vs. Interface. Understand their core differences, especially native REST API support, and choose the right tool for your PI System data collection needs.
Jack Morrison
About Data Integration
Explore our collection of expert articles about Data Integration. Our content is written by experienced PI System professionals and covers everything from basic concepts to advanced implementation techniques.
Whether you're new to PI System or an experienced engineer, you'll find valuable insights, tutorials, and best practices to help you get the most out of your industrial data infrastructure.