Howto for Connecting to Spatial Databases
This section describes steps to test database connections of iDelve to third party databases using the iDelve Dataset Manager Toolkit.
Launch the iDelve Dataset Manager Toolkit by running the following command:
/idelve/datasetManager/runmanager.bat
Go to the File Menu and choose the New option.
Enter “test” as a dataset name:
Click on the “Add” button located in the row of buttons at the bottom:
Select Spatial Database as the layer type and enter a name “test”:
The following dialogue will appear:
The following are examples values for some database types:
| Database Type | Fields |
| PostGIS | SDB Adapter: idelve.api2.server.sdb.PostGisAdapter |
| Server: jdbc:postgresql://localhost/idelve |
| Port: 1 |
| Database: org.postgresql.Driver |
| User: postgres |
| Password: P0stgr%s |
| ArcSDE | SDB Adapter: idelve.api2.server.sdb.SdeAdapter |
| Server: pkg301.dmz.localnet |
| Port: 60701 |
| Database: SDE |
| User: SDE |
| Password: SDE |
| MySQL | SDB Adapter: idelve.api2.server.sdb.MysqlAdapter |
| Server: jdbc:mysql://localhost/original |
| Port: 1 |
| Database: org.gjt.mm.mysql.Driver |
| User: idelve |
| Password: idelve |
Click on the “Sources” button in the row of buttons at the bottom:
Click “Add” button from the row of buttons at the bottom:
Click on the drop-down arrow under the layer. If a list of layers is displayed, this confirms that the database connection is valid:
Note: If the table structure has changed in the future, the existing source needs to be removed and added again. iDelve only reads the description of the table when it is added as a source. One layer may have more than one source table.
Once the layer has been added as a source, the geometry field & ID field, and checksum type & field can be set:
