
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 FeaturesConvenient 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 FeaturesAdvanced 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 FeaturesSQL 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.htmlPrivacy Policy: https://devart.com/using-website/privacy-policy.html