Opcenter Execution Electronics SQL Server¶
Prerequisites¶
When you create a SQL Server source, you must add a login with the following roles:
- dbcreator server role in the SQL Server instance of the source database using the credentials of the Domain User you inserted in the Opcenter Intelligence Connect Cloud Configurator.
- db_datareader database role for each source database you want to access and from which you want to extract data.
Functionalities¶
The following functionalities are available for Opcenter Execution Electronics (Opcenter EX EL) 8.9 to 2604 as a SQL Server data source.
- Completed WIP
- Container Management
- Defect and Non Conformance
- Downtime Management
- Equipment Management
- Equipment Performance
- E2E Production Tracking
- Labor Management
- Location Management
- Material Management
- Operational Performance and Quality
- Product and Material Traceability
- Production Execution
- Quality APC
Last update: October 26, 2026