Back to marketplace

Microsoft SQL Integration

100% configurable integration with Microsoft SQL. No code required.
Core Experience Database Integration
Created By eOne Solutions
Request demo
Multi-System Integration
Virtual Integration
File Integration
Multi-System Integration

No need to write code or hire developers to write your integrations.  Using eOne’s SmartConnect, you have a user-friendly interface to create custom integrations between your Microsoft SQL and your other cloud and on-premise data. ​

  • Integrate as a source or destination with all your data in Microsoft SQL.​
  • 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.

Outcomes Delivered​

  1. Integrate without code.
  2. Lower your project risks.
  3. Deliver results faster.

Licensing Required​

SmartConnect Basic Plan or above.

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 an interface to access your Microsoft SQL data conveniently, virtual integration using Popdock widgets is your answer:​

  • Embed detailed Popdock reports that include Microsoft SQL data in your app.​
  • Combine Microsoft SQL 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.

Outcomes Delivered​

  1. Integrate in minutes, not weeks.
  2. Real-time integration, every time.
  3. Relevant, convenient insight in app for users
  4. Interface for user to view and take action on the data

Licensing Required​​

Popdock Basic Plan or above.

File Integration

eOne’s file integration options are flexible and allow you to achieve results faster.​

File imports to Microsoft SQL​

Files come in a lot of different formats. Configure your mapping to any column in your Microsoft SQL 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 Microsoft SQL data and send them to the right people on your schedule. Available in the Popdock Premium Plan.

Outcomes Delivered​

  1. Enhance productivity.
  2. Reduce errors.
  3. Manage data with ease.

Licensing Required​​

SmartConnect Premium Plan.

Not an eOne customer?

eOne’s data management suite is used by the world’s most iconic brands for core ERP integration and automation processes.