Open Datasource

Function 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 Datasource Overview.

Function Entry

  • File tab -> Open button -> Select datasource type.
  • Start tab -> Datasource group -> Select File, Database or Web Type to open different types of datasources.
  • Workspace Manager panel -> Datasource node context menu -> Select the datasource type to open.

Operation Steps

Open File Datasource

  1. Execute Open File Database in any of the above ways, and the corresponding Dialog Box will pop up.
  2. 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).
      Notice:

      Editing of UDBX files across different operating systems is not supported; only reading is allowed. For example, if a UDBX file is stored in a shared folder under the Windows system, this shared file only supports reading under the Linux system and does not allow editing.

    • 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 an external file is directly opened 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 in that datasource.

Open File Geodatabase

Currently supported folder type datasource to open:  File GDB file (*.gdb).

1. You can choose any of the following methods to open file geodatabase:

  • In the workspace manager's Datasource node context menu -> Open File Geodatabase
  • Directly drag and drop the File GDB folder to Workspace Manager
  • In Catalog Manager -> Recently Used, double-click to open the File GDB folder

2. In the Select dialog box that pops up, select the File GDB folder 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 File GDB list:
    • Add: Add a new File GDB folder.
    • Delete: Remove the selected File GDB folder.
    • Select All: Select all File GDB folders.
    • Invert Selection: Invert the current selection state.
  • Set opening parameters:
    • Import as 3D Data: Specifies whether to open feature classes containing Z values from 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 with read-only.
      • Selected - The file can only be viewed and cannot be edited.
      • Not selected - Supports operations such as geometric feature editing and attribute editing on datasets in this datasource. This is the default.

4. Click OK to complete the opening operation.

Open Database Datasource

Currently supports opening various database datasources such as SQLPlus, Oracle Plus, Oracle Spatial, PostgreSQL, PostGIS, Yukon, MySQL, POLARDBGanos, GaussDB 200, DMPlus, ES, and more.

  1. Execute Open Database Datasource in any of the above ways, and the corresponding dialog box will pop up.
  2. In the Open Database Datasource dialog box, you can switch the database type in the left database type list, and enter the necessary information for the datasource to be opened on the right. Parameters vary for different database types. The following table introduces the parameters that need to be set for opening different types of database datasources and their precautions:
Notice:

The application will automatically save the connected database addresses. Users can select history for quick login later.

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 Must have a client and environment variables configured correctly.
2 OraclePlus × × × 9i and above Must have a client and environment variables configured correctly. There are two ways to connect to the server: first, configure the client to ensure the client can connect to the service end through the instance; second, connect using the easy connect naming method, with instance name format host[:port][/service_name].
3 OracleSpatial × × × 9i and above Must have a client and environment variables configured correctly. There are two ways to connect to the server: first, configure the client to ensure the client can connect to the service end through the instance; second, connect using the easy connect naming method, with instance name format host[:port][/service_name].
4 PostgreSQL × × × 9.1 and above The remote service end must ensure that the local machine has access permissions. If not, 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" and restart the service.
5 PostGIS × × 3.1/3.2/3.3 This is the spatial data extension PostGIS engine type for PostgreSQL. No client installation is required for the PostGIS datasource, but the remote service end must ensure the local machine has access permissions.
When opening a PostGIS datasource, if the sm system table is missing, some functions will not work properly. You can use the Repair Datasource tool to repair the data.
The PostGIS engine supports accessing various domestic databases: KingBase, Vastbase, Shenzhou General, HighGo, Xinghuan graph database, Youxuan UXDB, and Huawei GaussDB 200. Among them, KingBase, Shenzhou General, and HighGo also provide separate engine types, with the same functional scope as the PostGIS engine.
6 HighGoDB × × × 6.0 Same type as PostGIS.
KingBase × × × 7.1.1 and above Same type as 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 variables need to be configured correctly.
9 MySQL × × × × 5.6 and above The remote service end must ensure the local machine has access permissions. If not, refer to the statement: grant all privileges on *.* to user@'%' identified by pwd; flush privileges. The % can be replaced with a specific IP.
10 POLARDBGanos × × Version 1.2.1  
11 GaussDB 200 × × ×   The remote service end must ensure the local machine has access permissions.
12 DMPlus × × × × 7.1.4 and above To ensure a successful connection to the DM database, you need to obtain the complete client dependency file package (usually including dmoci.dll and other key dynamic link libraries) from the DM database vendor, and configure the client dependency files to the system environment variables. Then you can normally open the DM database datasource.
13 DMSpatial (beta) × × × × 8.1.3 and above To ensure a successful connection to the DMSpatial database, you need to obtain the complete client dependency file package (usually including dmoci.dll and other key dynamic link libraries) from the DMSpatial database vendor, and configure the client dependency files to the system environment variables. Then you can normally open the DMSpatial database datasource.
Supported dataset types include: Attribute, 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 Need to configure the environment variable for the XUGU dynamic library, similar to DMSpatial. Recommended operation: Copy the dynamic library to the component bin directory (environment variable directly configured to the bin directory).
Supported dataset types include: Attribute, Point, Line, Region, Text, CAD, Network Dataset.
  • Schema: An important database object organization method used to logically group database objects (such as tables, views, functions) to achieve permission separation and data management in a multi-user environment. For instructions on specifying Schema when opening or creating a datasource, please see Datasource Supports Specifying Schema.
    • Applicable databases: PostGIS, POLARDBGanos, KingBase, HighGoDB, SHENTONG, Vastbase.
    • Supports entering a Schema name. The default is empty. If a Schema is specified, new datasets (create dataset, import dataset, copy dataset) will be stored in the specified Schema. If no Schema is specified, they will be stored in the Schema where the datasource resides.

  • Driver: When opening a SQLPlus database datasource, the program automatically identifies all drivers installed on the current client. Select one driver as needed. The default driver is SQL Server.
  • Max Connection Pool Size: When opening OraclePlus or PostgreSQL database datasources, supports setting the maximum number of connections in the database connection pool. The connection pool is responsible for allocating, managing, and releasing database connections. The maximum number of connections is the maximum number of connections the pool can apply for. If database connection requests exceed this number, subsequent requests will be added to the waiting queue.
  • The Load data link info drop-down button in the dialog provides the ability to load and save the link information of database datasources, making it convenient for users to save and retrieve previously opened database datasource information.
    • Load data link info: Loads a *.dcf format data link file, which contains information such as the database datasource server, database, and username.
    • Save data link info: Saves the currently set database datasource server, database, username and other information to a *.dcf file.

Open Web Datasource

  1. Execute Open Web Datasource in any of the above ways, and the corresponding dialog box will pop up.
  2. In the Open Web Datasource dialog box, you can switch the type in the left Web type list, and enter the necessary information for the datasource to be opened on the right. 
  • OGC: Enter the server address, and select the server type of the service: WMS, WFS, WCS, TMS or WMTS. Among them, WMS, WCS, and WMTS are read-only datasources after opening; WFS services can be simply edited after opening. After opening a WMTS service, a local cache folder will be generated: Installation Path\Bin\Cache\WebCache\WMTS. Under this folder, a folder will be created based on the address of the published service to save different map tile files and request files (*.xml).
  • iServerREST: Fill in the map or image service address published by SuperMap iServer to open the datasource.
  • Tianditu-Online: Provides map services connected to SuperMap Online.
  • Tianditu: Provides access to 7 map services. Select the service from the name of the service drop-down box. The server address, alias, and opening method are default parameters. Users can input a service key. For key application instructions, please refer to: Tianditu Key Application.
  • Google Maps: The server address, server type, username, and opening method are default parameters. Click Open.
  • WorldTerrain: Provides light topographic map and dark topographic map services. Select the service from the name of the service drop-down box. The server address, alias, and opening method are default parameters.
  • iServer DataStore: Based on the URL provided in the Service Example, experience the services provided by the iServer server.
  • XYZTile: Opens XYZTile format online maps, including Baidu, Amap and other open maps. However, due to data protection, not all online maps can be opened. For example: Input this server address: https://your.tileservice.com/tiles/{z}/{x}/{y}.png?tilesize=256&dpi=96.
    • {x}{y}{z} represent the tile position of the placeholder request. Currently only supports setting to {zoom} or {z}, {x}, {y} or {-y}.
    • tilesize indicates the size of tiles. Usually the size of tiles is 256×256 or 512×512, default is 256. When the tile size in the service is not 256, you need to add the tilesize parameter to the address.
    • dpi indicates the tile resolution, default is 96. When the resolution in the service is not 96, you need to 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. The server address, key, and opening method are default parameters.
  • Careland: Provides national map finished product data divided by region and object. The server address, key, and opening method are default parameters.
  • Century Space Images: Provides full-resolution online application services for imagery based on the internet. No need to order or download any satellite data. After authorization and authentication, data services can be accessed via browser or application.
  • Jilin No.1: The default image service address provided by the system is for trial and preliminary browsing only. It may fail to open due to excessive access. To ensure service stability, please follow the steps below to obtain a dedicated server address:
    1. Register and log in to Jilin No.1 Website.
    2. Enter the "Jilin No.1 Tiled Image Suite" module.
    3. Obtain the server address on the "My Suites" -> "View Suite Details" -> "Suite Management" page (format like https://api.jl1mall.com/getMap/{z}/{x}/{y}?mk=***&tk=***).
Notice:
  1. Currently, Google Maps cannot be displayed normally in Mainland China. After opening, the map will appear blank, but users outside China can use Google Maps normally.
  2. The opened datasource will be organized under the datasource collection of the workspace, and identified by a unique alias of the datasource. At the same time, the workspace manager will also change accordingly. A datasource child node will be added under the datasource collection in the tree structure of the workspace manager. This node corresponds to the opened datasource, and the display name of the node is the alias of the datasource. Additionally, a series of child nodes will be added under this datasource node, each corresponding to a dataset in the datasource.
  3. Web maps (including OGC, Google Maps, etc.), image maps, map tiles, and other types do not currently support dynamic projection.

    Web maps (including OGC, Google Maps, etc.) do not support linked views across multiple windows.

  4. Currently, the scene does not support loading Tianditu data.
  5. When opening the OGC WMTS service, you may find a shift in the WMTS service. This is due to inconsistency between the DPI of the desktop application map display and the DPI of the requested network map. Set the CustomDPIX and CustomDPIY parameters in the [Installation Path]\Bin\Supermap.xml file to 90.7.

Related Topics

Open External Vector Files

New Datasource

Manage Datasource