Gallery

Skyvia offers a number of predefined integrations and public queries that can either be used for popular use cases as is or serve as examples for users for designing their own integrations and queries. These integrations and queries can be accessed via Gallery.

The predefined integrations help you automate the most common cloud application integration tasks, such as creating Mailchimp subscribers from Salesforce contacts or leads and vice versa, creating Mailchimp subscribers from Shopify customers, adding new Marketo leads as Salesforce contacts, etc. Predefined queries also demonstrate popular use cases and SQL structures or Query Builder features, like updating Salesforce data or querying the sizes of SQL Server tables.

To use a query or integration from the Gallery, simply click the Gallery link in the New menu.

Here you can use the integrations or Queries tab to view only integrations or queries respectively, use the Type to search box to search by name, or Filters list to filter objects by connector.

You may point any integration or query and click View Info to read their description. Click Use to use the corresponding template of integration or query. Then simply select connection(s) for it, and you can run it immediately or edit it to make it more suitable for your use case.

Please note that by default Gallery includes predefined integrations, which use old runtime, i.e. the Use new runtime checkbox is not selected in the integration settings. Integrations, using old runtime, use SSIS expression syntax.

Please consider expression syntax differences when switching a predefined integration that uses expression mapping from old to new runtime. You can find more information about main syntax differences between old and new runtimes here.