Connect to Square account data from reporting tools, databases, and custom applications through standards-based drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.

"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks




BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time Square data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Square data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations



Alteryx Designer: Prepare, Blend, and Analyze Square in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Square in Amazon QuickSight Aqua Data Studio: Connect to Square in Aqua Data Studio Birst: Build Visualizations of Square in Birst BIRT: Design BIRT Reports on Square Clear Analytics: Build Charts with Square in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Square in DBxtra Domo: Create Datasets from Square in Domo Workbench ... Dundas BI: Build Dashboards with Square in Dundas BI FineReport: Feed Square into FineReport Google Data Studio: Create Reports from Square in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Square JasperServer: Create Square Reports on JasperReports Server Jaspersoft BI Suite: Connect to Square in Jaspersoft Studio JReport Designer: Integrate with Square in JReport Designer KNIME: Enable the Square JDBC Driver in KNIME LINQPad: Working with Square in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Square Power BI Online: Visualize Live Square in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Square MicroStrategy: Use the CData JDBC Driver for Square in MicroStrategy OBIEE: Square Reporting in OBIEE with the Square JDBC Driver Pentaho Report Designer: Integrate Square in the Pentaho Report Designer QlikView: Connect to and Query Square in QlikView over ODBC R: Analyze Square in R RapidMiner : Connect to Square in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Square SAP Crystal Reports: Publish Reports with Square in Crystal Reports SAP Lumira: Consume Square OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Square in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Square in Sisense Spago BI: Connect to Square in SpagoBI Tableau: Visualize Square in Tableau Tableau Online: Build Square Visualizations in Tableau Online Tableau Server: Publish and Share Square Dashboards with Tableau Server TIBCO Spotfire: Visualize Square in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Square from Spotfire Server Visio: Link Visio Shapes to Square

ETL, Replication, & Warehousing



From drivers and adapters that extend your favorite ETL tools with Square connectivity to ETL/ELT tools for replication — our Square integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Square to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.

Popular Data Warehousing Integrations



Amazon Redshift: Automated Continuous Square Replication to Amazon Redshift Amazon S3: Automated Continuous Square Replication to Amazon S3 Apache Cassandra: Automated Continuous Square Replication to Apache Cassandra AWS Glue: Connect to Square in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Square to SQL Server CloverDX: Connect to Square in CloverDX (formerly CloverETL) CSV: Automated Continuous Square Replication to Local Delimited Files IBM DB2: Automated Continuous Square Replication to IBM DB2 FoxPro: Work with Square in FoxPro Google BigQuery: Automated Continuous Square Replication to Google BigQuery Google Cloud SQL: Automated Continuous Square Replication to Google Cloud SQL Google Data Fusion: Pipe Square in Google Data Fusion Heroku / Salesforce Connect: Replicate Square for Use in Salesforce Connect Informatica Cloud: Integrate Square in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Square Jaspersoft ETL: Connect to Square in Jaspersoft Studio Microsoft Access: Automated Continuous Square Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Square Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Square MongoDB: Automated Continuous Square Replication to MongoDB MySQL: Automated Continuous Square Replication to MySQL Oracle Data Integrator: ETL Square in Oracle Data Integrator Oracle Database: Automated Continuous Square Replication to Oracle PostgreSQL: Automated Continuous Square Replication to PostgreSQL Replicate to CSV: PowerShell Scripting to Replicate Square to MySQL Snowflake: Automated Continuous Square Replication to Snowflake SQL Server: Automated Continuous Square Replication to SQL Server SQLite: Automated Continuous Square Replication to SQLite Talend: Connect to Square and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Square in UiPath Studio

Data Management



By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Square data from a wide range of database management applications.

Popular Data Management Tool Integrations




Developer Tools & Technologies



The easiest way to integrate with Square from anywhere. Our Square drivers offer a data-centric model for Square that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations



.NET Charts: DataBind Charts to Square .NET QueryBuilder: Rapidly Develop Square-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Square Apache Spark: Work with Square in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger Square IFTTT Flows in Azure App Service ColdFusion: Query Square in ColdFusion DevExpress: DataBind Square to the DevExpress Data Grid EF - Code First: Access Square with Entity Framework 6 EF - LINQ: LINQ to Square EF - MVC: Build MVC Applications with Connectivity to Square Filemaker Pro: Bidirectional Access to Square from FileMaker Pro Go: Write a Simple Go Application to work with Square on Linux Google Apps Script: Connect to Square in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Square Entities in Java IntelliJ: Connect to Square in IntelliJ JBoss: Connect to Square from a Connection Pool in JBoss JDBI: Create a Data Access Object for Square using JDBI JRuby: Connect to Square in JRuby NodeJS: Query Square from Node.js NodeJS: Query Square as a MySQL Database in Node.js PHP: Access Square in PHP through the Cloud Hub PHP: Natively Connect to Square in PHP PowerShell: Pipe Square to CSV in PowerShell PowerBuilder: Connect to Square from PowerBuilder PyCharm: Using the CData ODBC Driver for Square in PyCharm Python: Connect to Square in Python on Linux/UNIX Ruby: Connect to Square in Ruby SAP UI5: Integrate Real-Time Access to Square in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Square in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for Square WebLogic: Connect to Square from a Connection Pool in WebLogic


When Only the Best Square Drivers Will Do

See what customers have to say about our products and support.



Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below: