How do I connect to Honeywell Uniformance PHD?

[andreas_koehler]

Hi all,

How do I connect to Honeywell's Uniformance process historian database?

When I try to connect via OBDC or OLE DB I get the error message

SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154

Is there anyone familiar with this?

Thanks in advance.

Best Regards.

[petter]

The ORA-12154 is an Oracle specific problem. You probably has some parameters wrong in your Oracle driver setup.

You can Google ORA-12154 and you will gets literally thousands of hits for it amongst others a Youtube video that instructs you have to resolve that issue:

Google:

     How to resolve the ora 12154 error

And click the Youtube link...

[Anonymous]

Ah!  The old ORA-12154, usually means that it cannot find the Service Name due to a typo in the tnsnames.ora.

Your DBA should be able to help you.

[andreas_koehler]

Thanks for the answers I received.

We finally sorted it out.

A) We had to use Oracle11gR2 in its 64bit version.

B) The location of the TNANAMES changed compared to the Oracle 10 we used before. It had to be located in the folder network/admin (or similar. writing it from memory).

If someone else happens to have a similar problem, don't hesitate to contact me.

[andreas_koehler]

Update:

Although I can access Honeywell Uniformance via SQL now, the PHD data is stored in flat files outside of SQL.

I guess I have to find a way to use Excel makros to access the data and then read the data into Qlikview.

[petter]

In general Excel is not a very good tool to read flat-files and transform them into the right format.

But the answer really depends on your Excel environment in the first place. So...

Do you have any kind of ready-made solution in Excel that access the PHD data already. Is there already

macros developed and are they using an OPC server interface to get to the data?

If you already have access to the PHD flat files on a file storage device then maybe reading them directly into

QlikView is a much better option. Do you have the format specifications of the PHD-files? Are they complex?

How about your requirements? Do you need all types of information out of the PHD-files or is it more a simple
query of information you have?

kind regards

Petter Skjolden

[andreas_koehler]

Hi Petter,

Honeywell provides an excel add-in that can read data (average, snapshot etc) and raw data via customized functions in which the host, Tagname, start, end, method of retrieval and the requested return fields are specified.

Honeywell has not provided any information on format or location of these flat files.

My requirements are rather simple: I want to read the values that are transfered from the process controllers to the process historian. For most tags one value per minute is sent to the historian where it is stored using some basic data compression. The historian itself allows some aggregation but that is not what I am interested in and the attributes of the tags are rather static.

Presently I see three options:

1. Find the flat files and understand their format so that I can read them in via Qlikview
2. Creating manually a set of process data as several tables (to the maximum of excels row capacity) per relevant tag in a standardized format.
3. Creating makros to make (2) less laborious.

Naturally I prefer accessing the flat files directly. I will dig into this.

Kind regards,

Andreas Köhler

[petter]

Have you considered using a product like one of the many products MatrikonOPC is offering? They might be what you are looking for and give you the flexibility to transfer your data to QlikView.

[Anonymous]

Hi,

I tried to connect to my Uniformance PHD using SQL server.

I type defaultPHD as the database and keep the 1433 for the port.

But no luck, got couple of error message 28000 and 08001

please advise.

Kind Regards,

Hannan