Enter the URL for the application web server. This is the virtual directory for the web application. Generally, the format is “http://[Server name]/[Virtual directory name].”

Enter the database name that appears in the select database prompt of the application login screen

When running this utility in a hosted environment, specify the HostedSiteID in order to retrieve the list of databases associated with a site.

Specify the password for the Web Service User.

Specify the user name to use when connecting to the web service. This is required if the virtual directory is configured for Basic Authentication.

Select whether to validate the URL for the application web server in the Application root url field.

Enter the SQL Server instance for the application database.

Enter the name of the application database.

For users with The Raiser’s Edge, enter the name of the source database for The Raiser’s Edge.

For users with The Raiser’s Edge, enter the SQL Server instance for the source database. To deploy the standard data mart, the source database must use SQL Server 2005 or higher.

For users with Blackbaud CRM, enter the name of the database for the OLAP cube.

For users with Blackbaud CRM, enter the SQL Server instance for the OLAP database.

For users with Blackbaud CRM, enter the name of the database for the data mart.

For users with Blackbaud CRM, enter the SQL Server instance for the data mart.

The data mart uses the same database as the application, and the data mart key distinguishes data mart files from other files in the database. This key appears at the beginning of tables, stored procedures, and other items in the SQL Server schema.

Enter the location of the manifest file. This is an XML file with metadata about the data mart installation that determines the information in the other fields under Deployment file. The deployment folder from the Data Mart tab contains the manifest file.

This field displays the data mart type as it appears in the application.

For users with The Raiser’s Edge, only the standard data mart for The Raiser’s Edge is available. For users with Blackbaud CRM, only the data mart for the records in Fundraising is available.

This field displays the location of the source database relative to the application database.

This field displays the location of the report database relative to the application database.

For users with Blackbaud CRM, select whether to run configuration tasks after deployment. If you set this option to False, the deployment wizard will not populate the record source fields in the application.

Select whether to create SQL Server synonyms for database objects. If you set this option to False, the deployment wizard will not be able to communicate between different SQL Server instances.

For users with Blackbaud CRM, select whether to create a Report Services data source for the OLAP database.

Select whether to load catalog packages included with the data mart deployment files. If you set this option to False, the deployment wizard will not install the files to make fields in the data mart available in the application.

True if the deployment needs to change the caching options for very large dimensions and disable drillthroughs. This setting is needed if there will be dimensions with more than 10 million records.

Select whether to register ETL job information to allow you to start the ETL process in the application. If you set this option to False, you must start the ETL process from SQL Server.

Select whether to grant read rights to the SSIS packages. If you set this option to False, you must grant permissions to the SSIS packages manually for the ETL process.

Select whether to include the data mart on the Data Marts page in the application. From this page, you manage the ETL process. If you set this option to False, you must manage the ETL process from SQL Server.

Optional. The path to the extend folder containing extension to the warehouse, ETL process and the cube.

For users with Blackbaud CRM, enter the path to the command line utility for the deployment of the OLAP database.

Enter the location to store the data files for the report database. If you do not enter a path, the default is the SQL Server data folder.

For users with Blackbaud CRM, enter the location to store the log files for the report database. If you do not enter a path, the default is the SQL Server data folder.

For users with The Raiser’s Edge, if you use a local machine user account to communicate between the application and the data mart’s source, enter a list of the computers where you want to synchronize the account credentials.

For users with The Raiser’s Edge, if you use a local machine user account, select whether to reset the password to the value in the Trusted Account Password field.

This field indicates whether you use a local machine user account or a domain account.

Enter a password for the Microsoft Windows user account. The deployment wizard does not save this password. To redeploy the data mart, you must re-enter the password.

Enter a Microsoft Windows user account. If the account does not have rights to communicate between the application and the data mart’s source, the deployment wizard will grant the necessary rights. If you enter a local machine user account, the deployment wizard will create the account if it does not exist.

This field displays the environment variable for the SQL Server Integration Services package configuration. This is created on your computer to facilitate the ETL process.

Enter the location to deploy the SSIS package. By default, the deployment wizard uses the SQL Server instance to determine the location. However, if you use a clustered SQL Server environment, you can enter a Universal Naming Convention path or another path. If you do not enter a custom path, the program uses the default SQL Server path.

This field displays the path to the SSIS package configuration file that contains the SQL statements for the ETL process.