Performance-optimized SSIS Data Flow Source, Lookup, and Destination components for Sugar


Features and Benefits

SQL Support for Sugar

Devart Sugar Source supports SQL to get data from Sugar. Simple statements are translated directly to Sugar API calls and executed on the Sugar side, and for more complex statements, the necessary data are queried from Sugar and processed locally. You can specify complex SELECT statement with grouping, filtering, ordering, etc. in the Devart Sugar Source editor.

View All Features
Convenient Devart Sugar Source Editor

Devart Sugar Source component offers a convenient editor, which displays all the Sugar objects and their fields and allows you to quickly build a query to Sugar via drag-n-drop. If necessary, you can also quickly preview data, returned by the source, and check whether you query returns what you need.

View All Features
Advanced Lookup Optimizations

Devart Sugar Lookup component offers very high performance because of the advanced optimization techniques used. It checks several rows at once, and caches the returned results to reduce the number of round-trips to the server.

View All Features
DETAILS
Application Integration & Management
Version Compatibility

SQL Support for Sugar

Devart Sugar Source supports SQL to get data from Sugar. Simple statements are translated directly to Sugar API calls and executed on the Sugar side, and for more complex statements, the necessary data are queried from Sugar and processed locally. You can specify complex SELECT statement with grouping, filtering, ordering, etc. in the Devart Sugar Source editor.

Convenient Devart Sugar Source Editor

Devart Sugar Source component offers a convenient editor, which displays all the Sugar objects and their fields and allows you to quickly build a query to Sugar via drag-n-drop. If necessary, you can also quickly preview data, returned by the source, and check whether you query returns what you need.

Advanced Lookup Optimizations

Devart Sugar Lookup component offers very high performance because of the advanced optimization techniques used. It checks several rows at once, and caches the returned results to reduce the number of round-trips to the server.

Support

Phone Support:
Support Email: support@devart.com
Support Knowledge Base: https://www.devart.com/ssis/

Terms & Conditions

Terms of Service: https://devart.com/using-website/terms-of-use.html
Privacy Policy: https://devart.com/using-website/privacy-policy.html

Resources

Please where we're going to have PDF and what not

Similar Apps

AWS EventBridge Module
Exchange Integration
Deluxe Marketing Suite
Commercient SYNC Integrates EPICOR 10 ERP and Sugar
Commercient SYNC for Epicor Prophet 21 and Sugar
KINAMU SAP Connector