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.
<IMAGE>
In this section:
Adding a database
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
Note
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 datasource
Want to know more?
Check out the Feature Queries section to see how you can view this information in your popups.
Related articles
Filter by label
There are no items with the selected labels at this time.