Oracle as a database for PVSS
- cna_ess
- Posts:2
- Joined: Tue Nov 09, 2010 7:21 am
Oracle as a database for PVSS
I've PVSS 3.8. I wish to use Oracle as a database for archiving.Can you please recommend which Edition (Enterprise,Standard,Express etc) of Oracle can be used?
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: Oracle as a database for PVSS
Hello,
the software requirements for PVSS are described in the PVSS online help (chapter System Management --> Database --> RDB archiving).
I've copied the information from the online help to this posting:
The PVSS 3.8 RDB Manager requires the Oracle client version 10.2, 11g (Standard or Enterprise Edition) on Windows, Linux or Solaris (Solaris X server with Oracle server 10g or 11g is supported).
Best Regards
Leopold Knipp
Senior Support Specialist
the software requirements for PVSS are described in the PVSS online help (chapter System Management --> Database --> RDB archiving).
I've copied the information from the online help to this posting:
The PVSS 3.8 RDB Manager requires the Oracle client version 10.2, 11g (Standard or Enterprise Edition) on Windows, Linux or Solaris (Solaris X server with Oracle server 10g or 11g is supported).
Best Regards
Leopold Knipp
Senior Support Specialist
- cna_ess
- Posts:2
- Joined: Tue Nov 09, 2010 7:21 am
Re: Oracle as a database for PVSS
Thanks for your response.have ever used MS SQL instead of Oracle with PVSS?
- mweber
- Posts:42
- Joined: Mon Aug 02, 2010 11:23 am
Re: Oracle as a database for PVSS
Hello Chiranjit,
our RDB manager is currently only supporting Oracle (no other SQL databases whatsoever).
Nevertheless you could interface with other databases using our scripting language CTRL - there are numerous functions available to connect to any third party database by using ODBC / ADO mechanism within a control-script.
But be aware that this is done inside interpreted CTRL-code that means you will not achieve high performance with this method and therefore it shall not be used to store all of your historical process data but maybe some selected Datapoints would be no problem of course.
best regards
Markus Weber
our RDB manager is currently only supporting Oracle (no other SQL databases whatsoever).
Nevertheless you could interface with other databases using our scripting language CTRL - there are numerous functions available to connect to any third party database by using ODBC / ADO mechanism within a control-script.
But be aware that this is done inside interpreted CTRL-code that means you will not achieve high performance with this method and therefore it shall not be used to store all of your historical process data but maybe some selected Datapoints would be no problem of course.
best regards
Markus Weber