Skip to main content

How to find which SQL views are being used in the Data Flow to import the data

Written by Charnjit Singh Dharival
  • Which ASC view will show the Quantity Produced which is imported into Orchestrate, how can we do this?

  • How to find the FM view that imports the works orders into Orchestrate.


To find out what SQL views are being used in the Data Flow, please complete the following steps:

  1. Log into Orchestrate System Manager

  2. Click on File

  3. Click on Data Import Configuration then Data Flow Configuration

  4. Select your Import and click on Edit

  5. Find the sequence you wish to see the view for and click Settings

  6. You will find which table or view is being used in the 'Source Table' field

  7. Click OK once you are finished

NOTE: Please don't modify any data sequences or data mappings because the data import would error.

Did this answer your question?