AdminServers/Cases21

From UmsWiki
Jump to navigation Jump to search

SQL Server

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

Database

Database name.

Port number

The port number of the SQL server.

Username

SQL Username to access database.

Password

SQL Password to access database.

Use CSV Files

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

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

Export settings