Configure a report destination for a Data Warehouse request

If you haven’t already, begin creating a request in Adobe Analytics by selecting Tools > Data Warehouse > Add.

For additional details, see Create a Data Warehouse request.

On the New Data Warehouse request page, select the Report destination tab.

(Conditional) If a cloud account (and a destination on that account) has already been configured in Adobe Analytics, you can use it as your report destination:

1. Select the account from the Select account drop-down menu.

   Any cloud accounts that you configured in any of the following areas of Adobe Analytics are available to use:

   • When importing Adobe Analytics classification data, as described in Schema.

     However, any locations that are configured for importing classification data cannot be used. Instead, add a new destination as described below.

   • When configuring accounts and locations in the Locations area, as described in Configure cloud import and export accounts and Configure cloud import and export locations.

2. Select the destination associated with the account from the Select destination drop-down menu.

(Conditional) If you don’t have access to a cloud account that is already configured in Adobe Analytics, you can configure one:

1. Select Add account, then specify the following information:

   table 0-row-2 1-row-2 2-row-2 3-row-2
   Field	Function
   Account type	Select your cloud account type. We recommend having a single account for each account type, with multiple locations as needed within that account. After choosing an account type, fields specific to that account type appear.
   Account name	Specify a name for the account. This name appears when creating a location.
   Account description	Provide a short description of the account to help differentiate it from other accounts of the same account type.

   For configuration instructions, expand the section below that corresponds to the Account type that you selected.

   Use any of the following account types when configuring a report destination. For configuration instructions, expand the account type. (Additional legacy destinations are also available, but are not recommended.)

   accordion
   Amazon S3
   To configure an Amazon S3 Role ARN account, specify the following information: table 0-row-2 1-row-2 2-row-2 layout-auto Field Function Role ARN You must provide a Role ARN (Amazon Resource Name) that Adobe can use to gain access to the Amazon S3 account. To do this, you create an IAM permission policy for the source account, attach the policy to a user, and then create a role for the destination account. For specific information, see this AWS documentation. For information about how to set up the permission of the bucket, see the article How can I provide cross-account access to objects that are in Amazon S3 buckets? in the Amazon knowledge center. User ARN The User ARN (Amazon Resource Name) is provided by Adobe. You must attach this user to the policy you created.

   accordion
   Google Cloud Platform
   To configure a Google Cloud Platform account, specify the following information: table 0-row-2 1-row-2 layout-auto Field Function Project ID Your Google Cloud project ID. See the Google Cloud documentation about getting a project ID.

   accordion
   Azure SAS
   To configure an Azure SAS account, specify the following information: table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 layout-auto Field Function Application ID Copy this ID from the Azure application that you created. In Microsoft Azure, this information is located on the Overview tab within your application. For more information, see the Microsoft Azure documentation about how to register an application with the Microsoft identity platform. Tenant ID Copy this ID from the Azure application that you created. In Microsoft Azure, this information is located on the Overview tab within your application. For more information, see the Microsoft Azure documentation about how to register an application with the Microsoft identity platform. Key vault URI The path to the SAS URI in Azure Key Vault. To configure Azure SAS, you need to store an SAS URI as a secret using Azure Key Vault. For information, see the Microsoft Azure documentation about how to set and retrieve a secret from Azure Key Vault. After the key vault URI is created: Add an access policy on the Key Vault in order to grant permission to the Azure application that you created. Make sure the Application ID has been granted the Key Vault Certificate User built-in role in order to access the key vault URI. For more information, see Azure built-in roles. For information, see the Microsoft Azure documentation about how to assign a Key Vault access policy. Key vault secret name The secret name you created when adding the secret to Azure Key Vault. In Microsoft Azure, this information is located in the Key Vault you created, on the Key Vault settings pages. For information, see the Microsoft Azure documentation about how to set and retrieve a secret from Azure Key Vault. Secret Copy the secret from the Azure application that you created. In Microsoft Azure, this information is located on the Certificates & secrets tab within your application. For more information, see the Microsoft Azure documentation about how to register an application with the Microsoft identity platform.

   accordion
   Azure RBAC
   To configure an Azure RBAC account, specify the following information: table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto Field Function Application ID Copy this ID from the Azure application that you created. In Microsoft Azure, this information is located on the Overview tab within your application. For more information, see the Microsoft Azure documentation about how to register an application with the Microsoft identity platform. Tenant ID Copy this ID from the Azure application that you created. In Microsoft Azure, this information is located on the Overview tab within your application. For more information, see the Microsoft Azure documentation about how to register an application with the Microsoft identity platform. Secret Copy the secret from the Azure application that you created. In Microsoft Azure, this information is located on the Certificates & secrets tab within your application. For more information, see the Microsoft Azure documentation about how to register an application with the Microsoft identity platform.

   accordion
   Email
   To configure an email account, specify the following information: table 0-row-2 1-row-2 Field Function Recipients Email notifications can be sent to specific users when the report is sent. Specify a single email address or a comma-separated list of email addresses.

2. Select Add location, then specify the following information:

   table 0-row-2 1-row-2 2-row-2 3-row-2
   Field	Function
   Name	The name of the location.
   Description	Provide a short description of the account to help differentiate it from other accounts of the same account type.
   Location account	Select the location account that you created in Add an account.

3. In the Location properties section, specify information specific to the account type of your location account.

   For configuration instructions, expand the section below that corresponds to the Account type that you selected previously.

   accordion
   Amazon S3
   To configure an Amazon S3 location, specify the following information: table 0-row-2 1-row-2 2-row-2 layout-auto Field Function Bucket name The bucket within your Amazon S3 account where you want Adobe Analytics data to be sent. Ensure that the User ARN that was provided by Adobe has the S3:PutObject permission in order to upload files to this bucket. This permission allows the User ARN to upload initial files and overwrite files for subsequent uploads. Bucket names must meet specific naming rules. For example, they must be between 3 to 63 characters long, can consist only of lowercase letters, numbers, dots (.), and hyphens (-), and must begin and end with a letter or number. A complete list of naming rules are available in the AWS documentation. Key prefix The folder within the bucket where you want to put the data. Specify a folder name, then add a backslash after the name to create the folder. For example, folder_name/

   accordion
   Google Cloud Platform
   To configure a Google Cloud Platform location, specify the following information: table 0-row-2 1-row-2 2-row-2 layout-auto Field Function Bucket name The bucket within your GCP account where you want Adobe Analytics data to be sent. Ensure that you have granted either of the following permissions to the Principal provided by Adobe: roles/storage.objectCreator: Use this permission if you want to limit the Principal to only create files in your GCP account. Important: If you use this permission with scheduled reporting, you must use a unique file name for each new scheduled export. Otherwise, the report generation will fail because the Principal does not have access to overwrite existing files. roles/storage.objectUser: Use this permission if you want the Principal to have access to view, list, update, and delete files in your GCP account. This permission allows the Principal to overwrite existing files for subsequent uploads, without the need to auto-generate unique file names for each new scheduled export. For information about granting permissions, see Add a principal to a bucket-level policy in the Google Cloud documentation. Key prefix The folder within the bucket where you want to put the data. Specify a folder name, then add a backslash after the name to create the folder. For example, folder_name/

   accordion
   Azure SAS
   To configure an Azure SAS location, specify the following information: table 0-row-2 1-row-2 2-row-2 layout-auto Field Function Container name The container within the account you specified where you want Adobe Analytics data to be sent. Key prefix The folder within the container where you want to put the data. Specify a folder name, then add a backslash after the name to create the folder. For example, folder_name/ Make sure that the SAS URI store that you specified in the Key Vault secret name field when configuring the Azure SAS account has the Write permission. This allows the SAS URI to create files in your Azure container. If you want the SAS URI to also overwrite files, make sure that the SAS URI store has the Delete permission. For more information, see Blob storage resources in the Azure Blob Storage documentation.

   accordion
   Azure RBAC
   To configure an Azure RBAC location, specify the following information: table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto Field Function Container name The container within the account you specified where you want Adobe Analytics data to be sent. Ensure that you grant permissions to upload files to the Azure application that you created earlier. Key prefix The folder within the container where you want to put the data. Specify a folder name, then add a backslash after the name to create the folder. For example, folder_name/ Make sure the Application ID that you specified when configuring the Azure RBAC account has been granted the Storage Blob Data Contributor role in order to access the container (folder). For more information, see Azure built-in roles. Account name The Azure storage account.

Continue configuring your Data Warehouse request on the Report options tab. For more information, see Configure report options for a Data Warehouse request.