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 | ||||
|---|---|---|---|---|
|
...
- 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 drop-down
...
| title | Note |
|---|
- Enable SSL: This presented for PostgreSQL or MySQL databases only. If your database has been set up with SSL Support, please tick the "Enable SSL" checkbox.
- Database: Select a database from drop-down
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. For example, a MySQL Database connection might look similar to the below.
.png?version=1&modificationDate=1533182136019&cacheVersion=1&api=v2&height=400 "Click to enlarge image")
3. Once saved, this will be added to the databases table.
...