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:41]
kotynekv Creating the tutorial 		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 =====
  
 BOTH local and cloud solutions pleas. TODO BOTH local and cloud solutions pleas. TODO
 +
 +===== Common part =====
 +
 +Then you need to implement a certain script which will read the data you want from VEMA and write them to the "Interchange" database. Also you might need to alter the tables according the data you read. Scripts above are just an examples.
 +
 +The script must be run automatically e.g. once a day.
 +
 +In IDM you will create a System with the Database Table Connector or Scripted SQL Connector according to the certain use-case. The first case is covered tutorials [[tutorial:adm:systems_db_contracts|Systems - DB: Users' contracts synchronization]] and [[tutorial:adm:connect_a_db_system|Systems - DB: Source of identities]].
 +
  • by stekld