This taken from our getting started guide, specifically: “Working with SQL Datasources“. It displays the authors table from the public Rfam database.
Preview
Datasource
Field | Value |
|---|
Name | Rfam
|
Type | MySQL 5
|
JDBC URL | jdbc:mysql://mysql-rfam-public.ebi.ac.uk:4497/Rfam
|
User | rfamro
|
Password | No password - leave blank |
Query
Field | Value |
|---|
Name | Rfam Authors
|
Datasource | Rfam
|
SQL Statement |
SELECT author_id, name, last_name
FROM author
SQL
|