Reset Filters
Back to marketplace
Solution

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.

See pricing & get a quote
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.

See pricing & get a quote
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.

See pricing & get a quote
Client Review

What this comes down to is really making the lives of my team much easier and eliminating unnecessary data entry. We couldn’t be as efficient as we are without the use of SmartConnect.

Testimonial image - Nate DeJonge
Nate DeJonge, Vice President of Finance at Eagle’s Flight
Related apps
Solution Microsoft SQL Reporting

User-driven custom reporting on Microsoft SQL data + your other data.
Solution MySQL Reporting

User-driven custom reporting on MySQL data + more.
Solution Postgre SQL Integration

100% configurable virtual integration with Postgre SQL. No code required.
App SmartConnect

Build custom data integration and automation without code.
App Popdock

Access, archive, & report on data from anywhere.
App Popdock for Microsoft Teams

Access real-time, actionable reports conveniently in Microsoft Teams.

App SmartConnect Add-in for Microsoft Excel

Run SmartConnect Integrations from Excel.

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.

Purchase & get started
Learn more