Review Connect Usage Information

Version:
Current
Last modified: July 07, 2020

Administrators can use Alteryx Designer to connect to the Alteryx Connect H2 database to obtain Connect usage information and statistics. 

Enable Access to the Connect Database

By default, access to the Connect database is restricted. To enable it:

  1. Verify that ports 8082 and 9092 are open on the server where Alteryx Connect is deployed.
  2. Stop the Alteryx Connect service:
    1. Open the Windows Task Manager.
    2. Select the Services tab.
    3. Select Services.
    4. In the list of services, select Alteryx Connect.
    5. Select Stop and leave the Services window open.
  3. In a text editor, open alteryx_connect.properties from the <installation_path>\ac_work directory.
    The default installation path is C:\Program Files\AlteryxConnect.
  4. Add the following new line:

    allow.db.console=true

  5. Save the file.
  6. In the Services window, select Start to restart the Alteryx Connect service.

    Create a New System DSN Connection

    1. Download and install the PostgreSQL ODBC driver (psqlodbc_09_02_0100-x64.zip) from the PostgreSQL downloads page.
    2. In Windows, open the ODBC Data Source Administrator (64-bit) and create a new system DSN connection with the following settings:
      • Data Source: H2
      • Description: H2
      • Database: ac_data
      • SSL Mode: disable
      • Server: The Alteryx Connect server name or IP address.
      • Port: 5435
      • User Name: sa
      • Password: the password set in Connect Configuration. For more information, see Administration Console.

      Select Test to ensure a successful connection. If the test fails, check the above settings.

    Connect to the H2 Database

    1. Open Alteryx Designer.
    2. Drag an Input Data tool onto the canvas.
    3. In the Configuration window, select the Connect a File or Database drop-down arrow and select Other Databases > ODBC.
    4. Select the H2 connection you just created.
    5. In the Choose Table or Specify Query window > Visual Query Builder, expand STD_XFORMS and double-click a table (for example, EVENT_MONITOR, EVENT_AUDIT).
    6. Connect a Browse tool to the Input Data tool.
    7. Run the workflow and select the Browse tool to view the data.
    Was This Helpful?

    Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.