The free pgAdmin application is a powerful development tool when connected to the analytics server, allowing the structure of individual databases to be explored in a simple tree view, and providing live information about the configuration of tables and columns.
To connect to the analytics server with pgAdmin, follow the steps below:
- Launch the pgAdmin application. This free application is available for download from http://www.pgadmin.org/download/.
- Click File | Add Server from the main application menu. The New Server Registration dialog box opens.
- Type an appropriate name into the Name field, for example 'Telogis Cube Server'.
- Type 'sql.telogis.com' into the Host field and '8088' into the Port field.
- Type the username and password provided to you into the Username and Password fields. If you have not been provided with these credentials, request these from your Verizon Connect administrator.
- Select the Store password checkbox if you want pgAdmin to remember the password. If security is a concern, or the computer is used by more than one person, it is best practice to leave the clear the checkbox.
- Click OK. The dialog box closes and a new database connection is established. The server is added to the pgAdmin object tree.
- Click the expand icon to the left of the server name to view the content of the server. Access the analytics server structure by navigating down the tree view to Databases | telogis | Schemas. Within Schemas you can see the customer zones your account has permission to view. To view the structure of individual tables, navigate to Databases | telogis | schemas | [zone] | Tables.
Querying the Analytics Server in pgAdmin
Once you have configured a connection to the analytics server in pgAdmin, you can run SQL queries against the server using the steps below:
- Select a database in the object browser. These are nested below Databases in the tree view. Once a database or any of its child nodes is selected, the SQL button on the menu is activated.
- Click the SQL button on the main menu bar. The Query window opens.
- Type a SQL query into the Query pane, then press the Execute query button on the menu bar (see the Using the REST API and Driver Scorecards sections for more information about structuring SQL queries).
- The SQL query is executed against the database, and the results returned are displayed in the Data Output tab of the lower Output pane. If the SQL query fails, an error message is displayed.