Deploying Dundas BI instances silently

Contents[Hide]

1. Overview

This article will explain how to silently deploy Dundas BI instances. You will learn the following:

  • How to use the Deployment Console application
  • Get Deployment Console application instructions
  • How to export the deployment actions xml files
  • How to pass deployment actions to the Deployment Console application

2. Deployment Console application

The deployment console is an application that can be used to manage Dundas BI instances from the console. The DeploymentConsole.exe file is located in the Dundas BI Deployment application installation directory. By default this location is at:

C:\Program Files (x86)\Dundas Data Visualization Inc\Dundas BI\Setup\{major}.{minor}\DeploymentConsole.exe

Where {major}.{minor} represents the version of the Dundas BI Deployment application.

Important
The DeploymentConsole.exe must be run as an x64 process.

3. Get the Deployment Console application instructions

To get all the commands that can be used in the deployment console execute the following command from the console:

C:\Program Files (x86)\Dundas Data Visualization Inc\Dundas BI\Setup\{major}.{minor}\DeploymentConsole.exe /?

The Deployment Console application instructions.
The Deployment Console application instructions.

4. How to export the deployment actions xml files

Deployment Action xml files are used to do various actions (Add, Remove, and Upgrade) for Dundas BI instances. The following will create example action files in the C:\temp\exports folder:

C:\Program Files (x86)\Dundas Data Visualization Inc\Dundas BI\Setup\{major}.{minor}\DeploymentConsole.exe /exportdeploymentactions "C:\temp\exports"

The Deployment Console create export files.
The Deployment Console create export files.

5. How to pass deployment actions to the Deployment Console application

The syntax for passing a deployment action to the deployment console is:

C:\Program Files (x86)\Dundas Data Visualization Inc\Dundas BI\Setup\{major}.{minor}\DeploymentConsole.exe /action {filepath}

5.1. Deploying an Instance

The following are the contents of an example deployment action file for adding an instance of Dundas BI to a machine:

<?xml version="1.0" encoding="utf-16"?>
<AddInstanceToServer xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Admin>
    <AdminUsername>admin</AdminUsername>
    <AdminPassword>1234</AdminPassword>
    <AdminEmailAddress>q@q.ca</AdminEmailAddress>
  </Admin>
  <Web>
    <WebApplicationPath>IIS://localhost/W3SVC/5119123/</WebApplicationPath>
    <ApplicationPoolName>TestApplicationPoolefhnp7kqbbtrxmya1yq16xfg3y</ApplicationPoolName>
    <ApplicationPoolIdentity>
      <IdentityType>NetworkService</IdentityType>
    </ApplicationPoolIdentity>
    <WebApplicationName>BIWebsite</WebApplicationName>
    <WebsiteBinding>
      <BindingType>Http</BindingType>
      <Port>8000</Port>
    </WebsiteBinding>
  </Web>
  <Database>
    <ApplicationDatabaseConnectionString>Data Source=.;Initial Catalog=DundasBI;Integrated Security=True</ApplicationDatabaseConnectionString>
    <WarehouseDatabaseConnectionString>Data Source=.;Initial Catalog=DundasBI_Warehouse;Integrated Security=True</WarehouseDatabaseConnectionString>
    <DatabaseOption>CreateNewDatabases</DatabaseOption>
  </Database>
  <Instance>
    <InstanceDirectory>C:\Program Files\Dundas Data Visualization Inc\Dundas BI\Instances\Instance1</InstanceDirectory>
    <InstanceName>Instance1</InstanceName>
    <InstanceDescription>Instance for Testing Dundas BI</InstanceDescription>
  </Instance>
  <Service>
    <ServiceName>BI_efhnp7kqbbtrxmya1yq16xfg3y</ServiceName>
    <ServiceIdentity>
      <IdentityType>NetworkService</IdentityType>
    </ServiceIdentity>
  </Service>
  <BackupExistingDatabases>false</BackupExistingDatabases>
</AddInstanceToServer>

The Deployment Console installing an instance
The Deployment Console installing an instance

5.2. Removing an Instance

The following are the contents of an example deployment action file for removing an instance of Dundas BI from a machine:

<?xml version="1.0" encoding="utf-16"?>
<RemovingInstance>
  <!-- The instance name to remove. -->
  <InstanceName>Instance1</InstanceName>
  <!-- Gets or sets a value indicating whether to delete the instance directory. -->
  <DeleteInstanceDirectory>true</DeleteInstanceDirectory>
  <!-- Gets or sets a value indicating whether to ignore IIS items that can't load. -->
  <IgnoreIisItemsThatAreUnableToLoad>true</IgnoreIisItemsThatAreUnableToLoad>
  <!-- Gets or sets a value indicating whether to remove application databases. -->
  <RemoveApplicationDatabases>true</RemoveApplicationDatabases>
</RemovingInstance>

The Deployment Console removing an instance
The Deployment Console removing an instance

5.3. Upgrading an Instance

The following are the contents of an example deployment action file for upgrading an instance of Dundas BI on a machine:

<?xml version="1.0" encoding="utf-16"?>
<UpgradeInstance xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <!-- The instance name to upgrade. -->
   <InstanceName>Instance1</InstanceName>
   <!-- The application database connection string to use instead of the one already in the instance connection config. -->
   <!-- Optional -->
   <ApplicationDatabaseConnectionString>Data Source=.;Initial Catalog=DundasBI;Integrated Security=True</ApplicationDatabaseConnectionString>
   <!-- Optional -->
   <!-- The warehouse database connection string to use instead of the one already in the instance connection config. -->
   <WarehouseDatabaseConnectionString>Data Source=.;Initial Catalog=DundasBI_Warehouse;Integrated Security=True</WarehouseDatabaseConnectionString>
   <!-- Backup databases during upgrade. -->
   <BackupDatabases>true</BackupDatabases>
</UpgradeInstance>

The Deployment Console upgrading an instance
The Deployment Console upgrading an instance

5.4. Installing Prerequisites

The following are the contents of an example deployment action file that checks and then installs prerequisites (if needed) for Dundas BI on a machine:

<?xml version="1.0" encoding="utf-16"?>
<FixPrerequisites xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <!-- Possible Values (DeployInstance,SharePoint,RemoveSharePoint) -->
  <!-- The type of fix. -->
  <TypeOfFix>DeployInstance</TypeOfFix>

</FixPrerequisites>

Example syntax for performing this action:

C:\Program Files (x86)\Dundas Data Visualization Inc\Dundas BI\Setup\2.6>DeploymentConsole.exe /action "C:\temp\fixPrereqs.xml"

6. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri