What IT Wants to Know-Installation Overview Article

What IT Wants to Know-Installation Overview Article

System Overview


  • Dynamic Budgets is a 30Mb .Net connected client application
  • Typically the application is installed to a single share folder, and users launch the application from shortcuts placed on their desktops.
  • Alternatively many customers will use Citrix, Terminal Server, or TSPlus to run the application from a virtual desktop or as a remote published app.
  • The client communicates directly with SQL server (there is no middleware application server)
  • No data warehousing, GP financials are kept in GP and queried as needed, in real-time.
  • The budgeting database is typically installed on the same server as the GP company databases, but also supports SQL linked server for installation on a secondary SQL server

Requirements:

  • Client and installation utility require .Net 4.5
  • Database size expected to be about 150MB per budget round for an organization of less than 1,000 departments
  • Application supports Active Directory for Single Sign on like experience
  • Unlimited application users / does not require GP end user licensing
  • Dual authentication process, end user will login to the app, and the app will perform an authentication handshake with the SQL server, the application authentication with SQL server is typically set to a single service level account, but can optionally be set to individual SQL logins (windows or sql server authentication)

 

Installation Overview


SQL installation (5-10 mins)

  1. Run server configuration utility from the SQL server to create the DynamicBudgets database
  2. Create a service level account [dynbud] for the application authentication with SQL server
  3. Grant [dynbud] access to the databases
  4. db_datareader  (Dynamics and GP Company databases)
  5. db_owner (Dynamic Budgets)
  6. Grant db_datareader to (DynamicBudgets, and GP Company databases) for business owners (windows authentication SQL server logins) if they wish to work with refreshable excel reports

Client Application Placement (5 mins)

  1. Store DynamicBudgets-App folder from the network share folder, Citrix server or Terminal server
  2. Grant Read/Execute access to [DynamicBudgets-App]
  3. Grant  Read/Write access to [DynamicBudgets-App/SearchProfiles]

Application Configuration (60-90 mins)

  • Launch and configure client application
    • configure company(s) chart of accounts
    • Specify LDAP connection string
    • Create security access for trial users
    • Create test budget and/or forecasts
    • Link to GP financials
    • Deploy sample custom report templates
    • Test financial reporting and drill down to GP transaction details
      (note that multiple companies can be configured simultaneously, we do not need to work in serial)
    • Then schedule walk-through with the business owner.

Simple Backout Procedure (if necessary)

  1. Delete the DynamicBudgets-App folder from the network share folder, Citrix server or Terminal server
  2. Delete the SQL database [DynamicBudgets]
  3. Delete the SQL user [dynbud]
    • Related Articles

    • Table of Contents - Installation

      Software Installation Dynamic Budgets Application Install How to Obtain a Client’s License   How to Locate LDF & MDF File Paths (SSMS)   How to Create a New Dynamic Budgets Database   Software Upgrade   Client Configuration Manage Servers   Manage ...
    • Dynamic Budgets Application Install Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: To provide instruction on how to install Dynamic Budgets software. ​ Other Related Tutorials & Page Links: * Step by Step Tutorial-Launching Dynamic ...
    • How to Obtain a Client's License Tutorial

      PDF Tutorials  Interactive Tutorial Cropped Screenshots Full Page Screenshots           Purpose: Prior to installation, the client needs a license to use Dynamic Budgets software. Dynamic Budgets support will issue a license to the client. Then send ...
    • *Overview-Core Payroll Styles

      There are three styles of entering payroll data. All employees can be entered into 1 screen or multiple screens. All hourly/salary can be entered into hourly or salary screen.  Core Payroll ​Salary Screen  Record an employee  salary and benefits. ...
    • *Overview-Core Budgeting Styles

      There are three feature areas with the "Budgets" category: Core Budgeting Start from a budget dashboard tracking status information or a comparative financial statement format Directly entering monthly or annual budget values per G/L account Basic or ...