Connecting from pgAdmin
Clients like pgAdmin can connect to Bitbucket ODBC data sources as virtual PostgreSQL databases. This section describes how to configure ODBC remoting as a virtual PostgreSQL database in pgAdmin.
Configure SQL Gateway
To create a virtual MySQL database in the SQL Gateway administration tool:- Configure and start the proxying service on the Services tab.
- Configure database users on the Users tab.
- Access services hosted behind a firewall by configuring SSH Tunnel.
Connect to the Database
Open pgAdmin and complete the following steps.
- In the main menu, right-click Servers, then click Register > Server. This opens the "Register - Server" window.
- On the General tab, set the following:
- Name: a name for your new server.
- Server group: the server group you want to use to contain your new server.
- On the Connection tab, set:
- Host name/address: the network address where your SQL Gateway service is running. If you're running pgAdmin and SQL Gateway on the same machine, set this to localhost.
- Port: Set this to the port on which your SQL Gateway service is running. You can find the port used by your service in the Local Port column on SQL Gateway's Services tab.
- Maintenance database: The catalog name of your SQL Gateway service. You can find this value in the sys_catalogs system table.
- Username: The username of a database user from SQL Gateway's Users tab.
- Password: The password associated with the specified username.
- Click Save. The virtual database is added to your list of Servers.
See Executing Queries for instructions regarding querying the virtual database server.