Jump to: navigation, search

Difference between revisions of "HowTo:Set up UBIK"


(Session Management Type)
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
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.
 
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 [[Getting_Started#Introduction|introduction]], respectively.
+
The next sections cover the components required for the use cases as mentioned in the [[Getting_Started#Introduction|introduction]]. General information about the configuration files of each component can be found in [[Configuration_Files]].
  
 
== Setup for Data Model Administration ==
 
== Setup for Data Model Administration ==
 +
Creating and maintaining {{UBIK}} data models requires an according {{UBIK Database}} and the modelling tool {{UBIK Studio}} only.
 +
 
* {{UBIK Database}}
 
* {{UBIK Database}}
 
:''See [[HowTo:Install_UBIK_Database|Set up {{UBIK}} Database]] for help on configuration issues.''
 
:''See [[HowTo:Install_UBIK_Database|Set up {{UBIK}} Database]] for help on configuration issues.''
Line 9: Line 11:
 
:''See [[HowTo:Install_UBIK_Studio|How to install {{UBIK}} Studio]] for help on installation issues.''
 
:''See [[HowTo:Install_UBIK_Studio|How to install {{UBIK}} Studio]] for help on installation issues.''
  
=== Session Management Type ===
+
===Session Management Type===
 
Using [[USAM#Single_Local_Application|Single Local Application]] mode is sufficient to administrate the data model and to work with {{UBIK}} Studio only.
 
Using [[USAM#Single_Local_Application|Single Local Application]] mode is sufficient to administrate the data model and to work with {{UBIK}} Studio only.
:''See [[HowTo:Configure_Single_Local_Application_Authentication|this guide]] for help on configuration issues.''
+
:''See [[HowTo:Configure_Single_Local_Application_Authentication|Configure Single Local Application Authentication]] for help on configuration issues.''
  
 
Of course, it is also possible to use another authentication mode like [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]].
 
Of course, it is also possible to use another authentication mode like [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]].
 +
 +
[[Category:Installing|Set up UBIK]]
 +
[[Category:Server|Set up UBIK]]
  
 
== Setup for Working Mobile ==
 
== Setup for Working Mobile ==
 +
Working mobile presumes a valid data model within a {{UBIK Database}} created with {{UBIK Studio}}. Additionally the data needs to be published via a {{UBIK Web Service}} to an {{UBIK Client}}.
 +
 
* {{UBIK Database}}
 
* {{UBIK Database}}
 
:''See [[HowTo:Install_UBIK_Database|Set up {{UBIK}} Database]] for help on configuration issues.''
 
:''See [[HowTo:Install_UBIK_Database|Set up {{UBIK}} Database]] for help on configuration issues.''
Line 22: Line 29:
 
* {{UBIK Client}}
 
* {{UBIK Client}}
 
* {{UBIK Web Service}}
 
* {{UBIK Web Service}}
:''See [[HowTo:Configure_Microsoft_IIS_for_UBIK]] for help on configuration issues.''
+
:''See [[HowTo:Install_UBIK_Web_Service]] and [[HowTo:Configure_Microsoft_IIS_for_UBIK]] for help on configuration issues.''
  
 
=== Session Management Type ===
 
=== Session Management Type ===
 
For being able to use mobile clients it is mandatory to use [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]] as authentication mode.
 
For being able to use mobile clients it is mandatory to use [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]] as authentication mode.
:''See [[HowTo:Configure_LAS_Authentication|this guide]] for help on configuration issues.''
+
:''See [[HowTo:Configure_LAS_Authentication|Configure LAS Authentication]] for help on configuration issues.''
 +
 
 +
[[Category:Installing|Set up UBIK]]
 +
[[Category:Server|Set up UBIK]]
  
 
== Setup for Interfacing 3rd Party Systems ==
 
== Setup for Interfacing 3rd Party Systems ==
 +
Interfacing a 3rd party system presumes a valid data model within a {{UBIK Database}} created with {{UBIK Studio}}. The interfaces itself can be designed and tested manually using {{UBIK Studio}}. If automatisms are required you need to use {{UBIK Enterprise Service}}.
 +
 
* {{UBIK Database}}
 
* {{UBIK Database}}
 
:''See [[HowTo:Install_UBIK_Database|Set up {{UBIK}} Database]] for help on configuration issues.''
 
:''See [[HowTo:Install_UBIK_Database|Set up {{UBIK}} Database]] for help on configuration issues.''
Line 38: Line 50:
 
=== Session Management Type ===
 
=== Session Management Type ===
 
Using [[USAM#Single_Local_Application|Single Local Application]] mode is sufficient to administrate the data model and to interface 3rd pary systems.
 
Using [[USAM#Single_Local_Application|Single Local Application]] mode is sufficient to administrate the data model and to interface 3rd pary systems.
:''See [[HowTo:Configure_Single_Local_Application_Authentication|this guide]] for help on configuration issues.''
+
:''See [[HowTo:Configure_Single_Local_Application_Authentication|Configure Single Local Application Authentication]] for help on configuration issues.''
  
 
Of course, it is also possible to use another authentication mode like [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]].
 
Of course, it is also possible to use another authentication mode like [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]].
  
=== UBIK Database ===
+
== See also ==
Set up the database either by importing an export file of an existing database or by executing the
+
* [[Getting_Started]]
** [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 [http://www.microsoft.com/en-us/sqlserver/default.aspx 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.
+
 
+
[[File:UI_SettingUpUBIKDatabase_01.png|thumb|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]]
+
== Setting up {{UBIK}} database ==
+
# Start the ''Microsoft SQL Server Management Studio'' and connect to the database server
+
# Navigate to ''Databases'' and add a new database
+
# Choose ''Tasks → Restore → Database'' from the context menu
+
## Choose the newly created database in the setting ''In database''
+
## Choose the copied backup file in ''From media''
+
## Check ''Restore'' of the according backup set
+
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
+
# Finish the process by clicking {{key press|OK}}
+
 
+
{{Attention|Use 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 ===
+
[[Category:Installing|Set up UBIK]]
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.
+
[[Category:Server|Set up UBIK]]

Latest revision as of 08:50, 23 July 2015

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.

The next sections cover the components required for the use cases as mentioned in the introduction. General information about the configuration files of each component can be found in Configuration Files.

Setup for Data Model Administration

Creating and maintaining UBIK® data models requires an according UBIK® Database and the modelling tool UBIK® Studio only.

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 Configure Single Local Application Authentication for help on configuration issues.

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

Setup for Working Mobile

Working mobile presumes a valid data model within a UBIK® Database created with UBIK® Studio. Additionally the data needs to be published via a UBIK® Web Service to an UBIK® Client.

See Set up UBIK® Database for help on configuration issues.
See How to install UBIK® Studio for help on installation issues.
See Install UBIK Web Service and 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 Configure LAS Authentication for help on configuration issues.

Setup for Interfacing 3rd Party Systems

Interfacing a 3rd party system presumes a valid data model within a UBIK® Database created with UBIK® Studio. The interfaces itself can be designed and tested manually using UBIK® Studio. If automatisms are required you need to use UBIK® Enterprise Service.

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 Configure Single Local Application Authentication for help on configuration issues.

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

See also