Business Table Management

Add the tables created in the database to the Database-type Datasource. Business tables are added in the form of attribute tables, which are often used in Join Attribute tables for SQL Query, Create Thematic Map of Join Attribute tables, Dataset appending, and other operations.

  • The Pre-condition for using this function is: there is a business table created in the Database-type Datasource, that is, a non-system table.
  • This feature is available in addition to Oracle Spatial Supported All Data Library engine types.
  • Add to in is a read-only attribute table, and editing operations such as adding, Delete Field, and updating attribute values are not supported.

The specific operation steps are as follows:

  1. Click the Database Drop-down Button in the Datasource group of the Start tab, and select the Business Table Management item. Or in Workspace Manager, right-click Database-type Datasource and select the Business Table Management item.
  2. The pop-up Business Table Management dialog box displays all the business tables in the Datasource. Check the business table to be loaded and click OK. Note: The Loaded business table in the dialog box is checked. If you want to delete it, uncheck the table and click the OK button.
  3. After the business table is loaded, the business table Dataset will be generated under the Database-type Datasource, which can be used in operations such as SQL Query and append column.
Caution:
  • The Business Table Management function is available only when the selected Datasource is Database.
  • If there are no business tables created in the data engine in the opened Database-type Datasource, there are no business tables to select from the Business Table Management dialog.
  • For some business tables that contain field names that are purely numeric, or that are unique to the database but SQL database can be loaded into Datasource, but when such business tables are opened, a report of Open attribute table failure will be made. Error for Dataset may be corrupted. Therefore, it is recommended to check the in.
    • After the business table is
  • removed, the table in the DataBase will not be deleted, but the information and reference of the business table Dataset in the Datasource will be removed.
    • When performing SQL Query or Create Thematic Map on the
  • associated business table, only the business table and the current table can be stored in the same Database-type Datasource.

Related topics

Manage Data source

View the Datasource properties