Direct Extract from OSI PI (FT Historian)

phuz · Jan 30, 2023

What's the best method to extract raw data from the FT Historian's OSI PI?

harryting · Jan 30, 2023

Does FT Historian comes with SMT, with SMT you can view and export out data in CSV. Datalink (a plugin for Excel) is a better option as you can format thing and get multiple tags at the same time. Rockwell offer it but probably additional $.

phuz · Jan 30, 2023

harryting said:
Does FT Historian comes with SMT, with SMT you can view and export out data in CSV. Datalink (a plugin for Excel) is a better option as you can format thing and get multiple tags at the same time. Rockwell offer it but probably additional $.

Not sure about SMT, but will inquire.
Is there a tutorial on using Datalink with Excel to grab that data? It's been a long time since I've used Excel as a connector for anything.

harryting · Jan 30, 2023

just search youtube for "PI Datalink". I bet there's a function in the Rockwell historian charting tool that do that do but that's not something I use so I don't know.

cardosocea · Jan 30, 2023

+1 for Datalink. Particularly because you can program what data to retrieve and even get PI to spit out calculated data as well.

Pretty powerful stuff.

Ken Moore · Jan 30, 2023

SMT is the System Management Tool. Every FT Historian has it installed on the server.
You can browse tags look for bad and or stale tags. Get current values, view recorded values. Set up trust and security, file management etc...

phuz · Jan 31, 2023

Perfect. I found them in SMT.
Do you happen to know which table(s) in the PIFD SQL database hold the actual data?

Direct Extract from OSI PI (FT Historian)

phuz

Member

harryting

Lifetime Supporting Member

phuz

Member

harryting

Lifetime Supporting Member

cardosocea

Member

Ken Moore

Lifetime Supporting Member

phuz

Member

Similar Topics