AdminServers/MicrosoftNavision: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Created page with "none|thumb|656x656px ====SQL Server==== DNS or IP address of the Microsoft SQL server where the Scyllabus database is stored. ====Database..."
 
Kia (talk | contribs)
No edit summary
 
Line 1: Line 1:
[[File:AdminServer Scyllabus.jpg|none|thumb|656x656px]]
[[File:AdminServer MicrosoftNavision.jpg|none|thumb|656x656px]]


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


====Database====
====Database====
Scyllabus database name.
Database name.


====Port number====
====Port number====
Line 15: Line 15:
====Password====
====Password====
SQL Password to access database.
SQL Password to access database.
==== Prefix tablenames ====
The tables in Navision is prefixed with a customer name. Enter this prefix here.
==== Field to use as activity ====
Choose with field in Navision where the string for activities in entered.


===[[AdminServers/Export Settings|Export settings]]===
===[[AdminServers/Export Settings|Export settings]]===

Latest revision as of 08:56, 14 April 2020

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.

Prefix tablenames

The tables in Navision is prefixed with a customer name. Enter this prefix here.

Field to use as activity

Choose with field in Navision where the string for activities in entered.

Export settings