Spatial Manager Desktop™ - FAQs: Databases

From Spatial Manager Wiki
Revision as of 13:51, 26 February 2014 by Ignacio (talk | contribs)
Jump to navigation Jump to search

Introduction

  • Objective of this section
    • To load spatial information tables included in spatial databases
  • Topics in this section
    • Accessing spatial databases: UDSs definition using connection and setting parameters
    • Schemas and classes: structures of tables contained in databases
    • Other connections like ODBC, etc.


How can I load a data Table from a spatial database or data store into a Map in Spatial Manager Desktop™?

To access spatial databases or data stores you need first to have defined a User Data Source (UDS) including all the parameters to connect with (to learn more about UDSs, see: Data sources page)

You can load a data Table from a spatial database or data store using the right-click menu over the Table item itself inside a container of the UDS (usually a Schema), in the "Data sources" panel, to load its content into a new or existing Map. You can also double-click over the Table item itself, in the "Data sources" panel, to load its content into a new or existing Map (this behaviour may be configured in the application settings)


DB-1.png


Files-3.png


Are there any other functions for the Tables in Spatial Manager Desktop™?

Yes, you can Delete or Rename the Tables in Spatial Manager Desktop™ using the right-click menu over the Table item itself


DB-2.png


How can I create a Schema in a database in Spatial Manager Desktop™?

You can create a Schema in a database in Spatial Manager Desktop™ using the right-click menu over the UDS. When creating, you can assign a name to the New Schema


DB-3.png


Are there any other functions for the Schemas in Spatial Manager Desktop™?

Yes, you can Delete or Rename the Schemas and Refresh the Schema contents in Spatial Manager Desktop™ using the right-click menu over the Schema item itself. Be careful when you Delete a Schema because all the Tables that it contains will also be deleted


DB-4.png


Related links