CSV File Format

You can add instances in bulk. The prerequisite is to have a CSV file with the following format:

"dbms-type:oracle","given-name:ORATEST001","host:local.dbwtest3.com","port:1521","sid:ORCL","admuser:sys as sysdba","admpassword:Password3","group:Test","engine:true","service:demo"


Let’s explain the tags more with the following table:

Tag Is mandatory Description
dbms-type yes The database type (sqlserver, oracle, postgres, mysql, sybase)
given-name yes The display name for the instance.
host yes Host IP
sid only on Oracle Specify Oracle SID
port yes Port number
admuser yes This user will be set as the properties user. If ‘engine’ is set to true, this user will be used to create the dbwatch schema
admpassword yes The password for the admin user
adm-auth-mode no What type of authentication is used, examples “adm-auth-mode:pwd” or “adm-auth-mode:kerberos”
adm-all-global no Sets management / administration user for all users with access to an instance to the admuser credentials. Default false, values true/false. Example “adm-all-global:true”
group yes The group to place the instance in. If ‘engine’ is set to true, the default values used during schema creation are from this group.
subgroup no The sub group to place the instance in.
engine yes If a dbwatch schema should be created (true, false).
engine-database no The name of the dbwatch database. Use if engine=true, and you want another database name than is specified in the group.
jobtemplate no Comma separated list of job templates.
jobtemplatemode no The job template mode (“keep others”, “disable others”, “uninstall others”).
service yes The licensing level to set for this instance. This can be a semicolon separated list of licenses to apply, lowercased. It is the same string as in the id in your license file. Examples: production_multiplatform, demo;production_sqlserver
jdbc-driver no It is possible to specify the jdbc driver to use, example: “jdbc-driver:driver:com.microsoft.sqlserver:mssql-jdbc:9.4.0.jre8@connector:no.dbwatch.connectors:sqlserver”

Uploading Instance File

Open ‘Server’->‘Upload resource’ menu.

A window will appear where you can upload resource files. Click on “Select Files” then choose the CSV file for bulk installation.
Afterwards, click on “Upload”.

After successfully uploading the Import.csv file.
You will see the 3(highlighted in yellow) additional instances that we’ve added.

← Adding a MySQL Instance / Groups Configuration →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment

Ole wrote: Jul 2, 2021

It should be "given-name", and the blank line is not necessary.

Alexander Veitschegger wrote: Jul 2, 2021

it isn't clear if given-name or given name is correct. Is the blank line between the entries a 'must'?