Connectivity of ORACLE Database with OPC Server

[vijtin]

Hello,

I am using NI Industrial Automation OPC server version 5.1.

I have Oracle database server. In this Oracle Database server I have created 1 table in wich data from tempertaure controller are getting logged.

I want to establish connectivity between my Oracle Database Server table & NI Industrial Automation OPC server version 5.1.

Is it possible to make connectivity between Oracle Database Server table & NI Industrial Automation OPC server version 5.1?

vijtin

[Ryan.S]

IA OPC Server cannot directly connect to the Oracle database. You need another software which is able to connect both IA OPC Server and Oracle.

[vijtin]

Hello Ryan,

Thanks for reply.

Plz suggest me which software is require to connect both IA OPC Server and Oracle Database Tables?

vijtin

[Ryan.S]

NI Lookout and LabVIEW can do this. LabVIEW DSC module is able to connect IA OPC Server, or you can just use the LabVIEW datasocket to read data from IA OPC server. For oracle connectivity, LabVIEW has database connectivity toolkit.

Lookout has OPClient object to connect IA OPC Server, and SQLExec object to execute sql statement.

[STTLLER]

Hi friends

 Hello everyone ! This is Joseph. Thanks for the Information.

Joseph