Edit

Set up your Adobe Analytics connection

This article outlines the steps to create an Adobe Analytics connection.

Supported authentication types

The Adobe Analytics connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Organizational account n/a √

Set up your connection for Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to Adobe Analytics using Power Query connectors. Follow these steps to create your connection:

  1. Check capabilities to make sure your scenario is supported.
  2. Complete prerequisites for Adobe Analytics.
  3. Get data in Fabric.
  4. Connect to Adobe Analytics data.
  5. Check limitations and considerations for any current restrictions.

Capabilities

  • Import

Prerequisites

Before you can sign in to Adobe Analytics, you must have an Adobe Analytics account (username/password).

Get data

To get data in Data Factory:

  1. On the left side of Data Factory, select Workspaces.

  2. From your Data Factory workspace, select New > Dataflow Gen2 to create a new dataflow.

    Screenshot showing the workspace where you choose to create a new dataflow.

  3. In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.

    Screenshot showing the Power Query workspace with the Get data option emphasized.

  4. In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.

    Screenshot of the Data Factory Choose data source page with the search box and the view more selection emphasized.

  5. If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.

    Screenshot of the Data Factory Choose data source page displayed after selecting view more, with the list of connectors.

Connect to Adobe Analytics data

To connect to Adobe Analytics data:

  1. Select Adobe Analytics from the Power Query Connect to data source page.

  2. Select Sign in to sign in to your Adobe Analytics account.

  3. In the Adobe Analytics sign-in window that appears, provide your credentials.

  4. Enter your password and select Continue.

  5. Once you successfully sign in, select Next.

  6. In the Choose data page, select the dimensions and measures you want to load, and then select Transform data to transform the data in Power Query Editor.

Limitations and considerations

You should be aware of the following limitations and issues associated with accessing Adobe Analytics data.

  • Adobe Analytics has a built-in limit of 50,000 rows returned per API call.

  • If the number of API calls exceeds four per second, a warning is issued. If the number exceeds five per second, an error message is returned. For more information about these limits and the associated messages, see Web Services Error Codes.

  • The API request timeout through adobe.io is currently 60 seconds.

  • The default rate limit for an Adobe Analytics Company is 120 requests per minute per user (the limit is enforced as 12 requests every 6 seconds).

  • This connector isn't supported with an on-premises data gateway. However the virtual network data gateway is supported.

Import from Adobe Analytics stops and displays an error message whenever the Adobe Analytics connector hits any of the API limits.

When accessing your data using the Adobe Analytics connector, follow the guidelines provided under the Best Practices heading.

For more guidelines on accessing Adobe Analytics data, see Recommended usage guidelines.

Set up your connection in a pipeline

Data Factory in Microsoft Fabric doesn't currently support Adobe Analytics in pipelines.

Related content

  • Last updated on