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.
Prerequisiteslink
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 feedlink
-
Log in to Adobe Experience Cloud using your Adobe ID credentials.
-
Click the 9-square icon, then click the Analytics logo.
-
In the navigation bar, click Admin > Data feeds.
-
Click Add. A new page appears with three main categories: Feed Information, Destination, and Data Column Definitions.
-
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.
-
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.
- If you selected FTP/FTPS or SFTP, enter the Host address. For example,
-
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.
-
-
Provide the Data Column Definitions:
- In the Select Column Template dropdown 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.
-
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 Guidelink
In Fivetranlink
-
In the connector setup form, enter your Destination schema name.
-
In the Source drop down menu, select FTP.
-
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.
-
(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.
-
(Optional) Set the Secure FTP toggle to ON if you want Fivetran to connect using FTPS (File Transfer Protocol over SSL/TLS).
-
Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.
SFTP Setup Guidelink
In Fivetranlink
-
In the connector setup form, enter your Destination schema name.
-
In the Source drop down menu, select SFTP.
-
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.
-
(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.
-
(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. -
Enter your password if you are not using a key pair to log in.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.
Amazon S3 Setup Guidelink
Begin Fivetran configuration link
-
In the connector setup form, enter your Destination schema name.
-
In the Source drop down menu, select S3.
-
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 link
-
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.
-
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, check 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 link
-
Return to the tab with your Fivetran dashboard.
-
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.
-
(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.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.
Azure Blob Storage Setup Guidelink
Begin Fivetran Configuration link
-
In the connector setup form, enter your Destination schema name.
-
In the Source drop down menu, select AZURE_BLOB_STORAGE.
Create a Shared Access Signature in Azurelink
-
Open the Azure Portal.
-
Select your storage account and click Shared access signature.
IMPORTANT: You can re-use the Shared Access Signature (SAS) across multiple Fivetran connectors.
-
Select Blob from the Allowed services options.
-
Select Container and Object from the Allowed resource types options.
-
Select Read and List from the Allowed permissions options.
-
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.
-
(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. -
Select HTTPS only from the Allowed protocols options. We recommend to select the HTTPS option to ensure the security of your files.
-
Click Generate SAS and connection string.
-
Make a note of the Connection string value. You will need this to configure Fivetran.
Finish Fivetran configuration link
-
Return to the tab with your Fivetran dashboard.
-
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.
-
(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.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Adobe Analytics Data Feed account.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration