InData Science Collectivebyhotglue·Aug 1, 2025Optimizing Microsoft SQL insert speed in Python: pymssql vs. pyodbc vs. bcpLearn how we optimized our Microsoft SQL target by using bcp to boost insertion speed and switching from pymssql to pyodbc.
InAgile Insiderbyhotglue·Oct 11, 2021Everybody wants to be the source of truthWhy a new wave of SaaS products are branding themselves as the source of truth and what it means for the industry
InBetter Programmingbyhotglue·Apr 12, 2021How To Handle Spreadsheet Uploads for Your Web AppManage spreadsheet import, mapping, and validation for web applications
InTDS Archivebyhotglue·Mar 29, 2021How to integrate Quickbooks with your SaaS platformHow I built a QBO integration to monitor department revenues and costs with PythonA response icon1A response icon1
InTDS Archivebyhotglue·Mar 8, 2021How to import CSV data into Quickbooks using PythonUsing Python to import Journal Entry spreadsheets to Quickbooks Online, for free
InAgile Insiderbyhotglue·Mar 8, 2021How to build an interactive MRR report using Quickbooks dataCombining Cumul.io’s embedded analytics platform with a hotglue Quickbooks data integration pipeline
InTDS Archivebyhotglue·Feb 11, 2021The future of data integrationHow cloud computing, the Python stack, data warehouses, and growth of SaaS platforms are poised to change the face of data integration.
InAgile Insiderbyhotglue·Feb 8, 2021How to build a data integration pipeline without the massive tech debtThe tools that make creating data integration pipelines easier than ever for B2B developersA response icon1A response icon1
InTDS Archivebyhotglue·Feb 5, 2021How to integrate Quickbooks with PythonBuilding a lightweight Quickbooks data integration pipeline using PythonA response icon1A response icon1
InTDS Archivebyhotglue·Jan 29, 2021How to integrate Salesforce with B2B appsBuilding a lightweight Salesforce data integration pipeline using Python