You can translate the question and the replies:

Is it possible to modify the VDBConfiguration.properties file (or any other config file) of the Denodo installation?

Hello, We have the useDecimal property set to "true" on all our servers, but every time a developer installs Denodo they have to remember to change this. Is it possible to change the default setting so that every new install gets the correct value for this? (If there is a more general way to change other files too, that would be helpful to know). Thank you!
denodo new installation
user
09-10-2014 16:23:40 -0400
code

4 Answers

Hi, you can create a VQL script to execute the VQL command SET. The SET command will update the value: SET 'com.denodo.vdb.catalog.type.Decimal.useDecimal' = 'true'; Following that approach you can change other parameters too. When doing an export of the VDP Server those commands are added after the line: # CONFIGURATION PROPERTIES Please let us know if this is a valid approach for your case
Denodo Team
09-10-2014 20:27:48 -0400
code
Are you suggesting that after Denodo is installed on a developer's machine, I can then have them run an import that contains all of our settings? I could see how this would work... it is an extra step, but it could be helpful. HOWEVER, it is my understanding that the useDecimal property has to be set in the vdp configuration AND the vdp-admin configuration... so, will the SET 'com.denodo.vdb.catalog.type.Decimal.useDecimal' = 'true'; command change the property in the following files: $DENODO_ADMIN/conf/vdp/VDBConfiguration.properties $DENODO_ADMIN/conf/vdp-admin/VDBAdminConfiguration.properties ? I think I need it to be changed in both places. Thanks~
user
10-10-2014 11:25:37 -0400
Hi, you are right, the SET command will only configure the property in the server file ($DENODO_ADMIN/conf/vdp/VDBConfiguration.properties). I think you will need to create a program/script to do a replace in your files once the installation is done. You can add the call to that program/script into your own install.sh / install.bat script in order to automate the process of: - Install the Denodo Platform - Install the latest Denodo Update - Call your custom code/script to modify your properties. One approach can be to have your custom properties file with the values you need and have that code replacing them in the Denodo properties file - Optional: call the import utility with an initial vql file with folders, datasources or server properties Do you think that will work? For your information, the property com.denodo.vdb.catalog.type.Decimal.useDecimal is "true" by default in Denodo 5.5
Denodo Team
10-10-2014 14:35:28 -0400
code
Thank you for the ideas. Your idea will work (I was actually hoping to avoid this, but alas). Also, since Denodo 5.5 has the useDecimal true by default, I think I'll just push to get everyone on to Denodo 5.5 instead of writing a custom script. Thank you!!!!
user
10-10-2014 16:23:35 -0400
You must sign in to add an answer. If you do not have an account, you can register here