Differences

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

Link to this comparison view

Both sides previous revision Previous revision
tutorial:adm:vema_cloud [2022/04/01 10:59]
stekld 		tutorial:adm:vema_cloud [2022/04/05 14:53] (current)
stekld
Line 17: Line 17:
 <code cmd> <code cmd>
 C:\Program Files (x86)\Vema\Vema.exe" /app=DBV HR PAM /server=your_id.cloud.vema.cz /username=your_username /world=your_ID C:\Program Files (x86)\Vema\Vema.exe" /app=DBV HR PAM /server=your_id.cloud.vema.cz /username=your_username /world=your_ID
 +
  
 </code> </code>
  
-      - Create a database user in MS-SQL database "Interchange" with permission to read&write to the database and schema. It needs to be a local user, domain authentication doesn't work within the scripts. +  - Create a database user in MS-SQL database "Interchange" with permission to read&write to the database and schema. It needs to be a local user, domain authentication doesn't work within the scripts. 
-      - Create the MS-SQL "Interchange" database structure. Using following script is recommended to get the default structure.+  - Create the MS-SQL "Interchange" database structure. Using following script is recommended to get the default structure.
  
 <code> <code>
Line 69: Line 70:
    ros INT PRIMARY KEY NOT NULL,    ros INT PRIMARY KEY NOT NULL,
    rost NCHAR(255)    rost NCHAR(255)
-) 
- 
-CREATE TABLE "dbo"."osobyx" 
-( 
-   oscis INT PRIMARY KEY NOT NULL, 
-   jmenozd NCHAR(250) DEFAULT (NULL), 
-   prijmzd NCHAR(250) DEFAULT (NULL), 
-   tituly NCHAR(250) DEFAULT (NULL), 
-   upljmeno NCHAR(250) DEFAULT (NULL), 
-   full_update_timestamp datetime DEFAULT (getdate()) NOT NULL, 
-   greatest_timestamp datetime DEFAULT (getdate()) NOT NULL, 
-   rocis NCHAR(15), 
-   cpoj NCHAR(15), 
-   ICL NCHAR(6), 
-   druhlp INT, 
-   datlp datetime, 
-   mistolp NCHAR(255), 
-   vysllp NCHAR(10), 
-   kopllp datetime, 
-   rosu INT 
 ); );
  
Line 158: Line 139:
 </code> </code>
  
-      - Install test scripts to a folder and change the log file path according to your environment. Default is ''C:\VemaV4\idmlogs\export_vymenik_log.txt'' +  - Install test scripts to a folder and change the log file path according to your environment. Default is ''C:\VemaV4\idmlogs\export_vymenik_log.txt'' 
-        - test3.py:+      - test3.py:
  
 <code python> <code python>
Line 188: Line 169:
  
 main = MyApp main = MyApp
 +
  
 </code> </code>
  
-        - test6.py:+  - test6.py:
  
 <code python> <code python>
Line 220: Line 202:
  
 main = MyApp main = MyApp
 +
  
 </code> </code>
  
-      - Run the test scripts+  - Run the test scripts
  
 <code cmd> <code cmd>
 C:\Program Files (x86)\Vema\Vema.exe" /app=pyscript test6.py /database=DB_NAME /server=cloud.vema.cz /world=your_ID /databasePER=DB_PER_NAME /serverPER=your_ID.cloud.vema.cz /application=pam /roleName="IDM export" /username=login C:\Program Files (x86)\Vema\Vema.exe" /app=pyscript test6.py /database=DB_NAME /server=cloud.vema.cz /world=your_ID /databasePER=DB_PER_NAME /serverPER=your_ID.cloud.vema.cz /application=pam /roleName="IDM export" /username=login
 +
  
 </code> </code>
Line 232: Line 216:
 <code cmd> <code cmd>
 C:\Program Files (x86)\Vema\Vema.exe" /app=pyscript test3.py /database=DB_NAME /server=cloud.vema.cz /world=your_ID /databasePER=DB_PER_NAME /serverPER=your_ID.cloud.vema.cz /application=pam /roleName="IDM export" /username=login C:\Program Files (x86)\Vema\Vema.exe" /app=pyscript test3.py /database=DB_NAME /server=cloud.vema.cz /world=your_ID /databasePER=DB_PER_NAME /serverPER=your_ID.cloud.vema.cz /application=pam /roleName="IDM export" /username=login
 +
  
 </code> </code>
  
-        - 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. + 
-        * 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". +  * 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. 
-        * **Expected results:** +  * 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". 
-          - No errors while running the scripts +  * **Expected results:** 
-          - test3.py: Writest a list of family names from VEMA's data file to the log file ''C:\\VemaV4\\idmlogs\\export_vymenik_log.txt'' +      - No errors while running the scripts 
-          - 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''+      - 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''
  
 ===== Local VEMA installation ===== ===== Local VEMA installation =====
  • by stekld