Data Guru tools

If you have Data Guru projects that you want to use with Supply Chain Guru X, you can add and configure them in the Data Guru Tools function.

  1. Select Data Guru > Data Guru Tools.
  2. Click New Tool.
  3. Enter the name of the new Data Guru tool.
  4. Click Configuration. You see the Data Guru tool configuration tab.
  5. Enter an existing Data Guru project or click Browse and navigate to the project (.dgproj) and click Open. By default, Supply Chain Guru X uses the default Data Guru folder when you first add a tool. Subsequently, the default location is the last folder used.
  6. Select one of the following to use for this tool:
    • Workflow – Workflows defined in the project are listed.
    • Macro – Macros defined in the project are listed.
    • Action – Actions defined in the project are listed.
  7. Select the item (workflow, macro or action) in the list box that should be run.
  8. Configure the parameters for this item. For each parameter:
    • Select the checkbox to include the parameter
    • Select the type of parameter:
      Parameter typeDescription
      Server NameSupply Chain Guru X passes the current user’s SQL Server instance name to the parameter. The default is “localDB”.
      Current Model NameSupply Chain Guru X passes the name of the current model to the parameter.
      New ModelSupply Chain Guru X creates a new model with the name as specified by the parameter value. The new model is attached to the current user’s SQL Server instance.
      Interface LanguageSupply Chain Guru X returns the two-character code for the currently selected interface language. For example, if English is selected, the code “en” is returned, if Spanish is selected, the code “es” is returned.
      ScenarioSupply Chain Guru X pulls all existing scenario names for selection, and passes the ID of the selected scenario to the parameter. The default is 0, for the Baseline scenario.
      Expanded ModelSupply Chain Guru X expands the current model using the selected scenario (as described above). If no scenario is provided, Expanded Model uses 0 as the ScenarioID (for the Baseline scenario). The new model is named with the provided value and attached to the user’s SQL Server instance.
      StringSupply Chain Guru X passes the entered value to the parameter.
      IntegerSupply Chain Guru X passes the entered value to the parameter.
      DateSupply Chain Guru X passes the entered or selected value to the parameter.
      BooleanSupply Chain Guru X passes the entered or selected value to the parameter.
    • Enter a value if required for the parameters
  9. Click Apply.

    Notes regarding parameters:

    • For any string parameters, select whether the parameter is a Prompted Value, the Server Name, the Current Model Name, or a New Model.
    • For New Models, specify how the model should be named.
    • For all other parameter types, you see the parameters, but there are no additional configuration options. These parameters will be treated as Prompted Values.
  1. Once you create a Data Guru tool, you can reconfigure the tool using the process described in Add and configure a Data Guru tool.
  2. When using tools, the following apply:
    • Tools persist when you close and re-run Supply Chain Guru X.
    • Tools are not specific to the currently open model.
    • Tools are specific to your user account. You will not see the tools of other Windows users.
    • You can delete tool configurations you have created.
  1. Select Data Guru > Data Guru Tools.
  2. Select the tool you want to run.
  3. Click Run. You see the Run tab with a description of the operation and the parameters you need to populate.
  4. Click Run.
  5. Enter the values for any parameters you have configured.
  6. For transformations that create one or more new models, you will have the option to open a file explorer window to the file path of the new model(s) upon successful completion of the transformation.

    In the case that the transformation is not successful, you have the option to open a file explorer window for the log file location.

Last modified: Wednesday May 15, 2024

Is this useful?