Venice connector/Requirements - Revision history

Bjorn.misseghers at 07:21, 22 September 2021

2021-09-22T07:21:14Z

Dirk.apers: /* System requirements */

2021-05-17T16:09:49Z

‎System requirements

Dirk.apers: /* Requirements in SQL Server */

2021-05-17T16:05:49Z

‎Requirements in SQL Server

Dino.dewaen at 13:31, 28 April 2020

2020-04-28T13:31:24Z

Bjorn.misseghers at 13:26, 28 April 2020

2020-04-28T13:26:12Z

Bjorn.misseghers at 12:47, 28 April 2020

2020-04-28T12:47:44Z

Bjorn.misseghers at 12:45, 28 April 2020

2020-04-28T12:45:35Z

Onea: Created page with "{{warning|You need to have an SQL Server running. If that is not the case, follow the Venice_connector/Requirements/SQL_Server_installation_instructions|SQL Server installat..."

2017-01-12T14:20:21Z

Created page with "{{warning|You need to have an SQL Server running. If that is not the case, follow the Venice_connector/Requirements/SQL_Server_installation_instructions|SQL Server installat..."

New page

{{warning|You need to have an SQL Server running. If that is not the case, follow the [[Venice_connector/Requirements/SQL_Server_installation_instructions|SQL Server installation instructions]].}}<br/>

==Requirements in SQL Server==
* Database VENICE_MONITOR with 3 tables:
** SVC_CABINET
** SVC_DOSSIER
** SVC_SYNCACTION

<br/>{{info|The scripts to create these tables are provided by Onea, please contact [mailto:support@onea.be us] if you haven't received them.}}<br/>

<div style="font-size: 120%;">'''SVC_CABINET'''</div>
This table is used to:
* store the locations of the cabinets to synchronize.
* store the URL and login info needed to upload/download data from VIS.
<br/>
Following columns are available:
* '''code''': contains the path to the cabinet. For example: "C:/Venice/Cabinets/cabinet.
* '''isActive''': indicates if the sync of the cabinet should be active or not. Possible values are:
** ''0'': not active
** ''1'': active
* '''instanceCode''': the name of the instance to which the cabinets belong.
* '''serviceAddress''': the address of the webservice. Default value: ''https://vis.onea.be/Onea/WS''
* '''serviceName''': the name of the webservice. Default value: ''ERPSync''
* '''username''': the username of the user that will be used for synchronization. '''This should be provided by Onea'''.
* '''password''': the password of the user that will be used for synchronization. '''This should be provided by Onea'''.
* '''scanProImageLink''': the prefix-URL of the direct link to a document. Default value: ''https://vis.onea.be/Onea/site/d/
* '''hasPriority''': if set to 1, this cabinet is synchronized first.
* '''prioritySorting''': influences the order in which the cabinets are synchronized.
* '''processing''': indicates that a cabinet is being processed at the moment.
<br/>
<div style="font-size: 120%;">'''SVC_DOSSIER'''</div>
This table is used to define which dossier(s) of which cabinets need to be synchronized with VIS.<br/>
<br/>
Following columns are available:
* '''dossier''': indicates which dossier of the cabinet needs to be synchronized. This is the name of the dossier folder. It is also possible to use a wildcard (*) to indicate that all dossiers of the cabinet should be synchronized.
* '''isActive''': indicates if the sync of the dossier should be active or not.
* '''cabinet_id''': the id of the entry in the SVC_CABINET table.
* '''processing''': indicates that a dossier is being processed at the moment.
* '''hasPriority''': if set to 1, the dossier is synchronized first.
* '''prioritySorting''': influences the order in which the dossiers are synchronized.
<br/>
<div style="font-size: 120%;">'''SVC_SYNCACTION'''</div>
This table is used to store all different elements synchronized. There is no need to create rows here, these will be automatically added by 1Archive.

@@ Line 7: / Line 7: @@
 * 10MB disk space for the installation of the service
 * System logging can take up several GB per month. Cleanup of these files is not foreseen
-* The service needs to run with a user that has sufficient privileges to access the venice folders and the connector folders.
+* The service needs to run with a windows user that has sufficient privileges to access the venice folders and the connector folders.
 ==Venice requirements==
@@ Line 14: / Line 14: @@
 ==Firewall settings==
-The Venice monitor communicates to the onea archive (typically http://vis.onea.be/Onea) via https. You will need to allow this traffic in order for the Venice monitor to work.
+* The Venice monitor communicates to the onea archive (typically http://vis.onea.be/Onea) via https. You will need to allow this traffic in order for the Venice monitor to work.
 ==Requirements in SQL Server==

@@ Line 2: / Line 2: @@
 ==System requirements==
 * Microsoft .Net framework version 4 or higher
 * 100 MB RAM
 * 10MB disk space for the installation of the service
 * System logging can take up several GB per month. Cleanup of these files is not foreseen
 * The service needs to run with a user that has sufficient privileges to access the venice folders and the connector folders.
 ==Venice requirements==

@@ Line 16: / Line 16: @@
 ==Requirements in SQL Server==
-* We need an sql server instance running and a user with read and write rights to the database defined below. SQL express 2012 or higher is perfect.
+* We need an sql server instance running and a user with read and write rights to the database defined below. SQL express 2016 or higher is perfect.
 * Database VENICE_MONITOR with 3 tables:

@@ Line 6: / Line 6: @@
 * 10MB disk space for the installation of the service
 * System logging can take up several GB per month. Cleanup of these files is not foreseen
 ==Venice requirements==
@@ Line 15: / Line 16: @@
 ==Requirements in SQL Server==
 * Database VENICE_MONITOR with 3 tables:
 ** SVC_CABINET

@@ Line 2: / Line 2: @@
 ==System requirements==
-* Microsoft .Net framework version 4
+* Microsoft .Net framework version 4 or higher
 * 100 MB RAM
 * 10MB disk space for the installation of the service

@@ Line 9: / Line 9: @@
 ==Venice requirements==
 * The Venice monitor connects to the Venice SDK using a Venice user. So you will need to provide a user license for this.
-* For further installation specifics you can check out [[Venice_connector/Installation|Installation]]
+* For further installation specifics you can check out the [[Venice_connector/Installation|Venice connector installation]]
 ==Firewall settings==

@@ Line 1: / Line 1: @@
 {{warning|You need to have an SQL Server running. If that is not the case, follow the [[Venice_connector/Requirements/SQL_Server_installation_instructions|SQL Server installation instructions]].}}<br/>
 ==Requirements in SQL Server==
@@ Line 28: / Line 41: @@
 * '''prioritySorting''': influences the order in which the cabinets are synchronized.
 * '''processing''': indicates that a cabinet is being processed at the moment.
 <br/>
 <div style="font-size: 120%;">'''SVC_DOSSIER'''</div>