Hi,
I need help understanding how to setup the following scenario and if it’s possible.
Our company had an import scenario setup to generate a BOM from an excel file. This excel file was supplied already filtered for a specific order.
To facilitate automatic imports, we are looking to utilize a SQL Data Provider. We can successfully access the View in the SQL database and import the BOM. However the view contains all orders from an external system and not the filtered data found in the excel file. Is it possible to create an SQL import scenario where it connects to a SQL View but filters the data based on a dynamic parameter?
For example, let’s say we have 4 orders and want to utilize import scenarios. Is it possible to accomplish the following from the one BOM Import Scenario?
Order #1 → BOM Import Scenario - SQL → Filter SQL View by Order 1
Order #2 → BOM Import Scenario - SQL → Filter SQL View by Order 2
Order #3 → BOM Import Scenario - SQL → Filter SQL View by Order 3
Order #4 → BOM Import Scenario - SQL → Filter SQL View by Order 4
Thanks!
Kevin
