Omniture SiteCatalyst - Adobe Analytics Connector
Birst can extract data from Omniture SiteCatalyst (now known as Adobe Analytics) using the Omniture SiteCatalyst Connector. The connector extracts data from Omniture using the Omniture Reporting API. After defining the objects to extract, you can schedule extractions using the Schedule Data Processing page.
Prerequisites
You will need your Adobe Analytics User Name, Company, and Secret Key to access your Adobe Analytics account from Birst. You need to use an Adobe Analytics login (user name) that has the web service permission. To obtain the web service permission, a user must be a member of the Web Service Access group. Use the Groups page under User Management, Admin Tools on the Adobe Marketing Cloud site to check which users are in this group or to add a user to the group. You will also need the Shared Secret that is auto-generated when the user is added to the Web Service Access group. If the user is a member of this group, the User Name and Shared Secret will be displayed in the Web Service Credentials area when you select the user on the Users page within the User Management area.
Implementation and Usage Notes
- The Omniture SiteCatalyst Connector supports extracting elements and element classifications.
- When extracting data from Omniture SiteCatalyst, you need to specify a start date and end date. Infor variables can be used to provide the start date and end date.
- The following columns are included with every object extraction: Report Suite ID, Report Suite Name, Start Date and End Date.
- The number of attributes and metrics that can be extracted at one time is determined by the Omniture API. At the time of this writing attributes are limited to 4 and metrics to 6.
- The minimum Start Date is 2000-01-01. The maximum for the End Date is 2899-12-31.
- You can
use a Birst variable
to provide the start date and end date. See Creating
Variables. Variables for the Start Date and End Date must use the
following syntax:
YYYY-MM-DD
After creating a new variable, you may need to process data before running the extraction in order for the variable to be recognized and validated during extraction. - Selecting multiple segments from the dropdown box will "AND" the segments.
- You can
use a Birst variable
to provide the Report Suite IDs. See Creating
Variables. The variable can be a query variable type or a constant
variable type and can be either single value or multi-value. A constant
variable should contain only the Report Suite ID; multiple Report Suite
IDs should be separated by commas (no spaces), for example:
BM-16825,Scribe,AEM Mobile Time Stamped. - Page extraction size is configurable. The page size is the number of records requested in one API request. If there are 15000 records, and if the pagesize is 5000, it will call the API 3 times to get all the 15000 records. The default and maximum page size is 5000. Appliance Administrators can change the max pagesize value in the OmnitureSiteCatalystParameters.txt file in the OmnitureSiteCatalystParameters connector in the Tomcat installation directory.
- The Infor Team recommends that you not use the day granularity option when extracting the data from Omniture SiteCatalyst using the Top N rows configuration.
- Data extraction may get timed out when extracting the data from Omniture SiteCatalyst using day granularity with a large date range.
- Data extraction for an Omniture SiteCatalyst report suite may get timed out if the response is not received within preset time and extraction may not be marked as failure if extraction succeeds from other report suite(s) for same extract object.
- The element or metric label may be different than the selected ones when only one of a duplicated element or metric is selected.
For general usage notes see Connect to Cloud Applications Using Application Connectors.