Datasources can be set up to read information directly from your SQL Server, MySQL, PostgreSQL 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.
| Info | ||
|---|---|---|
| ||
Check out the Feature Queries section to see how you can view this information in your popups. |
<IMAGE>
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.
< IMAGE>
- Server : Database server name
- Driver: Select server type (LocalMaps 2.0 supports SQL Server and Oracle Server datasources).
- 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 database from dropdown
| 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,
...
Deleting a database datasource
| Info | ||
|---|---|---|
| ||
Check out the Feature Queries section to see how you can view this information in your popups. |
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...