community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Knowledge Base

Definitive answers from Connect experts.

How To: Connect to the H2 Console

Moderator
Moderator
Created on

How To: Connect to the H2 Console

 

Connect has an interactive console for the H2 database that allows administrators to browse the database and execute commands. Follow the below steps to enable and connect to the console.

 

Prerequisites

 

  • Alteryx Connect

 

Procedure

 

    1. Follow steps 1-6 under Enable access to the Connect database found on the Review Connect Usage Information Help page
    2. Navigate to http://localhost:8082 on the Connect Server
      1. If you have the firewall open, you can access this from another machine using the IP or the hostname in place of localhost (i.e. http://hostname:8082)
    3. Fill in the JDBC URL and the Password
      OzeHIJK.png 
      1. For the JDBC URL, enter the value for the Master DB JDBC string found in the System Info section of the Connect Administration Console
      2. The database password is set by the Connect Administrator during installation. Your Administrator can reset the password in the Connect Console under Connect Configuration > H2 Password
  1. Click the Test Connection button
    1. You should see 'Test Successful'. If not, please double-check your connection information above
  2. Click the Connect button to enter the H2 Console
  3. A successful connection will show the console with the below schema (shows as folders on the left)
    h2console2.png

 

Common Issues

 

Spoiler
I don't see the STD_XFORMS database schema
You have an invalid JDBC connection string - please confirm your JDBC URL found in the System Info section of the Administration Console

  

Additional Resources