Datasources can be set up to read information directly from SQL Server, MySQL, PostGres or Oracle databases. By leveraging LocalMaps Data level integration you can consume and display related information directly within a maps popup, removing the need to write complex views or overnight processes.
In this section:
| Table of Contents | ||||
|---|---|---|---|---|
|
Adding a database datasource
- To add a new database, go to the database tab and click “Add Database”. The following Datasource dialogue box will appear:
- Server : Database server name
- Driver: Select server type (SQL Server, Oracle, PostGres or MySQL)
- Port: Port that the database server is running off (if applicable)
- UserID: User to connect to database
- Password: Password to connect to database
- Database: Select a database from dropdown
| Info | ||
|---|---|---|
| ||
For PostgreSQL or MySQL databases that have been set up with SSL Support, please tick the "Enable SSL" checkbox. |
2. You can then test if the database is valid by hitting the “Test” button. If the service is valid, a green tick will appear. If invalid, a red cross will appear and prevent the administrator from saving the database datasource until corrected.
3. Once saved, this will be added to the databases table.
...
| title | Note |
|---|
...
Deleting a database datasource
...