Complete the following steps before running iFIX ODBC.
To prepare for using iFIX ODBC:
- Set up your relational database on the server along with user accounts and passwords. Consult your relational database manuals for specific instructions.
- Set up the ODBC driver to communicate with iFIX. To do this, use the relational database tools that come with your SQL software.
- Define the SQL commands. To do this, create a library table that contains the SQL commands you want executed. The examples in this manual use SQLLIB as the SQL command table name.
- Create the error log table that stores all SQL runtime error messages that are recorded by the system.
- Set up or upgrade your network to support communications.
- Configure iFIX ODBC.
- Confirm that the SCADA node can establish network communications with the server by using an ODBC test program supplied by your ODBC vendor (such as MSQUERY).
NOTE: When logging alarms to an Oracle database, you must use the Microsoft Oracle driver or data loss could occur.
To configure iFIX ODBC:
- Ensure that the SQL task is added to the Configured Task List in the SCU Task Configuration dialog box. Refer to the Configuring the SQL Task section for more information on configuring the SQL task.
- Add an account for each relational database you need to communicate with to the Configured Accounts list in the SCU SQL Configuration dialog box. Refer to the Installing and Configuring Data Sources section for more information on defining specific accounts.
- Configure the SQL task using the Configure SQL Task dialog box in the SCU. Refer to the Configuring the SQL Task section for more information on configuring the SQL task.
- Define the SQT and SQD blocks in the iFIX database. Refer to the iFIX Database Reference for more information on blocks.