Registering spatial database |
Log in to iServer Manager (http://<server>:<port>/iserver/manager), click "Clusters">"Data Registration". "Data Storage List" shows all the registered data stores. Click on storage ID of a data store, you can view the detailed storage configuration information. To register a spatial database, click "Register data storage".
Specific configurations:
Storage ID: Create a unique identifier for the database.
Data storage type: Select "Spatial database".
Database type: Currently supports HBase, Oracle, PostgreSQL, POSTGIS, MONGODB.
Service address: The database connection address.
Database name: The database you will use.
User: The username of the database owner (except HBASE).
Password: The password of the database owner (except HBASE).
Editable: This option is supported when registering HBase, PostgreSQL, and POSTGIS databases.
Check "Editable": This database can be used as a storage node for uploading relational data for data catalog service. As a storage node for uploading relational data, the storage follows these guidelines:
When you registered multiple databases that are allowed to be edited, the database with the least datasets is preferred as the storage node.
When you registered databases that are allowed to be edited and the iServer DataStore at the same time, the database that are allowed to be edited and that has the least datasets is preferentially selected as the storage node.
If you only registered the iServer DataStore, the iServer DataStore can be used as a storage node.
Uncheck "Editable": This database cannot be used as a storage node for uploading relational data for data catalog service.
Note: When registering data storage, if the iServer service is not on the same machine as the HBase cluster, you need to add the ip and host name of the machine where each node of the HBase cluster locates to the hosts file of the machine where the iServer service locates.
Alternatively, You can register a spatial database through modifying Data catalog service configuration file. Add the following contents in iserver-datacatalog.xml to complete registering:
<datastore> <datastoreType>SPATIAL</datastoreType> <name>postgresql2</name> <type>POSTGRESQL</type> <connectionInfo> <dataBase>postgres2</dataBase> <engineType>POSTGRESQL</engineType> <password>iserver</password> <server>192.168.17.116</server> <user>iserver</user> <connect>false</connect> <exclusive>false</exclusive> <openLinkTable>false</openLinkTable> <readOnly>false</readOnly> </connectionInfo> </datastore>
Where, datastoreType, name, type are the required parameters; in connectionInfo node, dataBase, password, server, user are required paramters.