Configuring Dataflow Options - Query NoSQL DB

This procedure describes how to configure a dataflow to support runtime options for Query NoSQL DB.

  1. Open the dataflow in Enterprise Designer.
  2. If you want to configure runtime options for a stage in an embedded dataflow, open the embedded dataflow.
  3. Click the Dataflow Options icon on the toolbar or click Edit > Dataflow Options. The Dataflow Options dialog box appears.
  4. Click Add. The Define Dataflow Options dialog box appears.
  5. Expand the Query NoSQL DB stage.
  6. The below dataflow options are exposed to query a Mongo DB database:
    • Connection
    • Table
    The selected Query NoSQL DB option name is displayed in Option name and Option label fields. This is the option name that will have to be specified at runtime in order to set this option.
  7. Enter a description of the option in the Description field.
  8. In the Target field, select the option Selected stage(s).
  9. If you want to limit the values that can be specified at runtime, edit the options in the Legal values field by clicking on the icon just to the right of the field.
  10. If you want to change the default value, specify a different value in the Default value field.
    Note: For a service, you can only modify default values before exposing the service for the first time. Once you expose the service you can no longer modify default values using Enterprise Designer. Instead, you must use Management Console. For more information, see Specifying Default Service Options.
  11. Click OK.
  12. Continue adding options as desired.
  13. Click OK in the Dataflow Options dialog box when you are done adding options.
  14. Save and expose the dataflow.