Welcome to the Alteryx Knowledge Base

1. Follow the steps to Enable Access to the Connect Database
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

 

 

1. 1. For the JDBC URL:
      1. Log in to the Connect web UI as the Administrator
      2. Click on the Administrator's profile icon at the top-right of the screen, then click Administration
      3. On the Administration Console page, go to Settings > System Info
      4. Use the value of the Master DB JDBC String
   2. For Password, enter the H2 database password. This password would have been set by the Connect Administrator during installation. The Administrator can reset the password by going to the Administration Console page following the same instructions i. to ii. above, then go to Password Settings > H2 Password and change the password there
2. Click the Test Connection button
   1. You should see 'Test Successful'. If not, please double-check your connection information above
3. Click the Connect button to enter the H2 Console
4. A successful connection will show the console with the below schema (shows as folders on the left)

 

 

Common Issues

 

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.