DARTS : Set Up Parameters for Database

Datamart in SQL Server uses two different servers and multiple databases. This instruction shows how to create a connection parameters for retrieving data from a SQL Server database. The template file has been set up with all of the servers and parameters, but when new server or database is added, this page may help you to add new one.

Go to Transform data > Transform data
Click the Manage Parameters > New Parameter.
Enter name and description of the parameters. Choose 'Text"under Type, "List of values" under suggested Values. Enter all database names. Choose Default Value and Current Value. (For SQL Server, we have both Server and Database, so we need to set both.)
Go to other data table. Click the gear icon under "Applied Steps" box and change the drop-down list to "Parameter" from "Text" on the pop-up window. Choose an appropriate value for Server and Database by clicking drop-down list.
If you would like to show parameter value on the report, right click on the parameter and check "Enable load".
Click "Close & Apply"
If you would like to change the parameter values later, go to Transform data > Edit Parameters. The pop-up window will show up and you can pick from the droop-down list.
You can save parameters on Template (.pbit) file.