Xandr

Xandr is the advertising and analytics subsidiary of Microsoft.

For more information about connecting to SaaS applications, see Connecting to SaaS applications.
For more information about Lite connectors, see Classifications for SaaS application connectors.
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 An overview of target update methods.

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.

Make sure that the account you use has read access to the tables you want to fetch.

To obtain the API access, follow the API onboarding process procedure.

Creating the connection

For more information, see Connecting to SaaS applications.

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.

Connection settings
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 `YYYY-MM-DD`. Example: 2024-05-31.
Reporting Start Time	Start time in the format `YYYY-MM-DD HH:00:00`.
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".

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here