Configure a report destination for a Data Warehouse request
There are various configuration options available when creating a Data Warehouse request. The following information describes how to configure a report destination for the request.
For information about how to begin creating a request, as well as links to other important configuration options, see Create a Data Warehouse request.
-
We recommend using a cloud account or email for your report destination. Legacy FTP and SFTP accounts are available but are not recommended.
-
Any cloud accounts that you previously configured for Data Feeds or for importing Adobe Analytics classification data are available to use for Data Warehouse. However, any locations that are configured for importing classification data cannot be used.
-
Cloud accounts are associated with your Adobe Analytics user account. Other users cannot use or view cloud accounts that you configure.
To configure the destination where Data Warehouse reports are sent:
-
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 an account (and a destination on that account) has already been configured that you want to use as your report destination:
-
(Optional) If you are a system administrator, the Show all destinations option is available. Enable this option if you want to have access to all accounts and locations that were created by any user in the organization.
-
Select the account from the Select account drop-down menu.
Any cloud accounts that you configured for importing Adobe Analytics classification data from a cloud destination are shown here and can be used. However, any locations that are configured for importing classification data cannot be used. Instead, add a new destination as described below.
-
Select the destination associated with the account from the Select destination drop-down menu.
-
-
(Conditional) If you have not previously configured an account:
-
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 Specify the following information to configure an Amazon S3 Role ARN account:
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 Specify the following information to configure a Google Cloud Platform account:
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 Specify the following information to configure an Azure SAS account:
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 token in Azure Key Vault. To configure Azure SAS, you need to store an SAS token 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 Specify the following information to configure an Azure RBAC account:
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 Specify the following information to configure an email account:
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. -
-
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. -
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 Specify the following information to configure an Amazon S3 location:
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.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 Specify the following information to configure a Google Cloud Platform location:
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 Specify the following information to configure an Azure SAS location:
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 token 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 token to create files in your Azure container.If you want the SAS token to also overwrite files, make sure that the SAS token store has the
Delete
permission.For more information, see Blob storage resources in the Azure Blob Storage documentation.
accordion Azure RBAC Specify the following information to configure an Azure RBAC location:
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. -
Select Save.
You can now import data to the account and location that you configured.
-
-
Continue configuring your Data Warehouse request on the Report options tab. For more information, see Configure report options for a Data Warehouse request.
Legacy destinations
The following information provides configuration information for each of the legacy destinations:
FTP
Data warehouse data can be delivered to an Adobe or customer-hosted FTP location. Requires an FTP host, username, and password. Use the path field to place feed files in a folder. Folders must already exist; feeds throw an error if the specified path does not exist.
Use the following information when completing the available fields:
Account fields
-
Account name: The name of the FTP account.
-
Account description: A description of the FTP account.
-
Hostname: Enter the desired FTP destination URL. For example,
ftp.company.com
.note note NOTE Do not include ftp://
at the beginning of the URL. -
Username: Enter the username to log in to the FTP site.
-
Password and confirm password: Enter the password to log in to the FTP site.
Location fields
-
Location name: The name of the location on the FTP account where you want files sent.
-
Location description: A description of the location on the FTP account.
-
Directory path: The path to the location on the FTP account.
SFTP
SFTP support for data warehouse is available. Requires an SFTP host, username, and the destination site to contain a valid RSA or DSA public key. You can download the appropriate public key when creating the data warehouse destination.
Use the following information when completing the available fields:
Account fields
-
Account name: The name of the FTP account.
-
Account description: A description of the FTP account.
-
Hostname: Enter the desired SFTP destination URL. For example,
sftp.company.com
.note note NOTE Do not include sftp://
at the beginning of the URL. -
Username: Enter the username to log in to the SFTP site.
-
Use temporary file extensions during upload: When enabled, the
.part
file extension is used during the upload process. Keep this option enabled unless your SFTP server restricts file names from being changed after the upload completes. -
Public keys: Download the appropriate public key when creating the data warehouse destination.
Location fields
-
Location name: The name of the location on the SFTP account where you want files sent.
-
Location description: A description of the location on the SFTP account.
-
Directory path: The path to the location on the SFTP account.
For additional information about SFTP configuration, see Send Data Warehouse requests to SFTP servers.
S3
You can send warehouse data directly to Amazon S3 buckets. This destination type requires a Bucket name, an Access Key ID, and a Secret Key. See Amazon S3 bucket naming requirements within the Amazon S3 docs for more information.
The user you provide for uploading data warehouse data must have the following permissions:
- s3:GetObject
- s3:PutObject
- s3:PutObjectAcl
The following 16 standard AWS regions are supported (using the appropriate signature algorithm where necessary):
- us-east-2
- us-east-1
- us-west-1
- us-west-2
- ap-south-1
- ap-northeast-2
- ap-southeast-1
- ap-southeast-2
- ap-northeast-1
- ca-central-1
- eu-central-1
- eu-west-1
- eu-west-2
- eu-west-3
- eu-north-1
- sa-east-1
Azure Blob
Data warehouse support Azure Blob destinations. Requires a container, account, and a key. Amazon automatically encrypts the data at rest. When you download the data, it gets decrypted automatically. See Create a storage account within the Microsoft Azure docs for more information.