Manage In-DB Connections

Create and manage your in-database connections from a central location. Use the Manage In-DB Connections window to view existing in-database connections and add new in-database connections.

There are two ways to get to the Manage In-DB Connections window:

  • Add a Connect In-DB tool, and click Connection Name > Manage Connections in the Configuration window. See Connect In-DB Tool.
  • Click Options > Advanced Options > Manage In-DB Connections.
ClosedCreate a new In-DB connection
  1. Click Data Source and select a source. See In-Database Overview.

    2. Generic ODBC Option

    From the Connect In-DB tool, you can select the Generic ODBC option to attempt a connection to an unsupported data source. This option does not guarantee a successful connection to unsupported data sources; however, data sources that are similar to Microsoft SQL Server have the best chance of success.

  2. Click Connection Type and select type.
    • User: Create a connection that only you can use.
    • System: Create a connection that can be shared. Open Alteryx Designer as an administrator on your computer. This option is only for Designer Admin.
    • File: Saves a database connection as an .indbc file so it can be packaged with a workflow. If this option is selected, a Connection File path location must be specified in order to save the file.
  3. Click Connections and select an existing connection from the list, or click New.
  4. In Connection Name, type a name for the connection.
  5. Click Password Encryption and select an encryption option:
    • Hide: Hide the password using minimal encryption.

      • If you plan to schedule this workflow to run on any machine other than your computer, select Hide. See Schedule Workflows.

    • Encrypt for Machine: Any user on the computer will be able to fully use the workflow.
    • Encrypt for User: The logged in user can use the workflow on any computer.
    • Allow Decryption of Password: Decrypts the password and passes it in the metadata. This option is only used in conjunction with In-DB predictive tools.
  6. On the Read tab, click Driver and select an option or leave as default.
  7. Click the Connection String drop-down arrow and select New database connection. For Oracle OCI and SQL Server ODBC connections, you can alternately select a saved or recent data connection.

    8. See ODBC and OLEDB Database Connections for more information on creating ODBC and OLEDB connections. See Supported Data Sources and File Formats for more information on a specific data platform.

  8. Click the Write tab.
  9. Click Driver and select a driver or leave as default.
  10. In Connection String, type or paste a connection string. For Oracle OCI and SQL Server ODBC connections, you can alternately select a saved or recent data connection.
    11. ClosedSQL Server connection considerations

    When using SQL Server Authentication, enter passwords without SQL formatting standards.

    • We do not support three or more consecutive pipe characters in passwords.
    • Password treatment occurs automatically, so you should not enclose a password in curly brackets or escape any right curly brackets used as a character in a password.
    ClosedOracle connection considerations

    Enter passwords without Oracle formatting standards.

    • Do not use double quotes as password characters.
    • You can choose to enclose the password in double quotes.
    ClosedHDFS connections

    To connect to HDFS:

    1. Click the Connection String drop-down arrow and select New HDFS Connection.
    2. Select HTTPFS, WebHDFS, or Knox Gateway server configuration.

      3. If you are using Knox Gateway with Apache Spark, select Override default Namenode URL.

    3. In Host, type the Hadoop server URL or IP address.
    4. In Port, leave the default port number which is based your server configuration selection, or type a port number.
    5. By default, URL is based on Host. Type a different URL, if desired.
    6. By default, Temp Directory, is /tmp. Type a different location for the temporary directory to write to, if desired.
    7. Type a user name in User Name and a password in Password. Required credentials vary based on the cluster setup.
        • httpfs: A user name is required, but it can be anything.
        • webhdfs: A user name is not required.
        • Knox Gateway: A user name and password are required.

          • Use a trusted certificate when configuring Knox authentication. Alteryx does not support self-signed certificates.

    8. Click Kerberos and select an authentication option for reading and writing to HDFS.
      • None: No authentication is used.
      • Kerberos MIT: Alteryx will use the default MIT ticket to authenticate with the server. You must first acquire a valid ticket using the MIT Kerberos Ticket Manager.
      • Kerberos SSPI: Alteryx will use Windows Kerberos keys for authentication, which are obtained when logging in to Windows with your Windows credentials. The User Name and Password fields are therefore not available.

        • The option you choose depends on how your IT admin configured the HDFS server.

    9. (Apache Spark-only) Select Override default Namenode URLto override the Namenode URL and enter a host and port number if using Knox Gateway, or if the namenode server is running on a different computer than the httpfs or webhdfs server.
    10. (Recommended) Click Test to test the connection.
    11. Click OK.

    See Hadoop Distributed File System for more information.

  11. Click OK .
  12. If you are connecting to a database with multiple tables the Choose Table or Specify Query window opens. Click the Tables tab. See Choose Table or Specify Query Window.
  13. Select a table and click OK.
ClosedEdit or delete an In-DB connection
  1. In the Manage In-DB Connection window, click Data Source and select a source.

    Generic ODBC Option

    From the Connect In-DB tool, you can select the Generic ODBC option to attempt a connection to an unsupported data source. This option does not guarantee a successful connection to unsupported data sources; however, data sources that are similar to Microsoft SQL Server have the best chance of success.

  2. Click Connections and select an existing connection.
  3. Edit connection details, or click Delete to delete the connection.
  4. Click OK.

See Connect In-DB Tool to learn how to create and manage In-DB connections and use them in a workflow. See Supported Data Sources and File Formats for more on the data platforms and databases you can connect to.

Alteryx also supports standard database connections. See Manage Data Connections.

 

Alteryx Help & Documentation | Alteryx Release Notes

Alteryx.com | Community | Customer Support | Documentation Feedback

Copyright © 2019 | Alteryx, Inc. | Alteryx Designer | 2019.1