API Integration How to Iterate API Calls Over a List of IDs Pulled From a Snowflake Table: Step-by-Step To iterate API calls over a list of IDs pulled from a Snowflake table, query the Snowflake table to retrieve the IDs, configure a REST API source with a dynamic... Donal Tobin Read More
Data Ingestion How to Ingest Addepar API Data Into Snowflake on a Scheduled Basis: Step-by-Step To ingest Addepar API data into Snowflake on a scheduled basis, configure an ETL pipeline that authenticates to the Addepar API, triggers an async report job, polls the job status... Donal Tobin Read More
ETL How to Call the dbt Cloud API From an ETL Pipeline and Wait for Job Completion To call the dbt Cloud API from an ETL pipeline and wait for job completion, you trigger the job by sending a POST request to dbt Cloud's run endpoint, capture... Donal Tobin Read More
ETL How to Orchestrate Multi-Step ETL Workflows with Conditional Failure Branching: Step-by-Step To orchestrate multi-step ETL workflows with conditional failure branching, design a workflow graph where each task connects to both a success path and a failure path, configure what each path... Donal Tobin Read More
Database Integration How to Load Client Data Into Your Database Through an API: A Step-by-Step Guide To load client data through an API instead of direct database access, configure a REST API source connection that handles authentication, sends paginated GET requests, parses the JSON or XML... Donal Tobin Read More
data pipelines How to Replace Custom Python and PowerShell Scripts for Client Data Pipelines: A Step-by-Step Guide The best alternative to maintaining custom Python or PowerShell scripts for client data pipelines is a dedicated low-code ETL platform that handles extraction, transformation, and scheduling without requiring code to... Donal Tobin Read More
Product Update Bring Your Crisp Conversations Into Your Stack: Announcing the Integrate.io Crisp Connector Pull conversations, contact profiles, and customer events out of Crisp and into your warehouse, CRM, or AI pipeline, fully transformed, on schedule, with no engineering required. Crisp is a customer... Donal Tobin Read More
Data Integration MCP vs REST APIs for Data Integration: When to Use Each Your data integration team just asked: "Should we use MCP or REST APIs?" The answer is yes to both. With the ETL market reaching $10.24 billion in 2026 and projected... Donal Tobin Read More
Data Integration How to Connect Your Data Warehouse to AI Agents With MCP Your organization invested heavily in a data warehouse, yet business users still wait days for answers to simple questions. The disconnect between where data lives and who needs it remains... Donal Tobin Read More
ETL 48 min Top 25 ETL Tools (Updated July 2026) Integrate.io lists the 25 best ETL software tools for 2026 based on features, user review scores, and more. Which ETL tool should you choose? Abe Dearmer Read More
ETL 15 min SFTP to Salesforce – Guide to a Secure Integration Integrating data from your systems into Salesforce is a critical process. Here is a guide featuring the SFTP to Salesforce process. Donal Tobin Read More
Data Integration 10 min What Is Operational ETL? Delving into Operational ETL: Learn how it transforms business data handling for enhanced productivity. Donal Tobin Read More