Installing the database product

Previous Next

A USoft environment must run on a relational database. USoft supports design-time development and runtime application use on the following databases:

PostgreSQL (Beta)

Oracle

ODBC

SQL Server

JDBC (Derby)

In the environment, make a central database server available to users. If a file system network is used, ensure database connectivity so that all development machines can connect to the development repository. Make sure that all future development team members have access to the appropriate network or development machine(s) at operating system level.

In the development environment, USoft recommends that you create a separate database user (database account) for each development team member.

In the production environment, a range of multi-user authentication options is possible. The optimal configuration depends on the nature of the software you are delivering. For example:

Use of public web services and REST services may be anonymous or may require password or biometric authentication handled by the USoft application.

A typical setup for USoft web applications is to have a funnel account on the database, and let the USoft layer handle authentication, possibly with the help of Active Directory.

For USoft client/server applications in production, you have the option to let the RDMBS or USoft handle authentication. See the USoft Authorizer and USoft Web Designer help for details.

 

Next step

Installing USoft product components