You can translate the question and the replies:

About Scheduler Administration Tool

two questions about denodo Scheduler tool: 1. does denodo Schedule tool can call shell script job or python script job 2. Does only the administrator of VDP has the access/write right for tool Scheduler Administration?
user
10-03-2020 05:07:22 -0400
code

3 Answers

Hi, **Q1.** Yes, you can execute shell scripts through Denodo Scheduler by using Denodo SSH Custom Wrapper which allows Virtual DataPort to use the secure shell protocol (SSH) to connect to a remote computer and execute an arbitrary command, which is then returned as the query result. Try the following steps in order to run your script file: 1. Download the Custom Wrapper named “Denodo SSH Custom Wrapper” from the support site under the Downloads tab -> DenodoConnects. 2. Extract the jar file and add it to your Virtual DataPort tool -> Jar Management 3. Create a custom data source using this jar file 4. Create base view filling the parameters (Host, Port, User, Password, Command) * Enter the command to execute your script file under the command option * Save the view and execute the same. 5. Last step is to create a job in Virtual DataPort scheduler to execute this base view. By following those actions, you are able to launch a job executing a script. **Q2.** No, other users can have access/write rights depending on the permissions that are given to them. Scheduler permissions are applied to a specific role, to delimit the tasks the users with that role can perform over data sources, filter sequences, jobs and the server configuration. Once a user is authenticated and his/her roles retrieved, Denodo Scheduler checks his/her permissions to decide whether he/she has the right privileges to perform an operation or not. When a user has several roles assigned, it can perform all the operations allowed by any of its roles. Scheduler supports the following types of permissions: Admin, Create, Write, and Read. You can read more about permissions of Scheduler Administration tool in the [Permissions document](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/administration/server_configuration/permissions) for Scheduler Server Configuration. Hope this helps!
Denodo Team
11-03-2020 06:59:35 -0400
code
Cou you please provide the guide line how to execute/schedule the python script execution from denodo.
user
22-04-2021 10:47:51 -0400
Hi, To execute shell scripts through Denodo Scheduler by using Denodo SSH Custom Wrapper, please refer to [Denodo SSH Custom Wrapper - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20SSH%20Custom%20Wrapper%20-%20User%20Manual). SSH Custom Wrapper allows Virtual DataPort to use the secure shell protocol (SSH) to connect to a remote computer and execute an arbitrary command, which is then returned as the query result. Hope this helps!
Denodo Team
11-05-2021 13:20:23 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here