Adobe Datawarehouse

Before Getting Started

To get started with the Adobe Datawarehouse datasource type we need to create a new OAuth project and input information into Alli’s Client Settings. To complete these steps you will need someone with Adobe admin access to configure the project in Adobe.

As a part of the access required for this datasource, individual Report Suites will need to be granted access to the “Custom Data Warehouse Report” product profile. If this access is missing, the datasource will error with status code 400.

Creating A New OAuth Project In Adobe

1. Navigate to the Adobe Developer Console for your organization: Loading... | Adobe Developer Console

2. Click Create new project

3. Select Adobe Analytics from the list of APIs

4. Choose OAuth Server-to-Server as the authentication type

5. Select the Adobe Analytics product profiles and click Save configured API

6. Click OAuth Server-to-Server under the Credentials

7. Note down the following information:

   1. Client ID

   2. Client Secret

   3. Technical Account ID

   4. Organization ID

We also need to the Global Company ID:

1. Navigate to the Adobe Experience Cloud for your organization: https://experience.adobe.com/#/home

2. Click on Adobe Analytics

3. Within Adobe Analytics, click on Admin

4. Under the Admin drop-down, select Company Settings

5. Lastly, select API Access

6. Note down the Global Company ID

   1. Ex. companyname1

Required Authorization

Using an existing authorization

Adobe Datasources uses our enhanced authentication system, if your client was already set up with adobe once, you should be able to select it from the drop-down menu when creating a new datasource or editing an existing one.

Creating a new authorization

If your client does not have an authorization set up, you need to create a new authorization

Please note when creating new authorizations, if you want to allow other users to use this authorization, you need to Save then click on the cog symbol next to your new authorization and modify the ACCESS LEVEL

1. Create a new Adobe Datawarehouse datasource

2. Click on New Authorization then Save & Authorize

3. Fill out the form with the previously gathered OAuth information.

Authentication Type: server_to_server
Company Name: <Global Company ID>
Client ID: <Client ID>
Client Secret: <Client Secret>
Technical Account ID: <Technical Account ID>
Organization ID: <Organization ID>

4. Then click Save at the bottom of the form once completed.

Updating an existing authorization

Some authorizations may require you to update a field such as ‘Client Secret’ or ID, to do this, if this is the case, you can edit the authorization and it will automatically be updated to all datasources using that authorization:

1. Navigate to a datasource that is currently set up with the Authorization you are trying to update

2. Click on the cog symbol next to the authorization you are trying to edit

   

3. Click on Reauthorize

   

4. Fill out the form with the previously gathered OAuth information.

5. Then click Save at the bottom of the form once completed.

Additional Configurations

Reporting Suite

Select the Adobe Analytics reporting suite for the data you want to bring into Alli.

Segments

To filter the data coming into Alli, you can leverage pre-defined Adobe Analytics segments. To apply one or multiple segment(s) to your datasource:

1. Within Adobe Analytics, apply a Tag to the segments you want to select in Alli (ex. alli-ready)

   1. Follow the steps here to add a Tag to a Segment: Tag segments | Adobe Analytics

2. Paste the Tag text into the Segment Tag Name and click Next

3. Select the segment(s) that you want to leverage and click Next

Frequently Asked Questions

What is the difference between the Adobe Analytics and Adobe Datawarehouse datasource types?

The Adobe Analytics datasource type only allows one dimensions to be selected and will often fail with larger data requests. The Adobe Datawarehouse datasource type provides more flexibility in what dimensions or metrics can be selected and the amount of data requested but will take longer to load.