You can translate the question and the replies:

need to execute the Import.sh on a separate server

I would like to execute the "../bin/import.sh" script on server A to create a virtual database via a VQL script on server B. Here is the script I ran in server A (to run some action in server B) /app/denodo/denodo_6.0/bin/import.sh -su -f /app/denodo/applenv/entds/vql/create_vdb_EDO_Admin.vql -pf /app/denodo/applenv/scripts/config/default_property_file.properties -h serverB:9999/myvdb?appluser@apppasswd Is there a more better way to run this command from server A?
import vql shell
user
06-04-2017 12:47:08 -0400
code

3 Answers

Hi, You can also use the Graphical Interface. Follow these steps in the Virtual DataPort Admin Tool. 1. Click on the File option and select Import. 2. In the dialog box you can select the option "Import in multiple servers" By selecting this option you will be able to import the vql in multiple servers at the same time. Hope this helps.
Denodo Team
07-04-2017 09:58:39 -0400
code
We are trying not to use the VDP graphical tool, We will be migrating the changes from environment to environment by using a Change management tool (i.e. Serena Dimensions). Once the VQL and Properties are copied we run a Linux BASH shell script which calls the import.sh script provided by Denodo with the necessary parameters (vql and properties file locations, etc). The developers create the VQL via an Export (VQL, Properties files) from the VDP tool and then they submit the Change Control via the Dimensions tool --> which then runs the import.sh along with the VQL and Properties file. Thus I need to know how this can be done in Shell mode. In normal Production support and Change management scenarios in the Enterprise everything we always submit Configuration changes via a change management process. No manual effort should be used (using the VDP tool to Import changes).
user
07-04-2017 12:08:43 -0400
Hello, If you are looking to import in multiple servers you can use a syntax like below (You can also just run ./import.sh for syntax): *./import.sh -su -f export.vql -pf export.properties -h server1:9999/db1?user1@pwd -h server2:9999/db2?user2@pwd* You can also list your servers line by line in a conf file and use the switch *--servers-file* as in: *./import.sh -su -f export.vql -pf export.properties --servers-file servers.conf* If you want to use the scripts in another server then the import/export utilities are available as a standalone set of scripts in the location: *$DENODO_HOME/tools/db/denodo-db-tools.tar.gz * (Extract and refer to the README file for documentation) I hope this is what you are looking for.
Denodo Team
09-04-2017 19:50:53 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here