Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry AtHoc
  3. BlackBerry AtHoc Integrations
  4. Digital Signage Installation and Configuration Guide
  5. Install and configure the plug-in on NDS
  6. Configure the NDS database

Configure the 
NDS
 database

Contact 
BlackBerry AtHoc
 support for the files required to configure the 
NDS
 database.
You will need the following information before you configure the 
NDS
 database:
  • The database server name.
  • The SA user password.
  • The name of the ngdelivery database.
  1. Place the 
    Database Configuration
     folder that you obtained from 
    AtHoc
     customer support in a folder on your local computer. This folder contains the 
    DigitalSignageConfiguration.bat
     and 
    DigitalSignageConfiguration.sql
     files.
  2. Right-click the 
    DigitalSignageConfiguration.bat
     file. Click 
    Edit
     and open the file in Notepad.
  3. Add the database server instance name, ngdelivery database server name, and the SA user password to the 
    DigitalSignageConfiguration.bat
     file as shown in the following example:
    @echo off
@echo Configuring the Digital Signage Plugin
rem update the database information in the below statement. Remove the <> from <value> and add the respective values.
for %%G in (*.sql) dosqlcmd -S <
    DatabaseServerInstanceName
    > -d <
    NGDeliveryDBName
    > -U sa -P "<
    SAUserPassword
    >" -i "&&G"
PAUSED
  4. Save and close the 
    DigitalSignageConfiguration.bat
     file.
  5. Open the 
    DigitalSignageConfiguration.sql
     file.
  6. Verify that the @deviceType value is 
    DigitalSignage
    .
    DECLARE @deviceType NVARCHAR(50)
SELECT @deviceType='
    DigitalSignage
    '
IF NOT EXISTS (SELECT * FROM NGDeliveryAccount.dbo.DatacenterSiteDetail
.
.
.
When you log in to the database server, there is a 
Digital Signage
 entry in the 
DeviceType
 column in the 
ngdeliveryaccount
 > 
DatacenterSiteDetail
 table and the ResourceType is 
RATE
.