Function Description

Supports opening file datasources, database datasources, and web-based datasources. For 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 to open different types of datasources.
• Workspace Manager Panel -> Datasource Node Context Menu -> Select the type of datasource to open.

Operation Steps

Open File Datasource

1. Execute Open File Datasource 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 datasource 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 supported. For example: If a UDBX is stored in a shared folder on a Windows system, this shared file only supports reading on a 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 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.

Open Folder Datasource

Through Workspace Manager Panel -> Datasource Node Context Menu -> Open Folder Datasource, in the popped-up Open Folder Datasource dialog box, select the folder type to open (currently only FileGDB type is supported), then enter the FileGDB folder path and folder name in the folder input box, and click OK.

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 of the datasource to open on the right. Parameters vary for different database types. The following table introduces the parameters and precautions for opening different types of database datasources:

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	Client must be installed, and environment variables configured correctly.
2	OraclePlus	√	×	√	√	×	√	×	9i and above	Client must be installed, and environment variables configured correctly. There are two ways to connect to the server: The first is to configure the client to ensure the client can connect to the service through the instance; the second is to connect using the easy connect naming method, with the instance name format: host[:port][/service_name].
3	OracleSpatial	√	×	√	√	×	√	×	9i and above	Client must be installed, and environment variables configured correctly. There are two ways to connect to the server: The first is to configure the client to ensure the client can connect to the service through the instance; the second is to connect using the easy connect naming method, with the instance name format: host[:port][/service_name].
4	PostgreSQL	×	√	√	√	×	√	×	9.1 and above	The remote server must ensure local access permissions. If there is no permission, go to the server's data save path and modify the /data/pg_hba.conf file to add 'host all all 0.0.0.0/0 trust', then restart the service.
5	PostGIS	×	√	√	√	√	√	×	3.1/3.2/3.3	PostGIS engine type, a spatial data extension of PostgreSQL. For PostGIS datasources, no client installation is required. The remote server must ensure local access permissions. When opening a PostGIS datasource, if the sm system table is missing, some functions will not work properly. Data can be repaired using the Fix Datasource tool. The PostGIS engine supports accessing multiple domestic databases such as KingBase (CETC), Vastbase (Massive Data), SHENTONG, HighGo (HanGao), Transwarp Graph Database, UXDB (YouXuan), Huawei GaussDB 200. Among them, KingBase, SHENTONG, and HighGo also provide separate engine types, with the same functional scope as the PostGIS engine.
6	HighGoDB	×	√	√	√	√	×	×	6.0	Unified type with PostGIS.
7	KingBase	×	√	√	√	√	×	×	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 variables must be configured correctly.
9	MySQL	×	√	√	√	×	×	×	5.6 and above	The remote server must ensure local access permissions. If there is no permission, you can 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 local access permissions.
12	DMPlus	×	√	√	√	×	×	×	7.1.4 and above	Client must be installed, and environment variables configured correctly. Need to configure environment variables for DM dynamic library, similar to DMSpatial. Recommended operation: Copy the dynamic library to the component's bin directory (configure the bin directory directly in environment variables).
13	DMSpatial（beta）	×	√	√	√	×	×	×	8.1.3 and above	Client must be installed, and environment variables configured correctly. Recommended operation: Copy the dynamic library to the component's bin directory (configure the bin directory directly in environment variables). 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 environment variables for XUGU dynamic library, similar to DMSpatial. Recommended operation: Copy the dynamic library to the component's bin directory (configure the bin directory directly in environment variables). Supported dataset types include: Attribute, Point, Line, Region, Text, CAD, Network Dataset.

• Schema：A logical container in a database used to organize and manage objects (such as tables, views, indexes, etc.). It is similar to a "folder" in a file system, used to categorize and isolate database objects, enhancing the flexibility of permission control. For instructions on opening a datasource and creating a datasource supporting specified Schema, please see Datasource Supports Specifying Schema.
  • Applicable Databases：PostGIS, POLARDBGanos, KingBase, HighGoDB, SHENTONG, Vastbase.

  • Supports inputting a schema name, which is empty by default. If a schema is specified, creating and importing datasets will default to this specified schema. If no schema is specified, creating and importing datasets will default to the schema where the datasource is located.

• Driver：When opening a SQLPlus database datasource, the program automatically recognizes all drivers installed on the current client. Select one of the drivers as needed. The default driver is SQL Server.
• Max Connection Pool Size：When opening OraclePlus or PostgreSQL database datasources, it supports setting 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 apply for. If database connection requests exceed this number, subsequent connection requests will be added to a waiting queue.
• The Load Data Link Info drop-down button in the dialog box provides loading and saving of database datasource link information, making it convenient for users to save and load information of opened database datasources.
  • Load Data Link Info：Load a data link file in *.dcf format, which contains information such as database datasource server, database, username, etc.
  • Save Data Link Info：Save the currently set database datasource server, database, username, and other information in 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 types in the left Web type list, and enter the necessary information of the datasource to open on the right. 

• OGC：Enter the server address, and select the server type of this service: WMS, WFS, WCS, TMS, or WMTS. Among them, WMS, WCS, and WMTS become read-only datasources after opening; WFS services allow simple editing after opening. After opening a WMTS service, a cache folder will be generated locally: Installation path\Bin\Cache\WebCache\WMTS. Under this folder, folders are created according to the published service's address, saving different map tile files and request files (*.xml).
• iServerREST：Fill in the server address to open this datasource.
• Tianditu-Online：Provides map services connected with SuperMap Online.
• Tianditu: Provides opening of 7 map services. Select the service from the service name drop-down box; server address, alias, and opening method are default parameters. Supports users inputting a service key. For key application instructions, please refer to: Tianditu Key Application.
• Google Maps: Server address, server type, username, and opening method are default parameters. Click Open.
• WorldTerrain: Provides two services: light topographic map and dark topographic map. Select the service from the service name drop-down box; server address, alias, and opening method are default parameters.
• iServer DataStore：Experience services provided by the iServer server based on the URLs provided in the Service Examples.
• XYZTile：Open online maps in XYZTile format, including Baidu, Gaode, and other open maps. However, due to data protection, not all online maps can be opened. Example: Enter this server address: https://your.tileservice.com/tiles/{z}/{x}/{y}.png?tilesize=256&dpi=96.
  • {x}{y}{z} represent placeholder requests for tile positions. Currently, only supports setting to {zoom} or {z}, {x}, {y} or {-y}.
  • tilesize represents the size of tiles. Usually, the size of tiles is 256×256, 512×512, default is 256. When the tile size in the service is not 256, the tilesize parameter needs to be added to the address.
  • dpi represents tile resolution, default is 96. When the resolution in the service is not 96, the dpi parameter needs to be added 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 method are default parameters.
• Careland：Provides finished national map data by region and object. Server address, key, and opening method are default parameters.
• Century Space Images：Provides internet-based full-resolution online image application services. No need to order or download any satellite data. After authorization, data services can be accessed through a browser or application.

Related Topics

Open External Vector File

New Datasource

Manage Datasource