Function Description

Supports opening file datasources, database datasources, and web-based datasources. For characteristics and application scenarios of each type, refer to Datasource Overview.

Feature Entry

• File Tab -> Open Button -> Select datasource type
• Start Tab -> Datasource Group -> Choose File, Database, or Web to open different datasource types
• Workspace Manager Panel -> Datasource Node Context Menu -> Select desired datasource type

Steps

Open File Datasource

1. Execute Open File Database through any above method to invoke the corresponding Dialog.
2. In Open File Datasource dialog, select target file database. Supports *.udb/udbx files and opening external image/vector files including local files and files from Cloud Storage.
   • Spatial data engine types: Includes UDBX(*.udbx), UDB(*.udb), SpatiaLite(*.sqlite), GeoPackage vector files(*.gpkg). SpatiaLite serves as native database for UDBX.
     Note:

     Editing UDBX files across operating systems is unsupported (read-only). Example: UDBX stored in Windows shared folder can only be read (not edited) when accessed from Linux.

   • Image file types: *.sit, *.bmp, *.jpg, *.jpeg, *.png, *.tif, *.tiff, *.img, *.sci, *.gif, *.ecw, *.sid, *.bil, *.jp2, *.j2k, *.EGC, *.tpk
   • Vector file types: *.shp, *.mif, *.tab, *.dwg, *.dxf, *.dgn, *.kml, *.kmz, *.wal, *.wan, *.wap, *.wat, *.csv, *.dbf, *.000, *.vct, *.json, *.geojson, *.meta, *.gpkg, *.mdb, *.e00, *.gdb (folder-type vector file)
     Tip:

     When opening external files directly into workspace, a datasource with same filename will be created, containing the file as dataset.

Open Directory Datasource

Via Workspace Manager Panel -> Datasource Node Context Menu -> Open directory datasource. In Open Directory Datasource dialog, select folder type (currently FileGDB only), input FileGDB folder path and name, then click OK.

Open Database Datasource

Supports SQLPlus, Oracle Plus, Oracle Spatial, PostgreSQL, PostGIS, Yukon, MySQL, POLARDBGanos, GaussDB 200, DMPlus, ES, etc.

1. Execute Open Database Datasource through any above method to invoke dialog.
2. In Open Database Datasource dialog, switch database types from left panel and input required parameters. Parameters vary by database type:

No.	DB Type	Instance	Server	DB Name	User/Pass	Max Pool	Driver	Supported Versions	Notes
1	SQLPlus	×	√	√	√	×	√	2000/2005/2008/2012/2017	Client required. Ensure correct environment variables.
2	OraclePlus	√	×	√	√	√	×	9i+	Client required. Two connection methods: 1) Client configuration; 2) Easy connect naming (host[:port][/service_name])
3	OracleSpatial	√	×	√	√	√	×	9i+	Same as OraclePlus.
4	PostgreSQL	×	√	√	√	√	×	9.1+	Ensure remote access permissions. Modify /data/pg_hba.conf if needed.
5	PostGIS	×	√	√	√	√	×	3.1/3.2/3.3	PostgreSQL spatial extension. No client needed. Missing system tables may require datasource repair.
6	HighGoDB	×	√	√	√	×	×	6.0	Same category as PostGIS.
7	KingBase	×	√	√	√	×	×	7.1.1+	Same category as PostGIS.
8	Yukon	×	√	√	√	√	×	Yukon 1.0+ PostgreSQL 9.1+ openGauss 2.1/3.1/5.0 GaussDB 503.1/505.0/505.1	Environment variables required for openGauss/GaussDB kernels. See configuration guide.
9	MySQL	×	√	√	√	×	×	5.6+	Grant remote access via: GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY pwd; FLUSH PRIVILEGES
10	POLARDBGanos	×	√	√	√	√	×	1.2.1
11	GaussDB 200	×	√	√	√	√	×		Ensure remote access permissions.
12	DMPlus	×	√	√	√	×	×	7.1.4+	Client required. Copy DLLs to component's bin directory.
13	DMSpatial（beta）	×	√	√	√	×	×	8.1.3+	Copy DLLs to component's bin directory. Supported datasets: Attribute, Point, Line, Region, Text, CAD, Mosaic.
14	ES	×	√	√	×	×	×	6.8.0	Requires accessible Elasticsearch server.
15	SHENTONG	×	√	√	√	×	×	7.0	Same category as PostGIS.
16	Vastbase	×	√	√	√	√	×		Same category as PostGIS.
17	XUGU DB（beta）	×	√	√	√	×	×	v12.6.4	Configure XUGU DLLs path. Supported datasets: Attribute, Point, Line, Region, Text, CAD, Network.

• Driver: Auto-detected for SQLPlus. Default: SQL Server.
• Max Connection Pool: For OraclePlus/PostgreSQL. Controls maximum database connections.
• Load/Save Data Link Info via dropdown:
  • Load data link info: Load *.dcf file containing connection parameters.
  • Save data link info: Save current settings to *.dcf file.

Open Web Datasource

1. Execute Open Web Datasource to invoke dialog.
2. Select web type from left panel and input parameters.

• OGC: Input server address and select service type (WMS/WFS/WCS/TMS/WMTS). WMS/WCS/WMTS are read-only. WMTS generates local cache at \Bin\Cache\WebCache\WMTS.
• iServerREST: Input server address directly.
• Tianditu-Online: Provides SuperMap Online-integrated map services.
• Tianditu: Offers 7 map services with default parameters. API key required - see Tianditu API Key Application.
• Google Maps: Default parameters. Click Open directly.
• WorldTerrain: Light/Dark topographic maps with default parameters.
• iServer DataStore: Access sample services via example URLs.
• XYZTile: Open XYZTile online maps (Baidu, Gaode, etc.). Example URL: https://your.tileservice.com/tiles/{z}/{x}/{y}.png?tilesize=256&dpi=96
  • {z}/{x}/{y}: Tile position placeholders (supports {zoom}, {z}, {x}, {y}, {-y})
  • tilesize: Tile dimensions (default 256)
  • dpi: Tile resolution (default 96)
• GEOVIS Earth: Vector/imagery/terrain services from GEOVIS Earth.
• SIWEI Earth: Remote sensing data with default parameters.
• Careland: Regional map data with default parameters.
• Century Space Images: Online full-resolution imagery service requiring authorization.

Related Topics

Open External Vector Files

Create New Datasource

Manage Datasources