Skip to content

Opcenter Execution Discrete SQL Server

The following functionalities are available for these SQL Server data sources:

  • Opcenter Execution Discrete (Opcenter EX DS) 3.0
  • Opcenter Execution Discrete (Opcenter EX DS) 3.1 - 3.2 - 3.3
  • Opcenter Execution Discrete (Opcenter EX DS) 4.0
  • Opcenter Execution Discrete (Opcenter EX DS) 4.1 - 4.2 - 4.3
  • Opcenter Execution Discrete (Opcenter EX DS) 4.4 to 2607

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.

Notes

  • If you are using Opcenter Execution Discrete 2301.0001 or higher as a data source, when more than one equipment hierarchy has been configured, only the equipment hierarchy flagged as default is loaded into the Manufacturing Data Warehouse. If only one equipment hierarchy exists in Opcenter Execution Discrete, it is loaded into the MDW.
  • If you are going to activate the Context Manager, follow the recommendations on the configuration of data sources to ensure that the contextualization works correctly.
  • If you have configured cleaning rules in database, please check the recommendations in "How to manage interaction between EX FN Cleaning Rules and OCIN Flow Schedules" to avoid overlap between them and  flow schedules.
  • If you expect to read and load a very large volume of data from the Opcenter EX DS data source, you may consider creating a set of recommended indexes on the source database (UAF DB) to improve ETL performance. The list of these indexes is available in Opcenter Intelligence Reference manual.

Functionalities

  • Certification Management (available starting from version 4.4)
  • Defect and Non Conformance
  • Equipment Management
  • Equipment Performance
  • E2E Production Tracking (available starting from version 4.4)
  • Labor Management
  • Labor Performance
  • Location Management
  • Material Management
  • Production Definition
  • Production Execution
  • Production Scheduling
  • Quality APC

Last update: October 26, 2026