#Data Integration
Browse all articles tagged with #Data Integration. Find expert insights and practical tutorials from our PI System community.
Resolving 'Provider Initialization Error' for Excel to PI AF Tables
Encountering a 'provider initialization error' when importing Excel to PI AF tables? Learn the root cause, select the correct OLE DB provider, and discover best practices for external data integration.
Jack Morrison
Bulk Linking PI Data Archive Tags to PI AF Attributes with PI Builder
Discover how to efficiently link hundreds of existing PI Data Archive tags to PI Asset Framework attributes in bulk using the powerful PI Builder Excel add-in.
Viktor Lindqvist
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
Ingesting External REST Data into PI System: Methods & Best Practices
Learn how to ingest data from external RESTful APIs into your PI System. This deep dive covers using PI Connector for UFL, custom applications with AF SDK, and PI Web API's OMF for seamless data integration.
Oliver Hughes
PI System Access (PSA) Explained: Tools, Uses, and Licensing
Explore PI System Access (PSA), the runtime license for integrating PI System data with external applications. Learn about the developer tools it covers, appropriate use cases, and licensing considerations for production deployments.
Marcus Chen
Exposing PI System Data in SQL Server as a Linked Server
Learn how to configure a PI System Linked Server in SQL Server Management Studio to seamlessly query PI Data Archive and PI Asset Framework data alongside your relational databases.
Yuki Tanaka
PI OLEDB Enterprise: SQL Access to PI Asset Framework Data
Unlock the power of PI OLEDB Enterprise to query PI Asset Framework (AF) data using SQL. Seamlessly integrate AF context with PI Data Archive data for richer analytics and reporting.
Sophie Bennett
PI OLEDB Enterprise: SQL Access to PI AF Data Explained
Unlock your PI Asset Framework data for enterprise reporting and business intelligence with PI OLEDB Enterprise. Learn how this data provider offers secure, read-only SQL access to contextualized operational data, streamlining integration with standard BI tools.
Tunde Okafor
Integrating PI System with Oracle Portal: Strategies & Best Practices
Explore effective strategies and best practices for integrating AVEVA PI System data into Oracle Portal, enhancing operational visibility and streamlined decision-making.
Megan Tremblay
Troubleshooting PI Connector for EtherNet/IP with ASG Fastening Modules
Resolve integration challenges between the PI Connector for EtherNet/IP and ASG Precision Fastening modules by understanding device roles and crucial configuration steps.
Andres Vargas
Power BI & PI System: Troubleshooting Query Parameter Challenges
Overcome common challenges when integrating Power BI parameters with PI OLEDB Enterprise or PI SQL Client. Learn effective workarounds for parsing and type casting issues with dynamic SQL and proper configuration.
Emily Watson
Troubleshooting PI Web API with VBA: Resolving URL Connection Errors
Learn to troubleshoot common PI Web API connection errors when using VBA, focusing on resolving malformed URL issues and understanding HTTP responses for efficient PI Point data access.
Ahmed Hassan
About #Data Integration
Explore our collection of articles tagged with #Data Integration. Our expert contributors share their knowledge and experience to help you succeed with PI System implementations.
From configuration tips to advanced development techniques, these articles provide practical guidance for PI System professionals at all levels.