Xandr (Lite)
Xandr is the advertising and analytics subsidiary of Microsoft.
-
For more information about connecting to SaaS applications, see Connecting to SaaS applications.
-
Depending on your use case, you might need to install Data Movement gateway to move data from SaaS applications. For more information, see When is Data Movement gateway required?.
Supported update methods
For more information, see Change processing.
Landing tasks:
-
Change data capture (CDC)
-
Reload and compare
Replication tasks:
-
Change data capture (CDC) using Change Tables
-
Full load
Landing data in a data lake tasks:
-
Change data capture (CDC)
-
Reload
Preparing for authentication
To access your Xandr data, you need to authenticate the connection with your account credentials.
To obtain the API access, follow the API onboarding process procedure.
Creating the connection
- Fill in the required connection properties.
-
Provide a name for the connection in Connection name.
-
Select Open connection metadata to define metadata for the connection when it has been created.
-
Click Create.
| Setting | Description |
|---|---|
| Data gateway |
Select a Data Movement gateway if required by your use case. Information note
This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement. |
| User name | Your Xandr user name. |
| Password |
Xandr password. |
| Reporting Start Date |
Start date in the format Example: 2024-05-31. |
| Reporting Start Time |
Start time in the format |
| Hourly Report One Type | Hourly report one type. |
| Hourly Report One Columns |
Hourly report one columns. Example: "one", "two". |
| Hourly Report Two Type | Hourly report two type. |
| Hourly Report Two Columns |
Hourly report two columns. Example: "one", "two". |
| Hourly Report Three Type | Hourly report three type. |
| Hourly Report Three Columns |
Hourly report three columns. Example: "one", "two". |
| Hourly Report Four Type | Hourly report four type. |
| Hourly Report Four Columns |
Hourly report four columns. Example: "one", "two". |
| Hourly Report Five Type | Hourly report five type. |
| Hourly Report Five Columns |
Hourly report five columns. Example: "one", "two". |
| Hourly Report Six Type | Hourly report six type. |
| Hourly Report Six Columns |
Hourly report six columns. Example: "one", "two". |
| Hourly Report Seven Type | Hourly report seven type. |
| Hourly Report Seven Columns |
Hourly report seven columns. Example: "one", "two". |
| Hourly Report Eight Type | Hourly report eight type. |
| Hourly Report Eight Columns |
Hourly report eight columns. Example: "one", "two". |
| Hourly Report Nine Type | Hourly report nine type. |
| Hourly Report Nine Columns |
Hourly report nine columns. Example: "one", "two". |
| Hourly Report Ten Type | Hourly report ten type. |
| Hourly Report Ten Columns |
Hourly report ten columns. Example: "one", "two". |
| Daily Report One Type | Daily report one type. |
| Daily Report One Columns |
Daily report one columns. Example: "one", "two". |
| Daily Report Two Type | Daily report two type. |
| Daily Report Two Columns |
Daily report two columns. Example: "one", "two". |
| Daily Report Three Type | Daily report three type. |
| Daily Report Three Columns |
Daily report three columns. Example: "one", "two". |
| Daily Report Four Type | Daily report four type. |
| Daily Report Four Columns |
Daily report four columns. Example: "one", "two". |
| Daily Report Five Type | Daily report five columns. |
| Daily Report Five Columns |
Daily report five columns. Example: "one", "two". |
| Daily Report Six Type | Daily report six columns. |
| Daily Report Six Columns |
Daily report six columns. Example: "one", "two". |
| Daily Report Seven Type | Daily report seven columns. |
| Daily Report Seven Columns |
Daily report seven columns. Example: "one", "two". |
| Daily Report Eight Type | Daily report eight columns. |
| Hourly Report Eight Columns |
Daily report eight columns. Example: "one", "two". |
| Hourly Report Nine Type | Daily report nine columns. |
| Hourly Report Nine Columns |
Daily report nine columns. Example: "one", "two". |
| Hourly Report Ten Type | Daily report ten columns. |
| Daily Report Ten Columns |
Daily report ten columns. Example: "one", "two". |