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 | ||||
|---|---|---|---|---|
|
...
- To add a new database, go to the database tab and click “Add Database”. The following Datasource dialogue box will appear“Add Database”. Enter the following information into the dialogue box:
- Server : Database server name
- Driver: Select server type (SQL Server, Oracle, PostGres or MySQL)
- Port: Port that the database server is running off (enter only if applicable)
- UserID: User to connect to database
- Password: Password to connect to database
- Database: Select a database from dropdownfrom drop-down
| Info | ||
|---|---|---|
| ||
For PostgreSQL or MySQL databases that have been set up with SSL Support, please tick the "Enable SSL" checkbox. |
...