Skip to main content

Connect to Data

When you import data into the Alteryx Analytics Cloud, you are creating a reference to a source of data; the source is never touched. When the data is required for use, the Alteryx Analytics Cloud reads a sample of the source data into the application for your use. Data is read into the application through an object called a connection.

The following are the supported types of connection for the product:

  • Upload/Download: You can upload data directly from your local desktop. You can also save it locally on export.

  • Base storage layer: Your deployed instance of the product is connected to a base storage layer, where you can read sources and write your results.

  • Relational sources: You can read from database tables into the product.

Locate Connections

You already have a set of connections that you can use. Connections can be either read-only or read-write.

  1. From the Landing page, select the Connections from the top navigation bar.

  2. The currently available Connections are displayed.

On the Import Data page, your list of available connections are displayed in the left navigation bar.

Use Connections

Read-Only

  1. On the Import Data page, select 1 of the available connections.

  2. Navigate through the connection to select the asset to import.

  3. Select the object and select Open.

  4. On the Import Data page, review the settings of the asset in the card in the right panel. Make updates as needed.

Write

You write results through a connection by specifying a set of settings.

  1. On the Run Job page, select Add Publishing Action.

  2. On the left navigation bar, select the connection.

  3. Specify the settings for the publishing action.

  4. Run the job.

  5. When it successfully completes, the specified results are published through the selected connection.

Create Connection

Note

Some connections require additional configuration outside of the application.

When a new connection is created, it is initially available only to you.

Prerequisites:

Before you create a new connection, please verify the following:

  • On the datastore, you have read and (optionally) write locations.

  • You have credentials to use to connect to this datastore. These credentials have permissions on your read/write locations.

  • Some datastores require a special connection string, which must be inserted as part of the connection object.

  • For more information, go to Create Connection Window.

Read-only:

  1. On the Import Data page, select New from the left navigation bar.

  2. In the Create Connection window, specify the parameters of the connection.

Read-write:

  1. On the Connections page, select Create Connection.

  2. Select the connection category or search for a specific connection to create.

  3. If a connection is grayed out:

    1. It might already exist. Some connections types permit only one globally available connection.

    2. It might not be supported in your product.

    3. It might be read-only.

  4. Select the name of the connection.

  5. In the Create Connection window, specify the parameters of the connection.

Delete Connection

Note

You can delete a connection only if you are an admin or the connection owner, and the connection is not used to import any current datasets.

Steps:

  1. On the Connections page, locate the connection to remove.

  2. In the context menu, select Delete....

  3. The connection is deleted.