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 [2019/08/21 14:03]
kotynekv [VEMA cloud] formating
Line 194: Line 194:
       - 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]].
 +