AVEVA™ PI System™ Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Add a new idea Subscribe
Status Declined
Product PI Integrators
Categories AVEVA™ PI Integrator for Business Analytics
Created by Guest
Created on Aug 16, 2022

RELATED IDEAS

Add a generic ODBC target

Add a target that points to a DSN or where you can specify the connection string (including the driver) this would allow to insert in any database that has an ODBC driver for Windows.
  • ADMIN RESPONSE
    Aug 16, 2022
    It is not possible to create a "generic" ODBC target because most proprietary ODBC drivers have their own specific reserved strings & functions that do similar things but are named slightly differently depending on the vendor. These functions must be specifically translated to work with the PI Integrator. To date, we support writing to PI Views, Oracle, and SAP HANA via the ODBC standard. If there is a need for a specific type of ODBC driver, please create a new idea and we will look into it. Thanks!
  • Attach files
  • Guest
    Reply
    |     Aug 16, 2022
    I was thinking on using the SQL Standard (ISO/IEC 9075), so no matter the vendor, if it supports the standard functions and data types, it should work. What I mean is, even if there are a lot of vendor specific functions, there are also standard ways to create a table and insert rows. As long as your ODBC driver supports the standard, you could use it with the PI Integrator for BA. Examples of Databases that could be used with this options are: PostgreSQL, MySQL and IBM DB2.