Only paid members are able to download PI Data Archive and PI AF Server install kits.
The easier option to create a sample database is to import an XML file. Then you won’t need to create/modify any script or program. One possible option is the NuGreen database which could downloaded here.
We can provide a code snippet to create a sample database programmatically using PI AF SDK if you want to.
Hope it helps!
Fantastic - thanks.
What's the best way to import the xml file?
A few ways to import the XML file. You can learn more about XML import/exports here: OSIsoft: Import/export AF objects using XML with the PI System Explorer. v2010 - YouTube
The quick/easy way is to use PI System Explorer to import as shown in the video. You can use the AF SDK to do the import as well but if you are doing this just once it probably doesn't make sense to go down that road.
I would recommend installing the AF Server before the PI Data Archive Server. I'm pretty sure the newest PI Data Archive server requires you to point it to a AF Server during the installation process.
If you need other "mock" databases I would check out the Asset Based PI Example Kit(s) in the OSIsoft download center. They are industry specific and use a number of best practices when for AF Database setup. A great way to get started with mock plant real fast!
Thanks for that - unfortunately I'm not a paid member so I'm not able to get the AF + Data Archive servers installed.
All I really want is a static database that I can query through the PI JDBC driver.
I'll have to look into other ways of importing the test database.
The PI JDBC driver won't work be able to return data without the PI System installed properly.
This also means that even if you have a static database the JDBC driver will not be able to return any data, as it needs a connection to the AF Server.
Hope this helps,