Adobe Analytics Data Feed Setup Guide

The way Fivetran connects to your Adobe Analytics Data Feed account varies based on the cloud file storage service you use. Follow the setup instructions for your storage service.

Prerequisites

To connect your Adobe Analytics Data Feed account to Fivetran, you need:

• An active Adobe Analytics account

• Data feeds that export data into one of the following cloud file storage services:

  • FTP/FTPS
  • SFTP
  • Amazon S3
  • Azure Blob Storage

Create data feed

1. Log in to Adobe Experience Cloud using your Adobe ID credentials.

2. Click the 9-square icon, then click the Analytics logo.

3. In the navigation bar, click Admin > Data feeds.

4. Click Add. A new page appears with three main categories: Feed Information, Destination, and Data Column Definitions.

5. Provide the Feed Information field details:

   • Enter a Name of the data feed.
   • Select the Report suite.
   • Enter the Email when complete address.
   • Select the Feed interval (hourly or daily).
   • Select the Delay processing value (No Delay to 120 minutes).
   • Select the Start & end dates.
   • (Optional) Enable Continuous Feed.

6. Enter the Destination field details:

   • Type: Select your storage service type - FTP / SFTP / S3 / AZURE BLOB:

     • If you selected FTP/FTPS or SFTP, enter the Host address. For example, ftp://ftp.sample.com.
     • If you selected S3, enter the Bucket name.
     • If you selected Azure Blob, enter the Container name.

   • Path

   • Enter your storage service credentials:

     • If you selected FTP/FTPS or SFTP, enter the Username to log in to the FTP/SFTP site. Enter your Password and confirm the password.
     • If you selected S3, enter your Access Key. Enter your Secret Key and confirm the key.
     • If you selected Azure Blob, enter your Account name. Enter your Key and confirm the key.

7. Provide the Data Column Definitions:

   • In the Select Column Template drop-down menu, choose your template.
   • (Optional) Enable Remove Escaped Characters.
   • Select Compression format (for example, Gzip).
   • Packaging type: Select Multiple files.

     NOTE: Fivetran only supports data feeds with multi-file packaging.

   • Manifest: Select Manifest File.

8. Click Save.

NOTE: For more information about creating a data feed and associated fields, see Adobe's Create or edit a data feed documentation.

FTP / FTPS setup instructions

1. In the connector setup form, enter your Destination schema name.

2. In the Source drop-down menu, select FTP.

3. Enter the following information:

   • (Optional) Folder Path
   • Host
   • Port
   • User
   • Password

   NOTE: If you don't provide a folder path, Fivetran will search for data feeds present in the root directory.

4. (Optional) Set the Should Split Arrays toggle to OFF if you don't want to split multivalued attributes into child tables.

   NOTE: By default, Fivetran splits array elements and syncs the multivalued attributes into child tables.

5. (Optional) Set the Secure FTP toggle to ON if you want Fivetran to connect using FTPS (File Transfer Protocol over SSL/TLS).

6. Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.

SFTP setup instructions

1. In the connector setup form, enter your Destination schema name.

2. In the Source drop-down menu, select SFTP.

3. Enter the following information:

   • (Optional) Folder Path
   • Host
   • Port
   • User

   If you don't provide a folder path, Fivetran will search for data feeds present in the root directory.

4. (Optional) Set the Should Split Arrays toggle to OFF if you don't want to split multivalued attributes into child tables.

   By default, Fivetran splits array elements and syncs the multivalued attributes into child tables.

5. (Optional) To log in using a key pair, set the Log in with key pair? toggle to ON and add the Fivetran public key to the /.ssh/Authorized_keys file in the SSH account you want to use.

6. Enter your password if you are not using a key pair to log in.

7. Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.

Amazon S3 setup instructions

Begin Fivetran configuration

1. In the connector setup form, enter your Destination schema name.

2. In the Source drop-down menu, select S3.

3. Find the automatically-generated External ID and make a note of it. You will need it to create an IAM role in AWS.

   NOTE: The automatically-generated External ID is tied to your account. If you close and re-open the setup form, the ID will remain the same.

Create AWS IAM policy and role

1. Create an IAM Policy for Fivetran:

   i. Open your Amazon IAM console.

   ii. Go to Access management > Policies, then select Create policy.

   iii. In the Create policy window, go to the JSON tab.

   iv. Copy the following policy and paste it in the JSON tab:

       {
       "Version": "2012-10-17",
       "Statement": [
           {
             "Effect": "Allow",
             "Action": [
       "s3:Get*",
       "s3:List*"
             ],
             "Resource": "arn:aws:s3:::{your-bucket-name}/*"
           },
           {
             "Effect": "Allow",
             "Action": [
       "s3:Get*",
       "s3:List*"
             ],
             "Resource": "arn:aws:s3:::{your-bucket-name}"
           }
         ]
       }
   

   v. Click Review Policy.

   vi. Name the policy "Fivetran-S3-Access".

   vii. Click Create Policy.

2. Create an IAM role for Fivetran:

   i. Go to Access management > Roles, then select Create role.

   ii. In the Create role window, select Another AWS account.

   iii. In the Account ID field, enter Fivetran's account ID, 834469178297.

   iv. In Options, select the Require external ID checkbox.

   v. Enter the External ID you found in your connector setup form.

   vi. Click Next: Permissions.

   vii. Select the "Fivetran-S3-Access" policy that you created.

   viii. Click Next: Tags. Entering tags is optional, but you must click through the step.

   ix. Click Next: Review.

   x. Name your new role "Fivetran", then click Create Role.

   xi. Select the Fivetran role you just created.

   xii. In the Summary section, make a note of the Role ARN. You will need it to configure Fivetran.

   NOTE: You can specify permissions for the Role ARN that you designate for Fivetran. Giving selective permissions to this Role only allows Fivetran to sync what it has permissions to see.

Finish Fivetran configuration

1. Return to the tab with your Fivetran dashboard.

2. Enter the following information:

   • (Optional) Folder Path
   • Bucket
   • Role ARN

   If you don't provide a folder path, Fivetran will search for data feeds present directly in the S3 bucket.

3. (Optional) Set the Should Split Arrays toggle to OFF if you don't want to split multivalued attributes into child tables.

   By default, Fivetran splits array elements and syncs the multivalued attributes into child tables.

4. Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.

Azure Blob Storage setup instructions

Begin Fivetran configuration

1. In the connector setup form, enter your Destination schema name.

2. In the Source drop-down menu, select AZURE_BLOB_STORAGE.

Create shared access signature in Azure

1. Open the Azure Portal.

2. Select your storage account and click Shared access signature.

   IMPORTANT: You can re-use the Shared Access Signature (SAS) across multiple Fivetran connectors.

3. Select Blob from the Allowed services options.

4. Select Container and Object from the Allowed resource types options.

5. Select Read and List from the Allowed permissions options.

6. Choose the appropriate start and expiry dates of your SAS.

   IMPORTANT: When the SAS expires, you will have to update your Azure Blob Storage connector to resume syncing files.

7. (Optional) To enhance security, safelist Fivetran's IP address range under Allowed IP addresses. Azure only allows one IP range per SAS token.

   IMPORTANT: Use the IP range format to safelist the IP addresses, for example, 35.234.176.144 - 35.234.176.151, because the CIDR format, for example, 35.234.176.144/29, is not supported in the Azure Portal.

8. Select HTTPS only from the Allowed protocols options. We recommend to select the HTTPS option to ensure the security of your files.

9. Click Generate SAS and connection string.

10. Make a note of the Connection string value. You will need this to configure Fivetran.

(Optional) Choose connection method

Decide whether you want Fivetran to connect to your Azure Blob storage container directly, using an SSH tunnel, or using Azure Private Link.

Connect directly

By default, Fivetran connects directly to your Azure Blob storage container. This is the simplest connection method.

If you have a firewall enabled, do the following to allow Fivetran to connect directly:

• Create a firewall rule to allow access to Fivetran's IPs.
• If your Fivetran instance is configured to run in the same region as your Azure storage account, configure a virtual network rule and add Fivetran's internal virtual network subnets to the list of allowed virtual networks. Learn more in Microsoft's Azure Blob Storage documentation. To get the list of region-specific subnet IDs, contact our support team.

Connect using SSH

Fivetran connects to a separate server in your network that provides an SSH tunnel to your Azure Blob storage container. You must connect through SSH if your container is in an inaccessible subnet on a virtual network.

To connect using SSH, create a firewall rule to allow access to your SSH tunnel server's IP address.

Connect using Azure Private Link

IMPORTANT: You must have a Business Critical plan to use Azure Private Link.

Azure Private Link allows Virtual Networks (VNets) and Azure-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. Learn more in Microsoft's Azure Private Link documentation.

Follow our Azure Private Link setup guide to configure Azure Private Link for your storage container.

Finish Fivetran configuration

1. Return to the tab with your Fivetran dashboard.

2. Enter the following information:

   • (Optional) Folder Path
   • Container
   • Connection String

   If you don't provide a folder path, Fivetran will search for data feeds present in the root directory of the storage container.

3. (Optional) Set the Should Split Arrays toggle to OFF if you don't want to split multivalued attributes into child tables.

   By default, Fivetran splits array elements and syncs the multivalued attributes into child tables.

4. (Optional) Set the Show advanced options toggle to ON and select your connection method:

   • Connect directly
   • Connect via SSH tunnel
   • Connect via Private Link

   NOTE: By default, we directly connect to your storage container.

5. Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home