Best ETL Tools - Page 20

Yres

Yres is a data warehouse automation platform for Microsoft Azure, developed by Plainwater in the Netherlands. It is built for data and BI teams that want a governed, query-ready data warehouse under Power BI without writing and maintaining ETL pipelines by hand. The principle is simple: you don't write pipelines, you add metadata. In the Yres web application you configure a data source, select the tables and choose a load type. Yres then generates the Azure Data Factory pipelines, the staging and history tables and the load schedule. Nobody writes a pipeline manually, and every generated pipeline follows the same tested pattern. Data loading and history Yres loads sources incrementally and keeps full history using slowly changing dimensions type 2 (SCD2), so every change in the source system is preserved and every report can be reproduced as of any date. Load types include full load, delta load and change feed. Each load is logged and monitored, with load status, health checks and data retention built in. Any table can be rolled back to a point in time, including its history and surrogate keys. Connectors Yres has its own connectors for AFAS and Exact Online, the two most common ERP systems in the Netherlands. It also reads SAP (via SAP Analytics Cloud, Datasphere and Business Data Cloud), Salesforce, Microsoft Dynamics 365 Business Central, ServiceNow, HubSpot, SQL Server, Oracle, PostgreSQL, REST APIs and files on SFTP, FTP or SharePoint. Open data sources such as CBS StatLine are available as ready-made sources. An optional Parquet change feed delivers the data to Azure Data Lake Storage for Microsoft Fabric or Databricks. Your own Azure tenant, no lock-in Everything runs inside the customer's own Azure subscription: the Azure Data Factory, the Azure SQL Database, the metadata and the keys in Azure Key Vault. Plainwater never hosts or touches your data. If you stop the subscription, you receive a licence key and the installation keeps loading. Deployment runs through Azure DevOps repositories and CI/CD pipelines, and customers can be given access to them on request. Pricing Pricing is fixed and public, from EUR 350 per month, with no per-row, per-user or per-connector fees. The comparison with TimeXtender, AnalyticsCreator and building it yourself on Azure Data Factory and dbt is published and sourced on yres.eu. Who uses Yres Yres is used by mid-sized organisations in manufacturing and food, housing associations, healthcare and business services, among them Aviko, Paragon Customer Communications, Koninklijke Visio and housing association 'thuis. Plainwater is an official partner of AFAS, Exact Online and SAP, and Yres is listed on the Microsoft Marketplace.

ZappySys ODBC PowerPack

ZappySys SSIS PowerPack

Zendesk SSIS Components by Devart

Devart SSIS Data Flow Components for Zendesk allow you to integrate Zendesk data with other databases and cloud applications via SQL Server Integration Services (SSIS). They include optimized Zendesk Source, Zendesk Destination, and Zendesk Lookup components and provide their own Zendesk Connection Manager with lots of Zendesk-specific connectivity features. - Export data from Zendesk to various sources - Import XML, CSV, and other files to Zendesk - Automate Zendesk integration via SSIS Data Flow tasks - Migrate from/to Zendesk using SSIS - Synchronize Zendesk with SQL Server or other data sources - Integrate various data sources with Zendesk via SSIS

Zuar Runner

Zuar Runner automates data pipeline extraction, transformation, staging, and orchestration from hundreds of sources — making data analytics-ready at scale.