Feature Description
Supports opening file datasource, database datasource, and Web-type datasource. For the characteristics and applicable scenarios of each type of datasource, please refer to the Datasource Overview.
Function Entrance
- File tab->Open button->Select datasource type.
- Start tab->Datasource group->Select File, Database, or Web to open different types of datasources.
- Workspace Manager panel->Datasource node context menu->Select the datasource type to open.
Operation Steps
Open File Datasource
- Execute Open File Database by any of the above methods, and the corresponding Dialog Box will pop up.
- In the Open File Datasource dialog box, select the file database file to open. Supports opening *.udb or *.udbx files, and also supports opening external image files and vector files, including local files and files on Cloud Storage.
- Spatial Data Engine Type: Includes UDBX(*.udbx), UDB(*.udb).
Note:Editing UDBX files across operating systems is not supported; only reading is allowed. For example, a UDBX file stored in a shared folder on a Windows system can only be read when accessed from a Linux system; editing is not allowed.
- Image File Type: Includes *.sit, *.bmp, *.jpg, *.jpeg, *.png, *.tif, *.tiff, *.img, *.sci, *.gif, *.ecw, *.sid, *.bil, *.jp2, *.j2k, *.tpk formats.
- Vector File Type: Includes *.shp, *.mif, *.tab, *.dwg, *.dxf, *.dgn, *.kml, *.kmz, *.wal, *.wan, *.wap, *.wat, *.csv, *.dbf, *.000, *.vct, *.json, *.geojson, *.meta, *.gpkg, *.mdb, *.e00, *.gdb formats, where *.gdb belongs to the folder-type vector file.
Tip:When opening an external file directly into the workspace, a datasource with the same name as the file will be added to the workspace, and the file will become a dataset within that datasource.
- Spatial Data Engine Type: Includes UDBX(*.udbx), UDB(*.udb).
Open File Geodatabase
The currently supported folder-type datasource type: File GDB file (*.gdb).
1. You can choose any of the following methods to open a file geodatabase:
- In the Workspace Manager, on the Datasource node context menu->Open File Geodatabase
- Drag and drop the File GDB folder directly into the Workspace Manager
- In Catalog Manager->Recently Used, double-click to open the File GDB folder
2. In the pop-up Select dialog box, choose the File GDB folder you need to open.
- Supports selecting multiple File GDB folders to open simultaneously.
3. Enter the Open: [File GDB File] dialog box
- Use the toolbar buttons to manage the FileGDB list:
- Add: Add a new File GDB folder.
- Remove: Remove the selected File GDB folder.
- Select All: Select all File GDB folders.
- Invert Selection: Reverse the current selection status.
- Set opening parameters:
- Import as 3D Data: Specifies whether to open feature classes containing Z-values within the FileGDB as 3D datasets.
- Selected - Open feature classes containing Z-values as 3D datasets. This is the default.
- Not Selected - Open feature classes containing Z-values as 2D datasets.
- Read-only: Specifies whether to open in read-only mode.
- Selected - Allows viewing of the file but no editing.
- Not Selected - Supports operations such as geometric feature editing and attribute editing on datasets within this datasource. This is the default.
- Import as 3D Data: Specifies whether to open feature classes containing Z-values within the FileGDB as 3D datasets.
4. Click OK to complete the opening operation.
Open Database Datasource
Currently supports opening various database datasources including SQLPlus, Oracle Plus, Oracle Spatial, PostgreSQL, PostGIS, Yukon, MySQL, POLARDBGanos, GaussDB 200, DMPlus, ES, and others.
- Execute Open Database Datasource by any of the above methods, and the corresponding dialog box will pop up.
- In the Open Database Datasource dialog box, you can switch the database type in the left list, and enter the necessary information for the datasource to open on the right. The parameters vary for different database types. The following table introduces the parameters that need to be set and precautions for opening different types of database datasources:
Note:The application automatically saves the addresses of connected databases. Users can select from history for quick login during subsequent sessions.
| No. | Database Type | Instance Name | Server Address | Database Name | Username/Password | Schema | Max Connection Pool | Driver | Supported Versions | Precautions |
| 1 | SQLPlus | × | √ | √ | √ | × | × | √ | 2000/2005/2008/2012/2017 | A client must be installed, and environment variables must be configured correctly. |
| 2 | OraclePlus | √ | × | √ | √ | × | √ | × | Version 9i and above | A client must be installed, and environment variables must be configured correctly. There are two ways to connect to the server: first, configure the client to ensure it can connect to the service through the instance; second, connect via the easy connect naming method, where the instance name format is host[:port][/service_name]. |
| 3 | OracleSpatial | √ | × | √ | √ | × | √ | × | Version 9i and above | A client must be installed, and environment variables must be configured correctly. There are two ways to connect to the server: first, configure the client to ensure it can connect to the service through the instance; second, connect via the easy connect naming method, where the instance name format is host[:port][/service_name]. |
| 4 | PostgreSQL | × | √ | √ | √ | × | √ | × | Version 9.1 and above | The remote server must ensure this machine has access permissions. If lacking permission, modify the /data/pg_hba.conf file on the server's data save path by adding 'host all all 0.0.0.0/0 trust', then restart the service. |
| 5 | PostGIS | × | √ | √ | √ | √ | √ | × | 3.1/3.2/3.3 | PostGIS engine type, the spatial data extension for PostgreSQL. For PostGIS datasources, no client installation is required. The remote server must ensure this machine has access permissions. When opening a PostGIS datasource, if the sm system tables are missing, some features may not function properly. Data can be repaired using the Repair Datasource tool. The PostGIS engine supports accessing various domestic databases such as Cetc KingBase, Vastbase, SHENTONG, HighGoDB, Transwarp Graph Database, UXDB, and Huawei GaussDB 200. Among them, Cetc KingBase, SHENTONG, and HighGoDB also provide separate engine types with the same functional scope as the PostGIS engine. |
| 6 | HighGoDB | × | √ | √ | √ | √ | × | × | 6.0 | Unified type with PostGIS. |
| 7 | KingBase | × | √ | √ | √ | √ | × | × | Version 7.1.1 and above | Unified type with PostGIS. |
| 8 | Yukon | × | √ | √ | √ | × | √ | × | Yukon 1.0 and above; Yukon for PostgreSQL: PostgreSQL 9.1 and above; Yukon for openGauss: openGauss 2.1/3.1/5.0; Yukon for GaussDB: GaussDB 503.1/505.0/505.1; |
When the database kernel is openGauss or GaussDB, environment variable configuration must be correct. |
| 9 | MySQL | × | √ | √ | √ | × | × | × | Version 5.6 and above | The remote server must ensure this machine has access permissions. If lacking permission, refer to the statement: grant all privileges on *.* to user@'%' identified by pwd; flush privileges, where % can be replaced with a specific IP. |
| 10 | POLARDBGanos | × | √ | √ | √ | √ | √ | × | Version 1.2.1 | |
| 11 | GaussDB 200 | × | √ | √ | √ | × | √ | × | The remote server must ensure this machine has access permissions. | |
| 12 | DMPlus | × | √ | √ | √ | × | × | × | Version 7.1.4 and above | To successfully connect to the DM database, you need to obtain a complete client dependency file package (usually containing key dynamic link libraries like dmoci.dll) from the DM database vendor. Configure the client dependency files to the system environment variables, and you can then open the DM database datasource normally. |
| 13 | DMSpatial (beta) | × | √ | √ | √ | × | × | × | Version 8.1.3 and above | To successfully connect to the DMSpatial database, you need to obtain a complete client dependency file package (usually containing key dynamic link libraries like dmoci.dll) from the DMSpatial database vendor. Configure the client dependency files to the system environment variables, and you can then open the DMSpatial database datasource normally. Supported dataset types include: Tabular, Point, Line, Region, Text, CAD, Mosaic Dataset. |
| 14 | ES | × | √ | √ | × | × | × | × | 6.8.0 | Elasticsearch is a popular enterprise-level search engine. A locally accessible Elasticsearch server is sufficient. |
| 15 | SHENTONG | × | √ | √ | √ | √ | × | × | 7.0 | Same type as PostGIS. |
| 16 | Vastbase | × | √ | √ | √ | √ | √ | × | Same type as PostGIS. | |
| 17 | ArcSDE for Oracle | × | √ | √ | √ | × | √ | × | ||
| 18 | XUGU DB (beta) | × | √ | √ | √ | × | × | × | v12.6.4 | Requires configuring environment variables for XUGU dynamic libraries, similar to DMSpatial. Recommended operation: Copy the dynamic libraries to the component's bin directory (directly configure the bin directory in environment variables). Supported dataset types include: Tabular, Point, Line, Region, Text, CAD, Network Dataset. |
- Schema: An important method for organizing database objects, used for logical grouping of database objects (such as tables, views, functions) to achieve permission separation and data management in multi-user environments. For details on specifying Schema when opening or creating a datasource, please refer to Datasource Supports Specifying Schema.
- Applicable Databases: PostGIS, POLARDBGanos, KingBase, HighGoDB, SHENTONG, Vastbase.
-
Supports entering a Schema name, which is empty by default. If a Schema is specified, newly added datasets (creating a dataset, importing a dataset, copying a dataset) will be stored in the specified Schema. If no Schema is specified, they will be stored under the datasource's default Schema.
- Driver: When opening an SQLPlus database datasource, the program automatically identifies all drivers installed on the current client, and you can select one as needed. The default driver is SQL Server.
- Maximum Connection Pool Size: When opening OraclePlus or PostgreSQL database datasources, you can set the maximum number of connections for the database connection pool. The database connection pool is responsible for allocating, managing, and releasing database connections. The maximum connection number is the maximum number of connections the pool can allocate. If database connection requests exceed this number, subsequent requests will be added to a waiting queue.
- The Load Data Link Info drop-down button in the dialog box provides functionality for loading and saving database datasource link information, making it convenient for users to save and load information for previously opened database datasources.
- Load Data Link Info: Loads a *.dcf format data link file, which contains information such as server, database, and username for a database datasource.
- Save Data Link Info: Saves the currently set database datasource information (server, database, username, etc.) into a *.dcf file.
Open Web Datasource
- Execute Open Web Datasource by any of the above methods, and the corresponding dialog box will pop up.
- In the Open Web Datasource dialog box, you can switch the Web type in the left list, and enter the necessary information for the datasource to open on the right.
- OGC: Enter the server address and select the service's server type: WMS, WFS, WCS, TMS, or WMTS. Among them, WMS, WCS, and WMTS services are opened as read-only datasources; WFS services can be simply edited after opening. After opening a WMTS service, a local cache folder is generated: installation path\Bin\Cache\WebCache\WMTS. Within this folder, directories are created based on the published service address to save different map tile files and request files (*.xml).
- iServerREST: Enter the map or image service address published by SuperMap iServer to open the datasource.
- Tianditu-Online: Provides map services interfacing with SuperMap Online from Tianditu.
- Tianditu: Provides access to seven map services. Select a service from the drop-down list in the Service Name field; the Server Address, Alias, and opening mode are default parameters, and users can input a service key. For key application instructions, please refer to: Tianditu Key Application.
- Google Maps: Server Address, Server Type, Username, and opening mode are default parameters; click Open.
- WorldTerrain: Provides two services: Light Topographic Map and Dark Topographic Map. Select a service from the drop-down list in the Service Name field; the Server Address, Alias, and opening mode are default parameters.
- iServer DataStore: Experience services provided by the iServer server based on the URLs provided in the Service Examples.
- XYZTile: Opens online maps in XYZTile format, including open maps like Baidu and Gaode. However, due to data protection, not all online maps can be opened. Example: Enter a server address like: https://your.tileservice.com/tiles/{z}/{x}/{y}.png?tilesize=256&dpi=96.
- {x}{y}{z} represent placeholder tokens for the requested tile location; currently, only setting them as {zoom} or {z}, {x}, {y} or {-y} is supported.
- tilesize represents the size of tiles; typically, tile sizes are 256×256, 512×512; default is 256. When the tile size in the service is not 256, add the tilesize parameter to the address.
- dpi represents the tile resolution; default is 96. When the resolution in the service is not 96, add the dpi parameter to the address.
- GEOVIS Earth: Provides vector, image, and terrain map services from GEOVIS Earth.
- SIWEI Earth: Provides remote sensing data services. Server Address, Key, and opening mode are default parameters.
- Careland: Provides finished national map data segmented by region and object. Server Address, Key, and opening mode are default parameters.
- Century Space Images: Provides internet-based full-resolution online image application services. No need to order or download any satellite data. Access data services via browser or application after authorization authentication.
- Jilin No.1: The default image service address provided by the system is for experience and preliminary browsing only and may fail to open due to access limit exceedance. To ensure service stability, please obtain a dedicated server address by following these steps:
- Register and log in to the Jilin No.1 Website.
- Enter the "Jilin No.1 Sliced Image Suite" module.
- On the "My Suites" -> "View Suite Details" -> "Suite Management" page, obtain the server address (format like https://api.jl1mall.com/getMap/{z}/{x}/{y}?mk=***&tk=***).
- Currently, Google Maps cannot be displayed normally within mainland China; maps will appear blank after opening. However, users outside mainland China can use Google Maps normally.
- The opened datasource will be organized under the datasource collection in the workspace and identified by the datasource's unique alias. At the same time, the Workspace Manager will change accordingly: a datasource sub-node corresponding to the opened datasource will be added under the datasource collection in the tree structure, and its display name will be the alias of the datasource. Furthermore, a series of child nodes will be added under this datasource node, each corresponding to a dataset within the datasource.
- Web maps (including OGC, Google Maps, etc.), image maps, map tiles, and similar types currently do not support dynamic projection.
Web maps (including OGC, Google Maps, etc.) do not support linked views across multiple windows.
- Currently, Scene does not support loading Tianditu data.
- When opening an OGC WMTS service, you may notice an offset in the WMTS service. This is caused by the inconsistency between the DPI for desktop application map display and the DPI for requesting web maps. Change the CustomDPIX and CustomDPIY parameters in the [Installation Path]\Bin\Supermap.xml file to 90.7.
Related Topics