Skip to main content

Install Connect

Alteryx Connect is an add-on to Alteryx Server and must be installed on a separate node by a member of the Administrators group.

How to Install Alteryx Connect

  1. Review the System Requirements.

  2. Download the Alteryx Connect installation package and open the installer.

    • If Connect is not a downloadable product option for your account, ask your Sales representative to grant you access.

  3. Run the installer on your designated Connect Server.

  4. At the prompt, provide the destination folder for the application.

    • This drive should have at least 100 GB of free space.

  5. Enter the Port, typically 80 for HTTP, and select Next.

    • Port 80 is the default value.

  6. Review the license agreement, accept the license agreement, and select Next.

  7. Select Next to install Alteryx Connect.

    • After the installer is run, the AlteryxConnect and java.exe process will both be running in the Task Manager.

  8. Select Start the Alteryx Connect service now to start the Alteryx Connect service in the background.

    • After startup, you can access the Alteryx Connect instance at http://localhost.

    • You can start Connect at a later time manually in Services.

    • The window will indicate progress for starting the service, loading the configuration, loading content, and starting the service. This step takes approximately 20 minutes to complete.

  9. Select Next.

  10. Access the Alteryx Connect instance at http://localhost:80 is selected by default. Select Finish. The default administrator credentials are:

    • Username: admin

    • Password: Conn3ct!

  11. Enter the Username and Password and Sign In.

SSL Configuration

To make the communication between client and server much more secure, you can make Connect run on https protocol. During the setup process or if you have already installed Connect, you have the option to Configure SSL.

  1. Select Enable SSL on the initial setup screen. Select Next.

    If Connect is running, you will have to stop the service. Select the Stop service button and wait until another screen appears.

  2. On the next screen, check the Set up SSL box or leave it selected if already checked. Now you have two options:

    1. Upload existing certificate: To use an existing keystore or create new one, enter the following and select Next.

      • https port: the default is set to 443 unless you specify a different value.

      • Keystore password

        Anmerkung

        In case you want to import a password protected PFX certificate, the password must match the keystore's password, otherwise Tomcat won't be able to read it. If you used different values for 'srcstorepass' and 'deststorepass' parameters, you have to change the certificate password.

        keytool.exe -keypasswd -alias mypfx -keystore "c:\Program Files\AlteryxConnect\connect.keystore"

      • Keystore file name

      • Path to keystore. You also have the option to browse for the keystore.

      • Redirect http communication (optional): by default, you are redirected to use https if currently using http.

    2. Generate self-signed certificate: If you already have a keystore with a certificate, skip this step. To generate a self-signed certificate, enter the following and select Next.

      • Alias: name of the certificate in the keystore; can be random value.

      • Domain name: baseurl of your Connect instance; Domain name should match the URL you will use to access Connect.

      • Organizational unit

      • Organizational name

      • City or locality

      • State or province

      • Two letter country code

  3. To allow Connect to create a new signing request, enter the following and select Next. You can skip this step, e.g. if you are using already existing keystore with a certificate.

    1. Alias

    2. Certificate Signing Request (CSR) file

    3. Path to the file

  4. To Import certificates, you will need to manually enter the following information and select Next:

    1. Alias

    2. Certificate file

    3. Path to the file

  5. On the next page, leave the checkbox Start the Alteryx Connect service now selected and select Next.

  6. You will get a notification that the service is up and running. Select Next.

  7. On the next page, select Finish to open Connect in your browser.

For more detailed description how to set up SSL, see the Community article How To: Enable SSL in the Connect Installer. It is valid for versions 19.1 and higher.

Import a PFX Certificate

Currently, the Connect installer only supports self-signed certificates.

Prerequisites

  • Connect version 19.1 or higher.

  • PFX file containing both private key and public key.

  • If you do not have a PFX file, see Installation Troubleshooting.

Follow these steps to import a Certificate Authority (CA) signed certificate after enabling SSL with the Installer. Note that the values on your configuration might be different from those used here.

  1. Enable SSL as described in SSL Configuration or in the Community article How To: Enable SSL in the Connect Installer.

  2. Make sure your Connect instance is able to start and run using the https protocol.

  3. Open the command line and navigate to the folder containing keytool.exe:

    cd "c:\Program Files\AlteryxConnect\jre\bin"

    To manipulate a file in Program files, you might have to Run the Command Prompt as Administrator to have the elevated permissions.

  4. List all keys in your keystore:

    keytool.exe -list -keystore "c:\Program Files\AlteryxConnect\connect.keystore" -storepass password

    In the keystore you should see the private and public key.

    Anmerkung

    Before creating backup of the .keystore file and deleting the old certificate, it is necessary to stop Alteryx Connect service.

  5. To use a different private key, you have to remove the self-signed one first. Before removing, backup the keystore:

    copy "c:\Program Files\AlteryxConnect\connect.keystore" "c:\Program Files\AlteryxConnect\connect_bckp.keystore"

  6. Remove the PrivateKeyEntry using the alias as identification:

    keytool.exe -delete -alias mycert -keystore "c:\Program Files\AlteryxConnect\connect.keystore" -storepass password

  7. Verify the certificate has been removed by listing the content of the keystore as demonstrated in step 4.

  8. Import your PFX file.

    • The file is most likely password protected. Don't forget to change the value of 'srcstorepass' and 'deststorepass' parameters.

      Anmerkung

      The certificate password must match the keystore's password, otherwise  Tomcat will not be able to read it. If you used different values for 'srcstorepass' and  'deststorepass' parameters, you have to change the certificate password.

      keytool.exe -keypasswd -alias mypfx -keystore "c:\Program  Files\AlteryxConnect\connect.keystore"

      You have to provide: Keystore password, password for the certificate, and new  password for the certificate. Then re-type the new password for the certificate.

    • You might need to change the 'srcalias' as your key might have a different one. The easiest way would be to omit both 'srcalias' and 'destalias' and list keystore. The alias will likely remain the same.

      keytool.exe -importkeystore -srckeystore "c:\mycerts\pkcs12\ServerName.pfx" -srcstoretype pkcs12 -destkeystore "c:\Program Files\AlteryxConnect\connect.keystore" -deststoretype JKS -srcalias 1 -destalias mypfx -srcstorepass servername -deststorepass password

  9. Verify the certificate has been imported successfully. The type of the certificate has to be 'PrivateKeyEntry'.

  10. Restart the Alteryx Connect service. Connect will start using the new certificate from the PFX file.

It might be necessary to reopen web browser and clear browser cache to make new certificate works.

For more information, see the Community article How To: Import a PFX Certificate.

Configuration

  1. Enter the User name and Password and Sign In.

  2. Connect will then prompt you for initial configuration steps for:

    • Admin Password - enter a password for the default administrator

    • H2 Password - enter a password for the H2 user. For more information about Asset recommendation, Use CDN for JS & CSS Files, and other instance settings, visit the Settings help page.

    • Instance Settings - Enter the base URL to access the site. This may be the machine name or a DNS name.

    • SMTP Settings - Enter the SMTP Server Name, Protocol (SSL/TLS), default email to send mail as, and credentials to the SMTP server if required.

  3. Change the default administrator password:

    • Select your icon in the top-right of the screen and select My Profile.

    • In the Superadmin Information section, type the default administrator password and set and confirm a new password.

    • Select Save.

To load data asset metadata, configure users, and perform other administrative tasks, see Administer Connect.

Installation Troubleshooting

Wait at least ten minutes for the Alteryx Connect service to initialize before trying to access Alteryx Connect. If you still cannot access the URL, check to see if the Alteryx Connect service is running:

  1. Open the Windows Task Manager.

  2. Select the Services tab.

  3. Find AlteryxConnect in the list. Its status should be "Running". If it shows "Stopped", proceed to the next step.

  4. Select Services.

  5. In the list of services, select Alteryx Connect.

  6. Select Start.

Try the following:

  • Restart the AlteryxConnect 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 Restart.

  • Shut down and restart the Alteryx Connect server:

    1. Go to <installation_path>\bin. The default installation path is C:\Program Files\AlteryxConnect.

    2. Execute shutdown.bat, followed by startup.bat.