AlistairFrith

Options for building AF structure from RDBMS asset DB

Discussion created by AlistairFrith on Feb 10, 2011
Latest reply on Feb 11, 2011 by skwan

We have a project to upgrade & modernise an existing PI System, along with creating some screens etc to show the data (PI has been a bit of a data sink up till now).

 

One of the things they will need is an AF database. they currently have an Asset DB held in (I think) Oracle. I have seen some of the data in this DB that has been extracted into Excel. What options do I have for creating an Asset Hierarchy in AF?

  • Format spreadsheets and upload using AF addin (is there such a thing?)
  • C# .NET application reading directly from the source DB and using the AF SDK to build the hierarchy?
  • Anything else

--- Alistair

Outcomes