Connecting to Mailgun
Mailgun is an email delivery service. Mailgun’s email API for application-driven emails gives you an easy way to automate your sending based on user actions in your app or connect with any platform.
Data integration: Skyvia supports importing data to and from Mailgun, exporting Mailgun data to CSV files and replicating Mailgun data to relational databases.
Backup: Skyvia Backup does not support Mailgun.
Query: Skyvia Query supports Mailgun.
Mailgun-Specific Features and Limitations
Skyvia has the following limitations for Mailgun:
In the Data Integration product, Mailgun connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Mailgun in your package.
- Skyvia supports DML operations for such Mailgun objects:
- INSERT, UPDATE, DELETE: IPPools, ListMembers, MailingLists, Routes, Templates.
- INSERT, DELETE: Bounces, Compliants, Domains, Unsubscribes, Whitelists
- UPDATE, DELETE: Tags.
- INSERT: SeedLists.
- DELETE: SeedResults.
- Skyvia supports Replication with Incremental Updates for such Mailgun objects: Complaints, Domains, MailingLists, Routes, Templates, Unsubscribes, Whitelists.
- Synchronization is not supported for Mailgun.
_Events support peculiarities. A separate object has been created for each of the 9 types of events, since the object structure for each type is different. They are the following objects:
Events_Accepted, Events_Delivered, Events_Failed, Events_Opened, Events_Unsubscribed, Events_stored, Events_Rejected, Events_Clicked, Events_Complained.
SendMessages object and its peculiarities. The object is implemented through the stored procedure:
call SendMessage(:from, :to, :text, :html, :cc, :bcc, :subject, :amp-html, :template)
The required parameters are from and to, either text or html should be specified. You can use a call to the stored procedure, for example as a text of the command in the ExecuteCommand action in a Target component of a Data Flow.
To create a connection to Mailgun, you simply need to specify your Private API Key and Domain. To start creating a connection, follow the below steps:
- Click +NEW in the top menu.
- Click Connection in the menu on the left to open the Select Connector page.
- In the opened pane, click Mailgun.
- In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
Select API Region from the drop-down list.
- Paste your private API Key.
- Specify your domain. Please note that you should enter your domain in the following way to receive data correctly: sandbox355fba5b89c0467b8651c98273013e4d.mailgun.org.
Finally, use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Supported Actions and Actions Specifics
Mailgun connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.