Documentation and SupportV5 User Manual Creating Tables Using ConnectorsHow do I create a table using an Adobe Data Warehouse 1.4 Extract Connector?

How do I create a table using an Adobe Data Warehouse 1.4 Extract Connector?

If you have already created a table, the Table(s) icon will be available.

Navigate to the Table(s) Tools.

2. Click the 'Add New' bubble.

Click the 'Add New' bubble.

3. If this is your first table, you must navigate to the System Tools.

If this is your first table, you must navigate to the System Tools.
Navigate to the Table System Tools.

5. Click the 'Add New' bubble.

6. Create your table (Step 1).

  1. Name of the Table (Max length is 44 characters and can not include a back tick [ ` ])
  2. Enter a description for your table, this can be left blank.
  3. Select the folder where the table will live.
  4. Select From Connection from the table type drop down.
  5. Select Next.
Create your table (Step 1).

7. Create your table (Step 2).

  1. Select the Adobe 1.4 connector.
  2. Select the Update Frequency.
  3. Select the update time/date.
  4. Select the Granularity: Hourly, Daily, Weekly, Monthly, Quarterly, or Yearly.
  5. What time period you wish to get data from, this is either a user entered range or by keywords.
  6. Click Next.
Create your table (Step 2).

8. Create your table (Step 3).

  1. Select which Suite the data will be drawn from.
  2. Select which action when the table reloads.  Append Data Warehouse Data to the Local Table will append any new data or changes.  Clear Local Data and Reload will truncate the table before loading the data.
  3. Click Next.
Create your table (Step 3).

9. Create your table (Step 4).

  1. Select the Segment you wish to use, this can be left blank.
  2. Select the Elements you wish to pull.
  3. Click Next.
Create your table (Step 4).

10. Create your table (Step 5).

  1. Select the Classifications as need for your specific report.  Below is just a representation of some of the selectable choices.
  2. Click Next.
Create your table (Step 5).

11. Create your table (Step 6).

  1. Arrange Elements in the order you wish them to be shown in the table.
  2. Click Next.
Create your table (Step 6).

12. Create your table (Step 7).

  1. Select the Metrics you wish to extract.
  2. Click Next.
Create your table (Step 7).

13. Create your table (Step 8).

  1. Arrange Metrics in the order you wish them to be shown in the table.
  2. Click Next.
Create your table (Step 8).

14. Create your table (Step 9).

Click Save.

Create your table (Step 9).

15. Congratulations, the table was saved!

Congratulations, the table was saved!