Last modified on 22 July 2015, at 13:34

Set up UBIK

Revision as of 13:34, 22 July 2015 by KNO (Talk | contribs)

The initial setup of UBIK® and its components requires some extensive but straight forward steps. This guide gives an overview about the dependencies of the different components, whereas more detailed installation instructions can be found in separate linked articles, respectively.

A section covers the components required for the use cases as mentioned in the introduction, respectively.

Setup for Data Model Administration

See Set up UBIK® Database for help on configuration issues.
See How to install UBIK® Studio for help on installation issues.

Session Management Type

Using Single Local Application mode is sufficient to administrate the data model and to work with UBIK® Studio only.

See this guide for help on configuration issues.

Of course, it is also possible to use another authentication mode like Local Application Service.

Setup for Working Mobile

See Set up UBIK® Database for help on configuration issues.
See How to install UBIK® Studio for help on installation issues.
See Configure Microsoft IIS for UBIK for help on configuration issues.

Session Management Type

For being able to use mobile clients it is mandatory to use Local Application Service as authentication mode. See this guide for instructions how to set up this authentication mode.

Setup for Interfacing 3rd Party Systems

See Set up UBIK® Database for help on configuration issues.
See How to install UBIK® Studio for help on installation issues.
See How to install UBIK® Enterprise Service for help on installation issues.

Session Management Type

Using Single Local Application mode is sufficient to administrate the data model and to interface 3rd pary systems. See this guide for instructions how to set up this authentication mode.

Of course, it is also possible to use another authentication mode like Local Application Service.

UBIK Database

Set up the database either by importing an export file of an existing database or by executing the

    • [Create empty SQL DB + execute SQL script]
  • UBIK Studio
  • .NET Framework 4.0

• UBIK Application (Android, Windows)

• Use cases o UBIK Studio only: SL o Working with client (mobile, web): LAS + USAM

• Web service o Content  Configuration: endpoints, bindings vom Push o USAM o Optional: Push

      • Configuration: endpoints, bindings


All content and configuration data of UBIK® is managed in a Microsoft SQL database (2008 R2 or newer). Once the SQL server engines is installed successfully, an administrator can set up a new UBIK® database simple using the available release database.

Microsoft SQL Server Management Studio
Microsoft SQL Server Management Studio

Setting up UBIK® database

  1. Start the Microsoft SQL Server Management Studio and connect to the database server
  2. Navigate to Databases and add a new database
  3. Choose Tasks → Restore → Database from the context menu
    1. Choose the newly created database in the setting In database
    2. Choose the copied backup file in From media
    3. Check Restore of the according backup set
  4. Switch to the options-slider and check Overwriting actual data (if necessary)
  5. Finish the process by clicking OK
IC Attention.pngUse maintenance plans for periodic backup of your own and the system databases!

Requirements

Database user

The database user configured in UBIK® Studio used to connect to the database needs

  • to have the role sys.admin assigned
  • to be marked as Database owner (dbo) of the according UBIK® database

Windows firewall

For a non-local SQL server make sure that the SQL server port (default: 1433) is unlocked by the Windows firewall Inbound and Exbound rules.