CSV File Format

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

“action:instance-import”
“dbms-type:sqlserver”,“given-name:SQLTEST001”,“host:local.dbwtest1.com”,“port:1433”,“admuser:sa”,“admpassword:Password1”,“group:Test”,“engine:true”,“service:standard”

“dbms-type:sqlserver”,“given-name:SQLTEST002”,“host:local.dbwtest2.com”,“port:1433”,“admuser:sa”,“admpassword:Password2”,“group:Test”,“engine:true”,“service:standard”

“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:standard”

———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

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

Tag Description
dbms-type The database type (sqlserver, oracle, postgres, mysql, sybase)
given-name The display name for the instance.
host Host IP
port Port number
admuser 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 The password for the admin user
group The group to place the instance in. If ‘engine’ is set to true, the default values used during schema creation are from this group.
engine If a dbwatch schema should be created (true, false).
service The licensing level to set for this instance.

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 / Discovering Database Instances →

Feedback

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'?