iFIX supports relational databases, such as Microsoft SQL Server and Oracle through Microsoft's industry-standard Open Database Connectivity (ODBC). Using the SCU, you can set up your server to access multiple relational databases from a process database. The SCU's SQL functionality allows you to read and write data between a SCADA server's process database and multiple relational databases.
To access a relational database data
source:
- Set up your relational database and ODBC driver.
- Configure the ODBC data source.
- Add the database to the SQL connection list.
- Create the library and error tables.
For more information on accessing relational database data sources, refer to the Installing and Configuring Data Sources chapter in the Using SQL manual.
