MySQL Integration

Multi-System Integration

Deliver your MySQL integrations faster with eOne’s SmartConnect. You’ll have a user-friendly interface to create custom integrations between your MySQL and your other cloud and on-premise data.

• Integrate as a source or destination with all your data in MySQL.
• Configure your integration when you want: manually, automated on a schedule, or call a SmartConnect map to run via the SmartConnect API.​
• Enjoy a simple point-click and flexible mapping experience.
• Add steps and tasks to complete your business process automation.
• Easily monitor, use alerts, view errors and fix them.

Virtual Integration

Virtual integration is a powerful integration option that lets you provide a real-time look at external data in your app and is configured without a line of code.

If you’re looking to provide visibility and interface to access your MySQL data conveniently, virtual integration using Popdock widgets is your answer:

• Embed detailed Popdock reports that include MySQL data in your app.
• Combine MySQL data with other app data in a single report and embed it in your app.
• Embed data with parameters related to specific records, like transactions related to specific customers on the CRM account record.
• Allow your users to view related details like invoice lines related to invoice headers.
• Allow your users to use Popdock actions to do things like open records or run a process.

File Integration

Get more flexibility as you integrate files with MySQL.

File imports to MySQL

Files come in a lot of different formats. Configure your mapping to any column in your MySQL and use data transformation options to ensure your data fits perfectly. Available with all SmartConnect plans.

Trigger real-time or on a schedule from your folder.

SmartConnect’s file integration from local locations, FTP/SFTP, Microsoft OneDrive, and Microsoft SharePoint folder locations. Available with all SmartConnect Plans.

Run integrations from the SmartConnect Excel-Add-in

Allow users to select integrations and run them right from Excel. Included with all SmartConnect Plans.

Refresh reports into Excel with the Popdock Excel Add-in

Refresh any Popdock standard or custom list with customizations into Excel. Included with all Popdock Plans.

Export and email Popdock Reports to Files on a Schedule

Create advanced, customized Popdock reports with MySQL data and send them to the right people on your schedule. Available in the Popdock Premium Plan.