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] stekld |
<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> |
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 | |
); | ); |
| |
</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> |
| |
main = MyApp | main = MyApp |
| |
| |
</code> | </code> |
| |
- test6.py: | - test6.py: |
| |
<code python> | <code python> |
| |
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> |
<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 ===== |