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.
See Also
How Do I...
Important Notice
You do not have the latest version of iFIX! You are missing out on the newest capabilities and enhanced security.
For information on all the latest features, see the iFIX product page.
For more information on upgrades, contact your GE Digital sales agent or e-mail [email protected].
For the most up-to-date documentation, go here.
