If you search the forums (vba+processbook+sql) you'll find posts such as this: https://pisquare.osisoft.com/message/36537#comment-36537
Just adapt it with the correct Oracle provider and connection string and you'll be ready to go, using an "Insert" query to write back to Oracle.
If you choose to write back to a PI tag, one of the top search results is this thread: How can i create a numeric input in the processbook?
Thank you for quick reply,
i try to be more clear on what i want to do, i have created a XE oracle database in order to store all calculation made in PI (i have some calculation run in PI and wanted to store them in xe oracle database). this will help me to plot the history of the calculated values via using ODBC.
so my concern how to store data from PI to oracle database using vba. example: i have textbox.value to ba saved in a specific row in table in database.
hope my question is clear now
thank you in advance
1 of 1 people found this helpful
The question is clear, but I'm not going to do the job for you
The first example shows how to get a SQL connection up and running, and also shows how you can input a query. If this query contains a 'select' to get data, 'insert' to write data, or 'update' to update existing data is up to you to decide.
A tip would be that this operation is not common to PI or ProcessBook. This is pure VBA so you can probably google a complete solution
i already manage to connect and update data. i followed the example u mentioned and some info from google.