Voices: OPC Connection

Free Your Mind with OPC HDA ... and the Rest Will Follow

How Do I Access the Data Files/Tables on Your HDA Historian?

By Mustafa Al-mosawi

There are few things I enjoy more than seeing the light go on in someone's mind, and the are few better places to see this than at an OPC Training Workshop. A student asked a very good question, and a few days later, when visiting a customer site, the same question came up again. So – here I am blogging about it.

The question asked both times was this: How do I access the data files/tables on your HDA Historian?

Some of you are probably chuckling under your breath. But these are very smart people—experts with a wide variety of technology. So why the disconnect? OPC-HDA wasn't something they were familiar with. So if you don't think that's a funny question, here are two answers for you: one short, one long.

Short answer: You don't. You don't. Need. To. That's the point. Any HDA tool will get you all the access to the archived data you need.

Long answer: You don't. You don't. Need. To. The whole point of the OPC HDA standard is to remove the need to understand deeply how the data is archived, accessed or organized. I can store my data in a single file or fifty-thousand. I can store them as csv, xls or DAT files. I can store them with an advanced configuration database with advanced lookups or in one giant, long, insanely over-indexed table. I can store the data however I want. HDA makes no restriction about which mechanism I should choose. The OPC HDA server's job is to make that invisible to you, whichever archive you choose.

That's the theory anyway. In reality, not all HDA servers or archives are created equal.

Archive structures are defined by good engineering, design constraints and project requirements. Choosing poorly can have implications related to security, reliability, auditability and availability of the data. Ultimately, whichever archive you or your vendor choose, the HDA server needs to understand the database schema, or the file structure. The HDA server is responsible for figuring out which files to open, how to structure the query, and for packaging them up so any OPC HDA client can understand the answer. The HDA server is almost always separate from the archive—just as the OPC DA server is almost always separate from the device.

Like DA, HDA frees you to pick and choose whatever tool to access the data from your historian. That's how OPC Excel Reporter and OPC Easy Trender work with any historian on the market, and how OPC Desktop Historian works with any HDA tool.

So instead of database schemas and file structures, gain knowledge about your processes and equipment performance from a wider variety of data sources with a greater selection of tools. That's the power of OPC.


Mustafa Al-mosawi, BSc, is Matrikon’s product manager for Matrikon Analytics. He has 8 years experience in design, develop­ment, commissioning and testing of industrial software products. Mustafa previously worked in the nuclear industry as a business and systems analyst with Ontario Power Generation-supporting next generation initiatives. Prior to his current role, he was a senior product designer for the Matrikon Suite of products, including Operational Insight, Alarm Manager, and TaiJi PID.

Read Mustafa Al-mosawi's blog "OPC Exchange."

More from this voice

Title

Winning the battle for interoperability

In a special-to-the-web article for OPC Connection, OPC specialist Eric Murphy presents his thoughts on what it will take to achieve the mission of true interoperability.

01/16/2007

What is OPC in 2010? It is all about the tag

OPC Is Three Letters That Are a lot of Things to a lot of Different People, but What It Really Boils Down to Is Moving Data and the Tag

01/28/2010

Waste Not, Want Not

Monitoring Wastewater Assets with OPC

06/12/2008

Unified architecture – The future of OPC

With its eye on the future, the OPC Foundation has preserved all the work that has gone before and embarked on the creation of the Unified Architecture as a way of adjusting to the ever-changing Microsoft world.

12/28/2004

Trans-Domain Technology Proliferation

Trans-Domain Technology Proliferation Best Describes What OPC Is to Many Industries

10/01/2008

There’s OPC in Them There Oil Fields

Companies are using OPC connectivity to overcome challenges oil coaxing.

12/17/2007

The Straight Scoop on OPC and Security

What You Need to Know about OPC-UA and OPC-Xi

10/05/2010

SCADA deployment using OPC

Integrators must differentiate between a plant-based OPC mentality and SCADA applications when attempting to apply industrial standards to SCADA-based implementations.

08/01/2005

Safe and Secure with OPC Technologies

Learn about the Security Features the OPC Portfolio Offers Reducing the Risk to Control System Integrity

07/26/2010

Real-time asset management and OPC

Used as a standard technology platform from which to build real-time applications and practices, OPC can ultimately lead to an immediate impact on your bottom line. This article discusses how OPC can be applied in an industrial setting to help improve your asset management practices.

08/04/2005

Real Time for Maintenance Savings

Reduce Costs with CBM and OPC Real-Time Data

07/29/2009

OPC: Standardizing Integration of Security and Energy Management

OPC Standards Play a Major Role in Accessing and Integrating Energy Management Data

10/14/2010

OPC, Modbus and Fieldbus, Oh my!

Just as Dorothy and her companions each had unique characteristics, end users are faced with a multitude of protocol choices for use in the heart of their industrial process: their communications network.

03/30/2007

OPC – A decade of success by any standard

OPC specialist Eric Murphy brings the latest in OPC technology and specifications, and his thoughts on where the technology is headed, to OPC Connection, our new Site Resource for the OPC community.

08/10/2006

OPC Unified Architecture

Watch this video by the OPC Foundation and learn about the history of OPC technology, the next generation of OPC technology, what OPC-UA is and what it can do for you.

03/25/2010

OPC UA: The One and Only

OPC UA Is the Solid Foundation, Vision and Infrastructure of the OPC Foundation

04/27/2009

OPC UA – Up and Running

So what exactly is OPC Unified Architecture (UA) specifications, and when can I get it?

09/13/2007

OPC UA Security: Do You Have Reservations?

Reservations about OPC UA Security Implementation

12/12/2008

OPC UA enables Business Intelligence (BI)

In a special-to-the-web article for OPC Connection, OPC specialist Eric Murphy presents his thoughts on OPC UA and how it offers the promise of unifying individual business units into true enterprise-wide solutions.

02/16/2007

OPC UA - On the Road to the Smart Grid

New Standards Help Achieve Interoperability Among Devices and Systems

01/28/2010