SQL connectivity tasks

You do these tasks from the SQL Connectivity page.

  1. Edit an existing SQL connection.
    1. Select an SQL connection and click Edit.
    2. On the New window, update the field values and click OK.
    3. Verify that the new connection is listed under the Configured SQL locations.
  2. Remove an SQL connection.
    1. Select an SQL to disconnect and click Remove.
    2. Verify that the removed connection is no longer listed under the Configured SQL locations.
  3. Set a default connection.
    1. Select an SQL connection and click Make Default.

      Operations requiring an SQL connectivity will use this by default.

    2. Verify that the connection is now listed as the Default location.
  4. Copy an SQL connection.
    1. Select an SQL connection and click Copy.

      The selected SQL connection is copied.

    2. Verify that a new connection with "- Copy" appended to the name is listed under the Configured SQL locations.
  5. Copy to clipboard.

    This option copies the values of a connection to the system clipboard.

    Use this to paste the information into a mail, or similar, when you need to share information.

    Note: If Show Passwords As Clear is enabled on the Mapper preference page the connection password is also copied in clear text. Remember to delete the connection password from the email and others, if needed. If Show Passwords As Clear is disabled the string ****** is copied instead of the connection password.
  6. Test a connection.

    This option will only verify the connection to the SQL Server instance.

    Connection error message is displayed if the machine is unavailable or if a wrong ip/host address is defined.