You can translate the question and the replies:

Jenkins to denodo connect

Hi how can i connect to denodo from jenkins to run the export scripts under <Denodo_Home>/bin/export externally. Thanks in advance
Jenkins
user
08-10-2022 15:57:31 -0400
code

8 Answers

Hi, To run the export script in Denodo from Jenkins, I would do the following: * Create a new project in Jenkins. * Under the **Build Steps** dropdown select **Execute Windows** **batch command** for Windows Operating System or select **Execute shell** option for Linux Operating System. * Then execute the [**Export script**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/export_script) in the **Command** dialog by mentioning the home directory of the export script like below: `<DENODO_HOME>\bin\export.bat -l <login> -p <password> -h <host_name:port_number>/<database_name> -f <output_filename>` * Save the project and select Build to execute the project. Hope this helps!
Denodo Team
11-10-2022 06:14:39 -0400
code
Hi, Thanks for your response. Our setup is: Solution manager is one azure vm, VDP server in second azure vm. Jekins is available in the vm where solution manager exists. The script fails. Any suggestions to resolve the issue? Error: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information
user
12-10-2022 02:46:48 -0400
Hi, To execute the export script of the Virtual DataPort located in the remote server, I would write a **shell/batch script** to connect to Virtual DataPort and run the export script in the **Execute shell** or **Execute Windows Batch Command** of the **Build steps** in Jenkins. Alternatively, you can also use **sshPublisher** plugin in Jenkins to execute sshCommand or sshScript to execute command or shell script on a remote server. For more details, you could refer to the [**Publish Over SSH Plugin**](https://wiki.jenkins.io/display/JENKINS/Publish-Over-SSH-Plugin.html) Jenkins document. Regarding the above-mentioned error, I would make sure to check the following: * Make sure the hostname and port number are correct. * Check whether the Virtual DataPort is up and running. * Check whether there is no firewall restriction or network issue between the server and the client. Hope this helps!
Denodo Team
12-10-2022 07:08:32 -0400
code
The solution worked thanks a lot. Another doubt is if we can use the import script to invoke the DVCSPULL command? if yes, the how do we trigger it from jenkins for the same setup mentioned above
user
12-10-2022 08:54:42 -0400
Hi, To invoke the **DVCSPULL** using the import script command from Jenkins, I would follow the below steps: * Create a vql file using the DVCSPULL command like below in the Virtual DataPort: > DVCSPULL DBELEMENTS <database_name> ; * Use the below import script in Jenkins: > import.bat -f pull.vql -h <hostname>:<port>/<your_db>?username@password This way, you can invoke the DVCSPULL command using the import script from Jenkins. Hope this helps!
Denodo Team
14-10-2022 03:36:31 -0400
code
Hi, thanks for your response but we have this error: DVCSPULL only can be executed against the connected database" Note: 1. DB is available and VCS is confirgured for the DB Can you suggest whats the issue
user
14-10-2022 09:52:35 -0400
The idea is for a Jenkins call VDP to PULL from GIT to a db using DVCSPULL command/statement. db should pull the changes in GIT using DVCSPULL command when jenkins triggers the commad/statement.
user
14-10-2022 10:25:30 -0400
Hi, I can successfully execute the DVCSPULL command in Virtual DataPort Administration Tool by selecting the appropriate database in which Iwant to execute the DVCSPULL command from the dropdown menu in the VQL shell. If you still need help and if you are a user with valid support access then you can raise a support case in Denodo Support Site so that our support team can help you. Hope this helps!
Denodo Team
17-10-2022 03:13:51 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here