Easily consume RESTful APIs
REST is the de-facto standard for implementing modern web services. In mid 2016 we introduced an elegant, easy-to-use solution for consuming RESTful APIs in SSIS. We have been steadily evolving and elaborating our framework since then. The unmatched sophistication and flexibility of our solution would enable you to easily handle any requirement when integrating with REST-based applications.
Our framework has allowed us to rapidly bring to market 46 integrations with REST-enabled applications. Please feel free to suggest other applications that you would like us to support. We would also encourage you to author your own configurations. If you need a helping hand, please contact us.
Elegant handling of composite records
Many real-world applications need to handle data structures which can’t be represented with a simple flat table. A good example is an invoice record where each record contains a sub-list of line item records. Those child records are also known as composite records.
SSIS doesn't provide a good infrastructure for handling that kind of hierarchical tabular data out-of-the-box. Fortunately, we have come up with an elegant way of representing these composite records. Our architecture fits nicely in SSIS and allows processing of all records in an efficient “streaming” mode. It enables massaging the data with all available transformations, so that it can accommodate any project requirements.
If you are interested in seeing this approach in action, please take a look at the second part of our NetSuite Destination demo video.
Simple, affordable pricing
Other data integration solutions have complicated pricing tiers that depend on processed data volumes or the number of users or connectors you want to use. Unlike those vendors, the COZYROC SSIS+ pricing is quite straightforward. You pay $999/year for two license keys and a license key is only required when scheduling and executing packages under the SQL Job agent. No caveats, limitations or hidden fees.
When it comes to SSIS, COZYROC is the gold standard. With the COZYROC add-on suite, we are able to perform 95% of our development without having to write custom code. Custom components like the Salesforce and REST adapters allow us to directly and easily integrate data.