Databases

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:

Adding a database

1. To add a new database, go to the database tab and click “Add Database”. The following Datasource dialogue box will appear:

• Server : Database server name
• Driver: Select server type (SQL Server, 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

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.

3. Once saved, this will be added to the databases table.

Deleting a database datasource

1. When the are no databases in use, the delete button will be bold. When clicked, the a confirmation window will appear. After confirming yes, the database datasource will be deleted.

Related articles