Fetch Data from Intellience Datastore

You can use the database activity to fetch the data from the AVEVA Work Tasks Intelligence (EMI) datastore.

Database activity, a part of Engine activities, is an activity inside the workflow where the workflow establishes the connection to the database server and performs actions to retrieve data from the database. This activity executes user queries and the result is in created in an XML variable. This ml variable has the schema of columns of the database table and contains values based on the query made.

Before creating the database activity, you need to create a database connection object, which connects to the AVEVA Work Tasks Intelligence datastore.

Scenario: The AVEVA Work Tasks Intelligence datastore has the historical OEE data of the plant. This data can be sent to corporate management, plant management, and engineers, for them to know details of the performance, quality, and availability of the plant. For example, corporate management can be updated with the production information, such as total numbers of products, defective products, expenses of plant on a weekly basis.

For this feature to happen as part of the workflow, we need to create the database activity to fetch the data from the fact table and the dimension tables.