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 tables describe the terms and their order:

    • CSV file format for MobiLink resources  

      Position in the line Term name Description
      1 Resource type

      Type ml to indicate that the resource is a MobiLink server.

      This term is required.
      2 Resource name Specify the resource name as it will appear in the Monitor. This term is required.
      3 Username Specify the username used to connect to the resource. This term is required.
      4 Password Specify the password used to connect to the resource. This term is required.
      5 Host (MobiLink server) Specify the hostname or IP address of the computer on which the server is running. You can use the name localhost to represent the current computer. This term is required.
      6 Port (MobiLink server) Specify the port number on which the MobiLink server is running. The default port number for MobiLink is 2439. This term is optional. The default value is 0
      7 Connection type (MobiLink server)

      Specify the method to use to connect to the resource: Type one of the following:

      • tcpip

        This is the default.

      • http

      • https

      • tls

      This term is optional.
      8 Encryption type (MobiLink server)

      Specify the method used to encrypt the connection. Type one of the following:

      • N   No encryption. This is the default.

      • E   ECC encryption

      • R   RSA encryption

      • F   RSA-FIPS encryption.

      This term is optional.
      9 Connection parameters (MobiLink server) Specify additional connection parameters to use when connecting to the database. List the connection parameters as a semicolon delimited list of option=value pairs. This term is optional.
      MobiLink servers:

      The following is an example of an import file that contains two MobiLink server resources.

      ml,demo2,DBA,sql,localhost
ml,demo4,DBA,sql,localhost,0,tcpip,N

    • CSV file format for MobiLink server farm resources  

      Position in the line Term name Description
      1 Resource type

      Type mf to indicate that the resource is a MobiLink server farm.

      This term is required.
      2 Resource name Specify the resource name as it will appear in the Monitor. This term is required.
      3 MobiLink server name

      Specify the MobiLink server resources that are to be included in the MobiLink server farm. List the MobiLink server resources as a comma delimited list. This term is required.

      MobiLink server farm:

      The following is an example of an import file that contains two MobiLink server resources and a MobiLink server farm resource.

      ml,demo2,DBA,sql,localhost
ml,demo4,DBA,sql,localhost,0,tcpip,N
mf,collection_demo,demo2,demo4

  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