From UmsWiki
Jump to: navigation, search
AdminServer Cases21.jpg

SQL Server

DNS or IP address of the Microsoft SQL server where the database is stored.


Database name.

Port number

The port number of the SQL server.


SQL Username to access database.


SQL Password to access database.

Use CSV Files

Activate this to use CSV files instead of ODBC connection to the Cases21 database

AdminServer Cases21 CSV.jpg

File path

The Windows UNC path to where the files are located.

SQL Export

This shows the SQL Sentences needed to generate the files for import into UMS

AdminServer Cases21 CSV Info.jpg

Export settings