Connecting with pgAdmin

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:

Configuring pgAdmin

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 opens.
Type an appropriate name into the Name field, for example Verizon Connect 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 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, you might want to leave this unchecked.
Click OK. The dialog will close and a new database connection will be established. The server will be 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 will 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 has been selected, the SQL button on the menu will activate.
Click the SQL button on the main menu bar. The Query window will open.
Type a SQL query into the Query pane, then press the green 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 will be executed against the database, and the results returned shown in the Data Output tab of the lower Output pane. If the SQL query fails, an error message will be displayed.