All docs
V21.2
21.2
21.1
20.2
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

Specify Data Source Settings (Database)

  • 2 minutes to read

Select a Data Connection

The “Choose a data connection” page appears if you select Database on the start page. Select an existing connection from the list.

Choose Queries

The next page allows you to create/edit a query or select a stored procedure. The image below displays a generated query displayed in the SQL string editor.

wdd-configure-query-parameters

Click Run Query Builder… to launch the Query Builder and choose the tables/columns visually.

Configure Query Parameters

If the SQL query contains query parameters, click Next to configure them.

wdd-configure-query-param-page2

You can use the following approaches to specify a parameter value:

  • Assign a static value

    Select a query parameter’s type from the Type drop-down list and specify a value based on the selected type.

  • Provide a dynamic parameter value

    Set the Type option to Expression and specify the Result Type. Click the Value option’s ellipsis button and construct an expression in the invoked Expression Editor.

Click Finish to create a new data source.

API

The database wizard pages are identified by the following API:

Page Name Page ID Class
Choose Connection (Database) SqlDataSourceWizardPageId.ChooseConnectionPage ChooseSqlConnectionPage
Choose Queries SqlDataSourceWizardPageId.ConfigureQueryPage ConfigureQueryPage
Configure Query Parameters SqlDataSourceWizardPageId.ConfigureParametersPage ConfigureQueryParametersPage
Choose Queries (a multi-query version) SqlDataSourceWizardPageId.MultiQueryConfigurePage MultiQueryConfigurePage
Configure Query Parameters (a multi-query version) SqlDataSourceWizardPageId.MultiQueryConfigureParametersPage MultiQueryConfigureParametersPage
See Also