Version:

Edit Advanced Data Mart Settings Screen

Edit Advanced Data Warehouse Settings Screen

On the Edit Advanced Data Mart Settings screen, you can edit the settings from the deployment wizard and also edit additional advanced settings. All the settings that appear in the deployment wizard are also included on this screen alongside additional advanced settings. Some of the settings on this screen are for informational purposes only. You can use the screen to view those settings, but you cannot edit them.

On the Edit Advanced Data Warehouse Settings screen, you can edit the settings from the deployment wizard and also edit additional advanced settings. All the settings that appear in the deployment wizard are also included on this screen alongside additional advanced settings. Some of the settings on this screen are for informational purposes only. You can use the screen to view those settings, but you cannot edit them.

Application web service

The settings in this section relate to the application's web service. The first two settings correspond to the fields on the deployment wizard's Web Service tab.

Screen Item

Description

Application root url

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].”

Application web service database key

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

Hosted SiteInfoID

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

Validate application root url

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

Web Service Password

Enter the password for the Web Service User.

Web Service User Name

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

Database connection: Application

The settings in this section relate to the application's database. These settings correspond to the fields on the deployment wizard's Application Database tab.

Screen Item

Description

(Application SQL Server instance)

Enter the SQL Server instance for the application database.

Application database

Enter the name of the application database.

Database connection: OLTP System

The settings in this section relate to the application's database. These settings correspond to the fields on the deployment wizard's OLTP Database tab.

Note: These settings only appear when you select you "Blackbaud Data Mart for the Raiser's Edge" in the Data warehouse field on the deployment wizard's Data Warehouse tab.

Screen Item

Description

OLTP SQL Server database

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

OLTP SQL Server instance

For users with The Raiser’s Edge, enter the SQL Server instance for the source database.

Database connection: OLAP Reporting Database

The settings in this section relate to the database for the OLAP cube. These settings correspond to the OLAP Server and OLAP Database fields on the deployment wizard's Report Database tab.

Note: These settings only appear when you select you "BBDW" in the Data warehouse field on the deployment wizard's Data Warehouse tab.

Screen Item

Description

Analysis Services database

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

Analysis Services instance

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

Database connection: Relational Reporting Database

The settings in this section relate to the database for the data warehouse. These settings correspond to the SQL Server and Database fields on the deployment wizard's Report Database tab.

Note: These settings only appear when you select you "BBDW" in the Data warehouse field on the deployment wizard's Data Warehouse tab.

Screen Item

Description

Report mart database

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

Report mart SQL Server instance

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

Deployment file

The settings in this section relate to installation settings for the data warehouse. The second setting corresponds to Manifest file field on the deployment wizard's Data Warehouse tab, while the values for the other four settings are determined by your selection in the Data warehouse field on the Data Warehouse tab.

Screen Item

Description

Mart key

The data warehouse uses the same database as the application, and the data warehouse key distinguishes data warehouse 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.

Mart manifest file

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

Mart name

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

OLTP Database Location

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

Report Database Location

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

Deployment Options

The settings in this section relate to deployment settings for the data warehouse.

Screen Item

Description

Configure data warehouse after deployment

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.

Create Database Synonyms

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.

Create Report Services OLAP Data Source

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

Deploy catalog items

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

Deploy Large UDM Dimensions

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.

Deploy OLAP cube

Select whether to create the OLAP cube on the specified Analysis Services instance. If you don't plan to use the cube, you can set the property to "False" to improve the performance of the ETL process and remove the need for Analysis Server.

Enable ETL job start from shell

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.

Grant file and folder rights for SQLAgent SSIS job

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.

Include Selections

Select whether to synchronize static selections with the data warehouse for use in queries.

Max ETL Parallelism

Enter the maximum number of SSIS packages to run in parallel.

Register data warehouse in application

Select whether to include the data warehouse 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.

Extensibility

The setting in this section relates to extensions to the warehouse.

Screen Item

Description

OLAP Extensions Path

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

OLAP deployment

The setting in this section relates to deployment settings for the OLAP cube.

Note: These settings only appear when you select you "BBDW" in the Data warehouse field on the deployment wizard's Data Warehouse tab.

Screen Item

Description

Analysis Services deployment utility

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

Report database paths

The settings in this section relate to optional settings for the report database.

Screen Item

Description

Report database data path

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.

Report database log path

For users with Blackbaud CRM only, 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.

Security

The settings in this section relate to the account credentials to use for the ETL process. The settings in this section correspond to the fields on the deployment wizard's User Account tab.

Screen Item

Description

Local account Machine list

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

Reset Trusted Account Password

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.

Trusted Account Is Local User

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

Trusted Account Password

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

Trusted Account User Name

Enter a Microsoft Windows user account. If the account does not have rights to communicate between the application and the data warehouse’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.

SSIS

The settings in this section relate to SQL Server Integration Services.

Screen Item

Description

SSIS configuration file environment variable

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.

SSIS package root folder

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.

SSIS package subfolder

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

SSIS SQL Agent Job Name

This field displays the SQL Agent job that the deployment wizard creates to run the ETL process.