Business Table Management
Feature Description
Business Table Management supports adding tables created in the database to the database datasource. Business tables are added as attribute tables, commonly used for SQL queries with associated attribute tables, creating thematic maps with associated attribute tables, and appending datasets.
- 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 business tables added are read-only attribute tables and do not support editing operations such as adding or deleting fields, or updating attribute values.
Steps
- Click the Database drop-down button in the Datasource group of the Start tab, and select Business Table Management. Or in Workspace Manager, right-click Database Datasource and select the Business Table Management.
- 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.
- After loading the business table, the business table dataset will be generated under the database datasource, which can be used in operations such as SQL Query and columns append.
Caution: - The Business Table Management function is available only when the selected datasource is database type.
- If there are no business tables created in the data engine in the opened database datasource, there are no business tables to select from the Business Table Management dialog.
- For certain business tables that contain field names consisting of pure numbers, or tables with field types that are unique to the database but cannot be recognized in the system (such as Ntext, Real, Money types in SQL databases), these tables can be loaded into the datasource. However, when opening such business tables, an error may occur stating "Failed to open attribute table, the dataset may be corrupted." Therefore, it is recommended to check the availability of the database tables in the datasource before loading business tables.
- After removing business tables, 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 Datasource.
Related Topics