Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
tutorial:adm:vema_cloud [2019/08/21 13:51]
kotynekv Add the common part
tutorial:adm:vema_cloud [2020/05/15 06:24]
kubicar [Systems - VEMA: Synchronization]
Line 2: Line 2:
  
 You may have VEMA installed locally or in the cloud. The basic principals of integration of VEMA and VEMA Cloud with CzechIdM are very similar or the same. In both cases we will use an external MS-SQL database "Interchange" to store the data from VEMA which will be read by CzechIdM. We will also need a server with the VEMA thick client installed. You may have VEMA installed locally or in the cloud. The basic principals of integration of VEMA and VEMA Cloud with CzechIdM are very similar or the same. In both cases we will use an external MS-SQL database "Interchange" to store the data from VEMA which will be read by CzechIdM. We will also need a server with the VEMA thick client installed.
 +VEMA PAM - work and payroll data 
 +VEMA PER - personel data
 ===== VEMA cloud ===== ===== VEMA cloud =====
   - Prepare the Windows server with VEMA thick client   - Prepare the Windows server with VEMA thick client
Line 194: Line 195:
       - the path to the ''Vema.exe'' might differ according to a certain installation       - the path to the ''Vema.exe'' might differ according to a certain installation
     - Check the results     - Check the results
- test3.py - tests the communication with VEMA. Note: You might need to change the name of data file you want to read from. The default is "osobyt" in database PAM. In other cases it might be "osobyx" in database PER. +      * test3.py - tests the communication with VEMA. Note: You might need to change the name of data file you want to read from. The default is "osobyt" in database PAM. In other cases it might be "osobyx" in database PER. 
- test6.py - tests ability to write into the "Interchange" database. Fill the following values (SERVER=...,DATABASE=...,UID=....,PWD=....), you might also need to change the table from "osobyt" to "osobyx"+      test6.py - tests ability to write into the "Interchange" database. Fill the following values (SERVER=...,DATABASE=...,UID=....,PWD=....), you might also need to change the table from "osobyt" to "osobyx"
- Expected results: +      * **Expected results:** 
- No errors while running the scripts +        No errors while running the scripts 
- test3.py: Writest a list of family names from VEMA's data file to the log file ''C:\\VemaV4\\idmlogs\\export_vymenik_log.txt'' +        test3.py: Writest a list of family names from VEMA's data file to the log file ''C:\\VemaV4\\idmlogs\\export_vymenik_log.txt'' 
- test6.py: Inserts a record into the table osobyt in the "Interchange" database. The record will have value of "oscis" 123 and a info message is written into the log file ''C:\\VemaV4\\idmlogs\\export_vymenik_log.txt''+        test6.py: Inserts a record into the table osobyt in the "Interchange" database. The record will have value of "oscis" 123 and a info message is written into the log file ''C:\\VemaV4\\idmlogs\\export_vymenik_log.txt''
  
 ===== Local VEMA installation ===== ===== Local VEMA installation =====
  • by stekld