There are several ways to test your services hosted on your local DaCHS server. Here is a quick guide for this.

With a web browser

DaCHS provides a web interface to visualize and query your published tap services.

Open http://127.0.0.1 (or http://127.0.0.1:<port_numer> if you don't use the port 80).

Note: Several links may not be updated : refresh with ctr+F5, or even open a private session (Ctrl + Maj + P on Firefox).

You can check service metadata by clicking on the numerous tables link.

Or/and click on the link form-base ADQL (also accessible from the sidebar) and type an SQL query, for instance (replace "transplanet" by your actual service name):

select top 10 * from transplanet.epn_core

With TOPCAT

TOPCAT is an interactive graphical viewer and editor for tabular data and can be used to visualize an query your published services. It is supported on all OS and can be downloaded here.

1/ Click on the Open new table button on the icon menu:

2/ On the new window, click on Query remote databases using sql-like language button on the icon menu:

3/ From the Select service tab, fill the TAP URL field (on the bottom) with http://127.0.0.1/__system__/tap/run/tap (or http://127.0.0.1:<port_number>/__system__/tap/run/tap) and click on Use service button:

4/ Take a look to the DaCHS tables: do you see the <service_name>.epn_core table? Good. Now try to type an ADQL query on the bottom field, for example (again):

select top 10 * from transplanet.epn_core

5/ On the new window, click on the last element of the left panel : you can now visualize the results of your query.

With PGAdmin

Installation

pgAdmin is a postgreSQL client, it aims to provide a graphical interface to view and manage your databases. We will use this tool on section Setting up an EPN-TAP service. If you don't want to install pgAdmin on you computer, you can however use psql commands instead.

First, install pgAdmin on your host machine. If you are on Debian based distribution:

Compiled sources are also available for MacOS and Windows.

Configuration

Check for the gavo user password by typing on the DaCHS server:

Now start pgAdmin, then click on Add a connection to a server (power socket icon) and fill the fields as the following:

Usage

Now you should be able to see your database:

You can query them by clicking on the "SQL" button on the tool bar.

With the VESPA client

The VESPA client is a web site that allow you to query epn-tap services.

First scenario: your service is published to a registry:

• tab All VO (main page);
• eventually, fill filter fields as your needs (not required);
• then click on Submit;
• click on your service on the list.

Second scenario: your service is not published to a registry (but online):

• tab Custom ressource;
• fill the URL field: for instance, http://cdpp-epntap.irap.omp.eu/__system__/tap/run/tap;
• fill the schema field: for instance, transplanet;
• eventually, fill some other filter fields (not required);
• click on your service on the list.

Since the VESPA Client is open-source, it is also possible to download it and run a local instance of the client in order to query your local services. You can contact Cyril Chauvin from OBSPM for further information about how to install it.