Add multiple resources

As an administrator, you can add multiple resources to the Monitor by creating a comma separated values (CSV) file, and then importing the file.

 To add multiple resources to the Monitor

  1. Create a CSV file.

    Each line in the CSV file contains information about a single resource. Each comma-separated term within a line describes an attribute of the resource. The order of the terms is important. The following table describes the terms and their order:

    • CSV file format for SQL Anywhere database resources  

      Position in the line Term Description
      1 Resource type Type sa to Indicate that the resource is a SQL Anywhere database. This term is required.
      2 Resource name Specify the resource name that the database will have in the Monitor. This term is required.
      3 Username Specify the DBA user name used to connect to the database. This term is required.
      4 Password Specify the DBA password used to connect to the database. This term is required.
      5 Host (SQL Anywhere) Specify the hostname or IP address of the computer on which the database server is running. You can use the name localhost to represent the current computer. This term is required.
      6 Port (SQL Anywhere) Specify the port number on which the SQL Anywhere database server is running. The default port number for SQL Anywhere is 2638. This term is optional. The default value is 0
      7 Server (SQL Anywhere) Specify the name of the server that the database is connected to. This term is optional.
      8 Database (SQL Anywhere Specify the name of the database. This term is optional.
      9 Connection Parameters (SQL Anywhere) Specify additional connection parameters to use when connecting to the database. List the connection parameters as a semicolon delimited list of option=value pairs. The default value is "".This term is optional.
      The following is an example of an import file that contains two SQL Anywhere database resources. 
      sa,demo,DBA,sql,localhost,demo12,demo
sa,demo3,DBA,sql,localhost,49152,demo12,demo

  2. Log in as an administrator to the Monitor.

  3. Click Administration.

  4. Click Resources.

  5. Click Import.

  6. Locate the import file and click Open.

    The resources from the import file are added to the Monitor and monitoring starts.

  7. Click Close.

  8. Click Close.

  9. The imported resource is added to the Resource List in the Overview dashboard.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0