Datasources can be set up to read information directly from your SQL Server, MySQL, PostgreSQL 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.
<IMAGE>
In this section:
| Table of Contents | ||||
|---|---|---|---|---|
|
...
- Server : Database server name
- Driver: Select server type (LocalMaps 2.0 supports SQL Server and Oracle Server datasources). , 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
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. Once saved, this will be added to the databases table.
| Info | ||
|---|---|---|
| ||
When connecting to a PostgreSQL or MySQL, there is an extra option to Enable SSL. |
SQL Server
To add a database connection to SQL Server,
MySQL
PostgreSQL
Oracle
Deleting a database datasourceDeleting a database datasource
When the are no databases in use, the delete button will be bold. When clicked, the following window will appear. After confirming yes, the database datasource will be deleted.
<IMAGE>
| Info | ||
|---|---|---|
| ||
Check out the Feature Queries section to see how you can view this information in your popups. |
...
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| hidden | true |
|---|
...