Square
Data Integration
via SSIS Productivity Pack
Integrate and migrate data to and from Square with any other application or data source including Microsoft Dynamics 365, QuickBooks, Magento, and Salesforce, to name just a few.
What other applications can you sync with Square?
Click here for more solutions.
When it comes to payment processing, having the most up-to-date information in your system is imperative. Avoid the embarrassment and hassle of charging the wrong price, or providing incorrect invoices or employee information by keeping your Square data synced with the other applications within your business.
Synchronize Data
Easily sync Square with your ERP, commerce, accounting, or any other application so product information, payments, employee details, etc. are always up-to-date.
Automate Business Processes
Square is the front line for payment processing, data integration can be used to streamline processes with your other applications such automatic email follow-ups with the customer or starting a workflow in your accounting or ERP system.
Replicate Data
Data Archival
Easily replicate data from Square for data archival and warehousing requirements.
Data Analytics
Easily retrieve data from Square so it is available for your choice BI and Analytics platform.
Square Data Integration
is available in the
SSIS Productivity Pack
Unique Features
- A simplified and secure connection manager makes it easy to communicate with Square.
- Supports Square's numerous APIs including Payments, Orders, Items, Customers, Business, Financials, and, Authentication.
- Read data from a myriad of Square's source objects including Catalog, Customers, Employees, Inventory, Labor, Locations, Orders, Payments, Refunds, Reporting, Transactions, in addition to Version 1 APIs for Employees, Items, Locations, and, Transactions.
- Retrieve data from Square with several advanced filtering capabilities for further data retrieval refinement.
- Square Destination Component supports massive data manipulation of the following objects:
- Apple Pay - Register Domain.
- Catalog - Batch Delete, Retrieve, or, Upsert Catalog Objects, or, Upsert or Delete Catalog Objects, or, Update Item Modifiers Lists or Item Taxes.
- Checkout - Create Checkout.
- Customers - Create, Search, Update, or, Delete Customer, or, Create or Delete Customer Card.
- Inventory - Batch Change Inventory, or, Batch Retrieve Inventory Changes or Counts.
- Labor - Create, Update, or Delete Break Type, or, Create, Search, Update, or, Delete Shift, or, Update Workweek Configuration.
- Mobile Authorization - Create Mobile Authorization Code.
- OAuth - Renew, Revoke, or, Obtain Token.
- Orders - Create, Update, Search, or, Pay Order, or, Batch Retrieve Orders.
- Payments - Create, Cancel, or, Complete Payments, or, Cancel Payment By ID Empotency Key.
- Refunds - Refund Payments.
- Transactions - Charge, Capture Transaction, Create Refund, or, Void Transaction.
- V1 Employees - Create or Update Employee, or, Create or Update Employee Role, or, Create, Update, or, Delete Timecard.
- V1Items - Create, Update, or, Delete Category, or, Create, Update, or, Delete Discount, or, Create, Update, or, Delete Fee, or, Adjust Inventory, or, Create, Update, or, Delete Item, or, Apply or Remove Fee, or, Apply or Remove Modifier List, Create, Update, or, Delete Variation, or, Create, Update, or, Delete Modifier List, or, Create, Update, or, Delete Modifier Option, or, Create, Update, or, Delete Page, or, Update or Delete Page Cell.
- V1 Transactions: Update Order or Create Refund.
Technical Requirements
- Square
- SQL Server Integration Services
- Azure-SSIS Integration Runtime
- Microsoft SQL Server 2019
- Microsoft SQL Server 2017
- Microsoft SQL Server 2016
- Microsoft SQL Server 2014
- Microsoft SQL Server 2012
- Microsoft SQL Server 2008 R2
- Microsoft SQL Server 2008
Square Data Integration Made Easy
Our solution is easy to use, offering code-less integration between Square and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.
Our Square integration solution is available within the REST Components and Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Square with applications such as Microsoft Dynamics 365, Salesforce, NetSuite, and many more.
See our full product offerings for more information.
Other SSIS Accounting & Commerce Components
Our Accounting and Commerce components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular accounting/commerce solution. In addition to Square, we support the following Accounting & Commerce services: