Mailjet

Mailjet is an email marketing and transactional email service provider.

Mailjet integration replicates data using the Mailjet Email API.

See the Schema section for a list of objects available for replication.

A high-level look at this connector, including useful links, and supported features.

Feature/Capability	Support details
Supported Qlik Talend Data Integration projects	Replication projects only. Data pipeline projects are not supported.
Target update methods	Replication tasks: Apply changes Store changes Landing data in a data lake tasks: Change data capture (CDC)
Managing metadata	Manual metadata generation is not required.
Schema evolution	Only the Change column data type operation is supported.
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Not supported.
Scheduled CDC	Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling tasks For lake landing tasks, see Scheduling CDC for lake landing tasks
Notifications	Partially supported Setting notifications for changes in operation
Monitoring	CDC-only, as full load is not relevant for this connector. Monitoring an individual data task
Automatic denesting of JSON column payloads	Not supported. JSON column payloads in source datasets are not denested automatically on the target.

Preparing for authentication

To access your 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.

You can connect only one account at a time. For example, you might have one primary Mailjet account and multiple subaccounts for different use cases. Qlik Talend Cloud replicates data using the API key and secret associated with the specific account you connect, either the primary account or a subaccount.

To create a subaccount:

Log into your Mailjet account.
Navigate to Account settings > API Key Management (Primary and Sub-account).
Click Create sub-account (API Key).
Enter a name for your new API Key name, and then click Create.
In Sub-account API Keys, copy and paste your API key and secret key into a secured file.

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.
Start Date	Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target.
API Key	API key.
API Secret	API secret.

Schema

Depending on your destination, table and column names may not appear as they are outlined below.

messages

Replication Method	CDC
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

contacts

Replication Method	Full Table
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

contacts_list

Replication Method	Full Table
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

list_recipient

Replication Method	Full Table
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

campaigns

Replication Method	CDC
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

template

Replication Method	Full Table
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

message_information

Replication Method	CDC
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

geo_statistics

Replication Method

Full Table

Replication Key

Data

Useful links

Mailjet documentation

click_statistics

Replication Method	CDC
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

top_link_clicked

Replication Method	Full Table
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

campaign_overview

Replication Method	Full Table
Primary Key	ID
Replication Key	Data
Useful links	Mailjet documentation

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 – please let us know!

Leave your feedback here