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
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]].
 +