Open Datasource

Support Open File Datasource, Database-type Datasource and Web-type Datasource. See the Data source overview for features and applicable scenarios for each type of Datasource.

Open Datasource through the following function entry:

  • File tab-> Open button-> Select Datasource Type
  • Home tab-> Datasource group-> Select File type, Database or Web type to open different types of Datasource.
  • Workspace Manager Panel-> Datasource Node Context Menu-> Select the type of Create Datasource

Open File Datasource

  1. Execute Open File Database in any of the above ways, and the corresponding dialog will pop up.
  2. In the Open File Datasource dialog, select the File Database file you want to open. Supports opening of *.udb or *.udbx files, as well as Open external Image Files and Vector File . Includes files on Local File and Cloud Storage .
    • Spatial Data Engine Type: includes UDBX (*.udbx), UDB (*.udb) and SpatiaLite (*.sqlite) files. SpatiaLite is the native database of UDBX.
      Caution:
      Editing of UDBX files across operating systems

      is not supported. Only reading is supported. For example, UDBX is a shared folder stored in the windows system. This shared file is only supported for reading in the Linux system. Allow Editing is not supported.

    • Image File Type: including *.sit, *.bmp, *.jpg, *.jpeg, *.png, *.tif, *.tiff, *.img, *.sci, *.gif, *.ecw, *.sid, *.bil, *.jp2, *.j2k, *.EGC, *.tpk format.
    • Vector File Type: including *.shp, *.mif, *.tab, *.dwg, *.dxf, *.dgn, *.kml, *.kmz, *.wal, *.wan, *.wap, *.wat, *.csv, *.dbf, *.000, *.vct, *.json, *.geojson, *.gpkg, *.mdb, *.e00, *.gdb, where *.gdb is a Folder typeVector File.
      Hint:
      When an

      external file is directly opened to Workspace, a Datasource with the same name as the file will be added to Workspace, and the file will be the Dataset

      in the Datasource

Open Database Datasource

Currently supports opening SQLPlus, Oracle Plus, Oracle Spatial, PostgreSQL, PostGIS, Yukon, MySQL, POLARDBGanos, GaussDB 200, DMPlus, ES and other Database-type Datasource.

  1. Execute Open Database-type Datasource in any of the above ways, and the corresponding dialog will pop up.
  2. In the Open Database Datasource dialog, you can switch the database type in the list of database types on the left and enter the necessary information for the Datasource to be opened on the right. Different Database types have different Parameter Settings. The following table describes the parameters to be set for opening different types of Database-type Datasource and their considerations:
Caution:

Application will Auto Save the connected database address, and the user can select History to realize quick login when logging in later.

Serial number Database type Instance name Server address Database Name Username/Password Maximum connection pool Version supported Precautions
1 SQLPlus × × 2000/2005/2008/2012/2016 There must be a client, and the Environment Variable is configured correctly.
2 OraclePlus × Optional 9 I/10g/11 G/12c version There must be a client and the Environment Variable is configured correctly. There are two ways to connect to the server. The first way is to configure the client to ensure that the client can connect to the Service through an instance. The second method is easy connect naming method. The format of the instance name is host : port /service _ name.
3 OracleSpatial × Optional 10g and 11 G, 12 C are recommended There must be a client and the Environment Variable is configured correctly. There are two ways to connect to the server. The first way is to configure the client to ensure that the client can connect to the Service through an instance. The second method is easy connect naming method. The format of the instance name is host : port /service _ name.
4 PostgreSQL × 9.6 and above The Remote Service side must ensure that the local machine has Access Permissions. If there is no permission, modify the/data/PG _ hba. Conf file under the Data Save path of the server side and add the host all all 0.0.0.0/0 trust. Restart the service.
5 PostGIS × 9.6 and above PostgreSQL's Spatial Data extension PostGIS engine type. For PostGIS Data source, there is no need to install the client, and the Remote Service side must ensure that there are Access Permissions on the local machine.
6 HighGoDB × × 6.0 It is the same type as PostGIS.
7 KingBase × × Version V7 It is the same type as PostGIS.
8 Yukon ×   When the database kernel is openGauss or GaussDB , the Environment Variable configuration must be correct.
9 MySQL × × 5.6.16 and above The Remote Service must ensure that the local machine has Access Permissions. If you do not have permission, you can refer to the statement grant all privileges on *. * to user @ '%' identified by pwd; Flush privileges, where% can be replaced by a specific IP.
10 POLARDBGanos ×    
11 GaussDB 200 × 2.1 The Remote Service side must ensure that the local machine has Access Permissions.
12 DMPlus × Optional × DM7/DM8 version There must be a client, and the Environment Variable is configured correctly.
13 ES × × ×   Elastics earch is a popular enterprise search engine. A natively accessible Elastics earch server is sufficient.
14 SHENTONG × ×   Same type as PostGIS.
15 Vastbase ×   Same type as PostGIS.
  • Maximum connection number of connection pool: When opening OraclePlus and PostgreSQL database Datasource, it is supported to set the maximum connection number of database connection pool. The database connection pool is responsible for allocating, managing, and releasing database connections. The maximum number of connections is the maximum number of connections that the connection pool can request. If the number of database connection requests exceeds this number, subsequent data connection requests will be added to the waiting queue.
  • The Load data link info Drop-down Button in the dialog provides Link Information for loading and saving the DataBase Datasource. It is convenient for users to save and load the opened Database-type Datasource information.
    • Load data link info: Load the Data link file in the format of *.dcf, including data library, Datasource server, database, user name, etc.
    • Save data link info: Save the currently set database Datasource server, database, user name and other information in the *.dcf file.

Open WebDatasource

  1. Executing Open WebDatasource in any of the above ways will bring up the corresponding dialog.
  2. In the Open WebData source dialog, you can switch between the types in the list of Web types on the left and enter the necessary information for the Datasource you want to open on the right.
  • OGC : Enter Server Address and select the Server Type of the service: WMS, WFS, WCS, TMS, or WMTS. WMS, WCS and WMTS are all read-only Datasource after opening, and WFS service can be edited simply after opening. After the WMTS service is opened, a cache folder is generated locally: installation path \ Bin \ Cache \ WebCache \ WMTS. Create a folder under this folder according to the address of Publich Service, and save different Map Tiles files and request files (*.xml).
  • iServerREST : Fill in the Server Address to open the Datasource.
  • Tianditu-Online: Provides the Tianditu-Online Service that interfaces with SuperMap Online.
  • Sky Map : Provide and open 7 items of Map Service. Select the service in the service name drop-down box. Server Address, Alias and Open Method are the default parameters. Users can enter the service key. For key application instructions, see Tianmap key application .
  • Google Maps : Server Address, Server Type, Username, and Open Method are the default parameters. Click Open.
  • WorldTerrain : Offers both light California Map and Dark Topographic Map. Select the service in the Service Name drop-down box. Server Address, Alias, and Open Method are the default parameters.
  • IServer DataStore: Experience the services provided by the iServer server according to the URL provided in the Examples of services .
  • XYZ Tile: Open Online Map in XYZ Tile format, including Baidu, AutoNavi 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 } represents the Tile position requested by the placeholder. Currently, only { zoom } or { Z }, { X }, { y }, or { -y }
    • is supported
    • The tilesize represents the size of tiles. The size of tiles is usually 256 × 256 and 512 × 512. The default value is 256. When the size of tiles in service is not 256, a tilesize Parameter Settings
    • needs to be added to the address.
    • dpi indicates the Tile resolution, which is 96 by default. When the in-service resolution is not 96, dpiParameter Settings
    • needs to be added to the address
  • GEOVIS Earth : provide vector, image and terrain Map Service from GEOVIS Earth.
  • SIWEI earth : Provide remote sensing Data Service. Server Address, Key, and Open Method are the default parameters.
  • Kellett : provide national map product data by region and object. Server Address, Key, and Open Method are the default parameters.
  • Century Space Images : to provide Internet-based full-resolution image online application services. There is no need to order or download any satellite data. The Data Service can be accessed through the browser or Application after authentication.
Caution:
  1. At present, Google Maps can not display maps normally in mainland China, and the map will be blank after opening, but overseas users can use Google Maps normally.
  2. Open Datasources are organized under the Datasource collection in Workspace and are identified by a unique alias for the Datasource. At the same time, the Workspace Manager will also change accordingly, and a Datasource sub-node will be added under the Datasource set in the tree structure of the Workspace Manager, which corresponds to the opened Datasource. And the Show Name of the node is the alias of the Datasource. And a series of child nodes are added under the Datasource node, and each child node corresponds to a Dataset in the Datasource.
  3. Dynamic Projection is not supported for
  4. Web maps (including OGC, Google Maps, etc.), Image Map, Map Tiles , etc.

    Web maps (including OGC, Google Maps, etc.) Do not support multiple windows Associated Browse.

  5. Currently, Scene does not support loading map data.
  6. When opening the WMTS service of OGC, it may be found that there is an offset in the WMTS service, which is caused by the inconsistency between the DPI displayed on the desktop Application map and the DPI of the requested network map. Change the CustomDPIX and CustomDPIY Parameter Settings in the Installation Path \ Bin \ Supermap. XML file to 90.7.

Related topics

Open External Vector File

Create Datasource

Manage Data source