Support PLC Engine Collect
Panoramica: Oracle database, Microsoft SQL database, Big logic, Big logic tables, Databases in the network, Chains, Install.
A short description of the Oracle ODBC configuration (Windows and Linux) lies here.
Question: Oracle over ODBC does not deliver browsing data ?
Aswer: The Oracle database will need the username and the password from the PLC Engine Collect connection configuration. The ODBC driver configuration does not offer an entry field for the password.
In the database access logic element the schema name can not be browsed, Oracle does not support this. You need entering the username of the connection - in capital letters.
Divide the logic in multiple steps of a sequence chain.
Ideally one logic table drives one output only. Multiple simple outputs can be used in parallel and will be connected to the step change element.
The build in sequence chains are extremly fast. So many steps do not change the speed.
Place all members of a sequence chain in one group.
Please do not forget jumping back to the first step on the end of the sequence chain.
In reality no, and it does not affect the speed. The technical limits are available under technical data.
But it is much easier to handle using more and smaller logic tables.
PLC Engine Collect is containing a MySql database internally. It can used additionally to databases running on other stations.
With sequence chains. At any time one step only is handled. If it will become ready it can be switched to the next step or any other.
Call the installation program with the parameters
<name of the installer> -destination=<destination directory> --i-agree-to-all-licenses --noprompt --noreadme --nooptions
Please check the return value, the installation breaks on any error.