Is that possible to insert/update data from PI/PI AF to another Microsoft SQL DB by PI Integrator BA?
I don't have any experience with PI Integrator for BA but:
Import data to SQL is simple with OLEDB.
Just install PI OLEDB Enterprise on the SQL server and create a linked server towards the PI Data Archive/PI Asset Framework servers
The short answer is yes if you have the right edition. PI integrator for BA has 2 editions.
1 - BI Edition: With BI Edition, you can only publish your data to PI View within MSSQL Server.
2 - DW (Data Warehouse) Edition: With DW edition, you can also publish your data to SQL Server directly.
More details are in the following link - PI Integrator for Business Analytics editions
So with BI Edition when publish data to PI View which is stored on PI Integrator sql server, is it sql view, can user select data from this view?
It is a sort of SQL View but it can only be accessed via PI ODBC Driver and it supports below SELECT statement syntaxes!
Supported SELECT statement syntax
This KB might be able to give you a glimpse of what PI View looks like in BI tools:
KB01377 - How to Connect ODBC Client Software to access PI Views
Yes, we use the Data Warehouse edition to publish to SQL Server or SQL Express, as you can add different publish targets:
We use SSMS to check that our data is publishing correctly and test our queries, then use the RDBMS interface to get the data into PI.
Thanks all for answers,
what difference between PI Integrator for BA and PI Integrator for Microsoft Azure,
it seems in both cases we can create PI views and publish PI data in PI Integrator SQL Server DB?
The only key difference I see is in PI Integrator for Microsoft Azure in addition to above you can also publish from PI Integrator SQL Server DB to Azure cloud SQL Server DB.
As you say, the only key difference between the PI Integrator for BA and the PI Integrator for Microsoft Azure is where they can publish data to. The allowable targets are:
PI Integrator for MS Azure:
- PI View (stored in MS SQL Server, accessible via PI OBDC Driver)
- Azure SQL Database
- Azure SQL Data Warehouse
- Azure Data Lake
PI Integrator for Business Analytics:
1) BI Edition
2) Data Warehouse Edition
- MS SQL Server
- Flat File
- Hadoop HDFS
- Apache Hive
Hope that helps clear things up.
Retrieving data ...