Square Data Integration

Square data can be integrated and synchronized codeless with various external systems, on premises or in the cloud, using the Layer2 Cloud Connector.

Learn on this page how the data integration of Square is working with the Layer2 Cloud Connector by using the step-by-step screenshot tutorial. Make use of the benefits and features of this data integration tool by trying it out yourself: Free Trial Registration

How it works Step-by-step-tutorial Features and Benefits Find more solutions

HOW IT WORKS

In fact, you only need to do the 5 following steps to get your Square data integration started.

Set up your connection as required: one-way or two-way.
Set up your data source, in this case, Square.
Set up your target – for example, SharePoint.
Set up your mapping.
Start your project!

Square step-by-step data integration via the Layer2 Cloud Connector

Use this step-by-step-instruction to get through the whole product and data integration configuration easily. Some steps require a copy-paste task of code snippets. Please follow the recommendations in this instruction closely.

Before you can proceed with the configuration, please be aware that

You need to configure a new application in your Square account. Name it "Layer2 Cloud Connector", for example.
Copy your Personal Access Token. You have to use it in the Layer2 Cloud Connector. Besides, you can also use the OAuth to generate a client id in order to use the OAuth flow to authenticate.

Connection setup for Square in the Layer2 Cloud Connector

Source setup for Square integration in the Layer2 Cloud Connector

Connection string setup for Square data integration in the Layer2 Cloud Connector

Target setup for Square integration in the Layer2 Cloud Connector

Mapping in the Layer2 Cloud Connector for Square data integration

Preview data of Square integration in the Layer2 Cloud Connector

Data of Square ready for integration with SharePoint

Specific Connection Settings for your Square integration

Please copy and paste this connection string into the designated field like described in Step 2.5 of the step-by-instruction above.

OAuthAccessToken=<your_token>;
InitiateOAuth=GETANDREFRESH;

Select statement example:

SELECT * FROM Items;

Find more statements by using this:

SELECT * FROM sys_views;
SELECT * FROM sys_tables;

If this works, you will be able to preview your data already. You will be redirected to a confirmation page from the application access.

Read the whole story: A detailed documentation of how to connect Square with SharePoint on a concrete example.

Intro tutorial

Benefits of using the Layer2 Cloud Connector for your Square data integration

Time saving

Quick and easy installation in just minutes. Combine your data automatically in the background and benefit of better insights and greater revenues.

Multi-talent tool

Sync your Square data one-way or two-way locally or cloud-based and use it for migration, backup, or permanent synchronization projects. It is up to you.

High security

There is no access to your corporate data from the internet and no data transfer will occur to 3rd-parties. You have the full control.

Many setting options

Use the Layer2 Cloud Connecor in a very easy and simple way, or benefit from customizable options and features. You decide.

Many data provider included

Even more easier: Use our own customized providers for common systems. Many more vendor-specific or 3rd party ADO.NET data providers are supported as well.

Cost-effective licensing

3 fully-featured product editions are available: Personal Edition (for one conncetion only), Professional Edition, and Enterprise Edition as our one-stop-shop solution. Have a look at the Buy Now Page.

Get your Free Trial

Connect Square with the following solutions

A

Access

Microsoft Access can be integrated with 100+ IT systems and apps. Access ⇆ 100+

Acquia MySQL integration

Acquia MySQL data can be integrated now with 100+ systems and apps. Acquia MySQL ⇆ 100+

Act! CRM integration

Act! CRM data can be integrated now with 100+ systems and apps. Act! CRM → 100+

Active Directory

Integrate Microsoft Active Directory with IT systems like Office 365 or Sharepoint. Active Directory ⇆ 100+

Active Directory (OLEDB)

Integrate Active Directory (OLEDB read only) with systems like Office365 or SharePoint. Active Directory → 100+

ActiveCampaign integration

Integrate ActiveCampaign with IT systems like Office 365 or Sharepoint. Active Campaign -> 100+

Aha! integration

Integrate Aha! with IT systems like Office 365 or Sharepoint via ODBC Provider. Aha! → 100+

Amazon DynamoDB integration

AWS Amazon DynamoDB data can be integrated with 100+ IT systems and apps. DynamoDB ⇆ 100+

Amazon Redshift integration

Amazon Redshift data can be integrated now with 100+ systems and apps. Amazon Redshift → 100+

Apptivo integration

Integrate Apptivo with IT systems like Office 365 or Sharepoint. Apptivo → 100+

Asana integration

Integrate Asana with IT systems like Office 365 or Sharepoint via ODBC provider. Asana → 100+

Authorize.Net integration

Integrate Authorize.Net with IT systems like Office 365 or SharePoint via our Authorize.Net Provider. Authorize.Net → 100+

Azure Blob Storage integration

Azure Blob Storage data can be integrated now with 100+ systems and apps. Azure Blob Storage ⇆ 100+

Azure DevOps

Azure DevOps data can be integrated with 100+ IT systems and apps. Azure DevOps ⇆ 100+

Azure File Storage

Integrate Microsoft Azure File Storage with IT systems like Office 365 or Sharepoint. Azure File Storage ⇆ 100+

Azure Logic Apps

Azure Logic Apps can be started on external data change.

Azure SQL

Microsoft Azure SQL data can be integrated with 100+ IT systems and apps. Azure SQL ⇆ 100+

Azure Table Storage integration

Azure Table Storage can be integrated with 100+ IT systems and apps. Azure Table Storage ⇆ 100+

B

Bing Search integration

Bing Search data can be integrated with 100+ IT systems and apps. Bing Search → 100+

BlackCompass Visualizer

Inntegrate data of 100+ systems to BlackCompass with the help of Layer2 Data Providers.

Box Documents

Box Documents can be integrated with 100+ IT systems and apps. Box Documents ⇆ 100+

C

C4C Hybris

SAP C4C Hybris data can be integrated with 100+ IT systems and apps. C4C Hybris ⇆ 100+

Capsule CRM integration

Capsule CRM data can be integrated via XML Data Provider. Capsule CRM → 100+

CentralStationCRM integration

CentralStationCRM data can be integrated now with 100+ systems and apps. CentralStationCRM ⇆ 100+

Citrix FileShare integration

Citrix FileShare data can be integrated now with 100+ systems and apps. Citrix FileShare ⇆ 100+

CiviCRM integration

CiviCRM data can be integrated with SharePoint, Office 365, and 100+ other IT systems. CiviCRM → 100+

Cosmos DB

Integrate Cosmos DB with IT systems like Office 365 or SharePoint via Layer2 Provider. CosmosDB ⇆ 100+

Couchbase integration

Couchbase data can be integrated with 100+ IT systems and apps. Couchbase ⇆ 100+

CouchDB integration

CouchDB data can be integrated now with 100+ systems and apps. CouchDB ⇆ 100+

CSV Text

Integrate Comma-separated (CSV) with IT systems like Office 365 or Sharepoint via ODBC provider. Comma-separated (CSV) → 100+

D

Dropbox integration

Dropbox data can be integrated now with 100+ systems and apps. Dropbox ⇆ 100+

Dynamics 365

Microsoft Dynamics 365 (or CRM) can be integrated with 100+ IT systems and apps. Microsoft Dynamics 365 ⇆ 100+

Dynamics 365 Business Central integration

Microsoft Dynamics 365 Business Central (on-premise or online) can be integrated with 100+ IT systems and apps. Dynamics 365 Business Central ⇆ 100+

Dynamics AX

Microsoft Dynamics AX data can be integrated via OData.

Dynamics SL

Microsoft Dynamics SL can be connected via OLEDB.

DynamoDB (Amazon) integration

AWS DynamoDB data can be integrated with 100+ IT systems and apps. DynamoDB ⇆ 100+

E

Elasticsearch integration

Elasticsearch data can be integrated now with 100+ systems and apps. Elasticsearch → 100+

Email integration

Email data can now be integrated with 100+ systems and apps. Email → 100+

Exact Online

Exact Online can be integrated with 100+ IT systems and apps. Exact Online ⇆ 100+

Excel integration

Integrate Excel ⇆ SharePoint or with 100+ more IT systems.

Exchange

Microsoft Exchange Server data (on-premises or online in Office 365) can be integrated with 100+ IT systems and apps. Exchange ⇆ 100+

F

Facebook integration

Integrate Facebook with other IT systems like SharePoint, Office 365, and more. Posts, comments, likes, and other data entities are supported for data sync. Facebook ⇆ 100+

File Server

Microsoft File Server can be integrated with 100+ IT systems and apps. File Server ⇆ 100+

Filemaker

FileMaker database data can be integrated with 100+ IT systems and apps. FileMaker → 100+

Finance and Operations integration

Finance and Operations data can be integrated now with 100+ systems and apps. Finance and Operations → 100+

Firebird

Firebird SQL data can be integrated with 100+ IT systems and apps. Firebird ⇆ 100+

Flow

Integration of a database with Microsoft Flow. 100+ → Flow

Flow (Microsoft)

Microsoft Flow can be connected via a specific Layer2 Data Provider.

FreshBooks integration

FreshBooks accounting can be integrated with 100+ IT systems like SharePoint and Office 365. FreshBooks ⇆ 100+

Freshservice Integration

Integrate Freshservice with IT systems like Office 365 or SharePoint. Freshservice → 100+

FTP integration

FTP data can be integrated now with 100+ systems and apps. FTP ⇆ 100+

G

Gmail integration

Gmail data can be integrated now with 100+ systems and apps. Gmail → 100+

Google Analytics integration

Google Analytics data can be integrated now with 100+ systems and apps. Google Analytics → 100+

Google BigQuery integration

Integrate Google BigQuery data with 100+ IT systems and apps like SharePoint and Office 365. BigQuery → 100+

Google BigQuery via Simba OBDC

Data integration of Google BigQuery via Simba ODBC Provider

Google Calendar integration

Integrate Google Calendar with 100+ IT systems like SharePoint and Office 365. Calendar ⇆ 100+

Google Contacts integration

Integrate Google Contacts with 100+ IT systems like SharePoint and Office 365. Contacts ⇆ 100+

Google Drive

Google Drive data can be integrated with 100+ IT systems and apps. Google Drive ⇆ 100+

Google Search integration

Google Search data can be integrated with 100+ systems and apps. Google Search → 100+

Google Sheets integration

Integrate Google Sheets with 100+ IT systems and apps. Sheets ⇆ 100+

H

HFSQL

HFSQL data can be integrated with 100+ IT systems and apps. HFSQL ⇆ 100+

Highrise

Highrise data can be integrated with 100+ IT systems and apps. Highrise ⇆ 100+

Hubspot integration

Integrate Hubspot with IT systems like Office 365 or Sharepoint. Hubspot ⇆ 100+

Hybris

Hybris data can be integrated with 100+ IT systems and apps. Hybris ⇆ 100+

I

IBM Cloudant integration

Cloudant can be integrated with 100+ IT systems and apps. Cloudant ⇆ 100+

IBM Db2

IBM Db2 database can be connected via its own ODBC data provider. IBM Db2 database can be integrated with 100+ IT systems and apps. IBM Db2 ⇆ 100+

IBM Informix

IBM Informix can be integrated with 100+ IT systems and apps. IBM Informix ⇆ 100+

IBM iSeries AS/400

IBM i (AS/400, iSeries) data can be integrated with 100+ IT systems and apps. IBM iSeries AS/400 ⇆ 100+

IBM Lotus Notes Domino

Integrate Lotus Notes or IBM Domino with IT systems like Office 365 or Sharepoint via ODBC provider. IBM Lotus Notes Domino → 100+

Insightly

Integrate Insightly with IT systems like Office 365 or SharePoint. Insightly → 100+

Intersystems Caché

InterSystems Caché can be integrated with 100+ IT systems and apps. InterSystems Caché ⇆ 100+

Intuit Quickbase

Intuit QuickBase data can be integrated with 100+ IT systems and apps. Intuit QuickBase ⇆ 100+

J

Jira integration

Integrate JIRA by Atlassian with 100+ IT systems and apps. Jira → 100+

Jive integration

Jive data can be integrated now with 100+ systems and apps. Jive → 100+

JSON integration

Any JSON-based web service can be connected to other IT systems, apps and services. JSON ⇆ 100+

K

Knack integration

Knack data integration and synchronization. Integrate Knack with 100+ IT systems and apps. Knack ⇆ 100+

L

LinkedIn integration

Integrate LinkedIn with IT systems like Office 365 or Sharepoint. LinkedIn → 100+

Logic Apps (Azure)

Azure Logic Apps can be started on external data change.

Lotus Notes

Integrate Lotus Notes with systems like Office 365 or SharePoint. Lotus Notes → 100+

M

Magento

Integrate Magento data can be integrated with 100+ IT systems and apps. Integrate Magento ⇆ 100+

MailChimp

MailChimp can be integrated with 100+ systems and apps. MailChimp ⇆ 100+

MariaDB integration

MariaDB data can be integrated now with 100+ systems and apps. MariaDB ⇆ 100+

Microsoft Active Directory

Integrate Microsoft Active Directory with IT systems like Office 365 or SharePoint. Active Directory ⇆ 100+

Microsoft Active Directory (OLEDB)

Integrate Microsoft Active Directory (OLEDB read only) with systems like Office365 or SharePoint. Active Directory → 100+

Microsoft Dataverse Integration

Microsoft Dataverse can be integrated now with 100+ systems and apps. Microsoft To-Do ⇆ 100+

Microsoft Dynamics 365

Microsoft Dynamics 365 (or CRM) can be integrated with 100+ IT systems and apps. Microsoft Dynamics 365 ⇆ 100+

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (on-premise or online) can be integrated with 100+ IT systems and apps. Dynamics 365 Business Central ⇆ 100+

Microsoft Dynamics AX

Microsoft Dynamics AX data can be integrated with 100+ IT systems and apps. Microsoft Dynamics AX ⇆ 100+

Microsoft Dynamics NAV

Microsoft Dynamics NAV can be integrated with 100+ apps and systems. Microsoft Dynamics NAV ⇆ 100+

Microsoft Dynamics SL

Integrate Microsoft Dynamics SL with IT systems like Office 365 or Sharepoint via OLEDB provider. Microsoft Dynamics SL → 100+

Microsoft Excel integration

Integrate Excel ⇆ SharePoint or with 100+ more IT systems.

Microsoft Flow

Integration of a database with Microsoft Flow. 100+ → Flow

Microsoft Graph Integration

Microsoft Graph data can be integrated now with 100+ systems and apps. Microsoft Graph → 100+

Microsoft Office 365 Groups (Data)

Notify your Office Groups members about data changes in 100+ connected external systems via Layer2.

Microsoft Office 365 Groups (Documents)

Documents in Office Groups can be integrated with 100+ IT systems and apps. Microsoft Office 365 Groups (Documents) ⇆ 100+

Microsoft Planner integration

Microsoft Planner data can be integrated now with 100+ systems and apps. Microsoft Planner → 100+

Microsoft Project

Microsoft Project Server data can be integrated with 100+ IT systems and apps. Microsoft Project ⇆ 100+

Microsoft SharePoint

Microsoft SharePoint can be integrated with the help of Layer2 Data Provider for SharePoint

Microsoft Teams

Files in Microsoft Teams can be integrated with 100+ IT systems and apps. Microsoft Teams (Files) ⇆ 100+

Microsoft To-Do integration

Microsoft To-Do data can be integrated now with 100+ systems and apps. Microsoft To-Do ⇆ 100+

Microsoft Windows File Server

Documents on local file server or NAS can be kept in sync with other file sharing services, such as SharePoint, OneDrive, Groups, Teams, or Azure.

Mimer SQL

Mimer SQL can be connected via its own ADO.NET data provider. Mimer SQL can be integrated with 100+ IT systems and apps. Mimer SQL ⇆ 100+

MongoDB Cloud integration

MongoDB Cloud data can now be integrated with 100+ apps and systems like SharePoint and Office 356.

MongoDB On-Prem

MongoDB On-Prem data can be integrated with 100+ IT systems and apps. MongoDB On-Prem ⇆ 100+

MySQL

Two-way synchronization of MySQL ⇆ 100+ Systems

N

Netezza

IBM Netezza DBMS can be integrated with 100+ IT systems and apps. IBM Netezza ⇆ 100+

NetSuite integration

NetSuite can be connected with 100+ IT systems ans apps. NetSuite ⇆ 100+

Nextcloud integration

Integrate Nextcloud with IT systems like Office 365 or Sharepoint. Nextcloud → 100+

Nimble integration

Nimble data can be integrated now with 100+ systems and apps. Nimble → 100+

Nintex Workflow & Forms

Nintex Workflow & Forms can be integrated with 100+ IT systems and apps. Nintex Workflow & Forms ⇆ 100+

Nomadesk

Nomadesk can be integrated with 100+ IT systems and apps. Nomadesk ⇆ 100+

O

OData

OData web services can be used to keep many system in sync with each other using Layer2.

ODBC

ODBC compliant data can be integrated with 100+ IT systems and apps. ODBC ⇆ 100+

Office 365

Microsoft Office 365 can be integrated with the help of our SharePoint Data Provider.

officeatwork Template Chooser

OLEDB

OLEDB compliant data sources can be integrated with 100+ IT systems and apps. OLEDB ⇆ 100+

OneDrive for Business

OneDrive for Business can be integrated with 100+ IT systems and apps. OneDrive for Business ⇆ 100+

OnePageCRM integration

OnePageCRM data can be integrated now with 100+ systems and apps. OnePageCRM → 100+

Open Exchange Rates integration

Open Exchange Rates data can be integrated now with 100+ systems and apps. Act! CRM → 100+

Oracle

Oracle databases can be connected via its own data provider.

P

PayPal integration

Integrate PayPal with 100+ systems and apps for data integration, migration, document synchronization, and backup.

Pervasive PSQL

Pervasive PSQL can be integrated with 100+ IT systems and apps. Pervasive PSQL ⇆ 100+

Pipedrive Integration

Pipedrive data can be integrated now with 100+ systems and apps. Pipedrive → 100+

PipelineDeals integration

PipelineDeals data can be integrated now with 100+ systems and apps. PipelineDeals → 100+

PlumSail

PlumSail Dashboard Designer can be used to easily create dashboards from 100+ data sources in Office 365 and SharePoint via Layer2.

PostgreSQL integration

PostgreSQL data can be integrated now with 100+ systems and apps. PostgreSQL ⇆ 100+

Powershell integration

Data output of PowerShell scripts can be connected with 100+ systems and apps. Powershell → 100+

Progress OpenEdge

Progress OpenEdge (formerly called Progress DB) can be integrated with 100+ IT systems and apps. Progress OpenEdge ⇆ 100+

Progress Sitefinity

Q

Quandl integration

Quandl data can be integrated with 100+ apps and systems. Quandl → 100+

Quickbase

Intuit Quickbase data can be connected via ODBC

Quickbooks Desktop integration

Integrate Intuit QuickBooks Desktop with 100+ other systems. Quickbooks Desktop ⇆ 100+ systems

Quickbooks integration

Integrate Intuit QuickBooks with 100+ other systems: Quickbooks ⇆ 100+ systems

QuoteWerks®

QuoteWerks® is a software used in every industry for creating sales quotes and proposals. Rather than using Microsoft® Word® or Excel® to create your quotes and proposals, you can benefit from a highly specialized tool.

R

Reckon integration

Reckon data can be integrated with 100+ systems and apps. Reckon ⇆ 100+

Redis integration

Integrate Redis with 100+ IT systems like SharePoint and Office 365. Redis ⇆ 100+

RSS News Feed integration

RSS Feeds can be integrated wth 100+ IT systems and apps. RSS Feeds→ 100+

S

Sage ERP/CRM

Sage ERP/CRM can be integrated with 100+ IT systems and apps.Sage ERP/CRM ⇆ 100+

Sage Intacct

Sage Intacct data integration

Salesforce integration

Salesforce data can be integrated with 100+ IT systems and apps. Salesforce ⇆ 100+

Samanage

Integrate Samanage with IT systems like Office 365 or Sharepoint. Samanage → 100+

SAP

SAP data can be integrated with 100+ IT systems and apps. SAP ⇆ 100+

SAP C4C Hybris

SAP HANA

SAP HANA data can be integrated with 100+ IT systems and apps. SAP HANA ⇆ 100+

SAP SQL Anywhere

SAP SQL Anywhere data can be integrated with 100+ IT systems and apps. SAP SQL Anywhere ⇆ 100+

SAS

Integrate SAS Data Management with IT systems like Office 365 or Sharepoint via ODBC provider. SAS → 100+

SendGrid

SendGrid data can be integrated now with 100+ systems and apps. SendGrid ⇆ 100+

Servicenow

ServiceNow Data Integration with 100+ other IT-systems and apps can be managed codeless using the Layer2 Cloud Connector.

SharePoint

Microsoft SharePoint can be integrated with 100+ IT systems and apps. SharePoint ⇆ 100+

Shopify integration

Integrate ypur Shopify with 100+ systems and apps for data integration, document synchronization, migration, and backup.

Smartsheet Integration

Smartsheet data can be integrated with 100+ systems and apps. Smartsheet → 100+

SQL Server

Microsoft SQL Server database data can be integrated with 100+ IT systems and apps. SQL Server ⇆ 100+

SQL Server Analysis Services (SSAS)

SSAS OLAP cube data can be integrated with 100+ IT systems and apps. SSAS OLAP ⇆ 100+

SQLite

SQLite data can be integrated with 100+ IT systems and apps. SQLite ⇆ 100+

Square integration

Square data can be integrated with 100+ IT systems and apps. Square ⇆ 100+

SugarCRM integration

SugarCRM data can be integrated with 100+ IT systems and apps. SugarCRM ⇆ 100+

SuiteCRM integration

SuiteCRM can be integrated with 100+ IT systems and apps. SuiteCRM ⇆ 100+

SurveyMonkey integration

Integrate SurveyMonkey with 100+ systems and apps for data integration, migration, document synchronization, and backup.

System Center Configuration Manager integration

SCCM data can be integrated now with 100+ systems and apps. SCCM → 100+

T

Tempo integration

Integrate Tempo with IT systems like Office 365 or Sharepoint via ODBC Provider. Tempo → 100+

Tockify integration

Tockify data can be integrated with Ninox, SharePoint, Office 365, and 100+ other IT systems. Tockify → 100+

Twitter integration

Twitter data can be integrated now with 100+ systems and apps. Twitter → 100+

V

Visual FoxPro and dBase

Microsoft Visual FoxPro and dBase (DBF) data can be integrated with 100+ IT systems and apps. Microsoft Visual FoxPro ⇆ 100+

Vtiger integration

Integrate vtiger with IT systems like Office 365 or SharePoint. Vtiger → 100+

W

WebDAV integration

WebDAV IIS and in Xampp can be integrated with SharePoint, Office365, and 100+more. WebDAV ⇆ 100+

Windows File Server

Windows File Server data can be integrated with 100+ IT systems and apps. Windows File Server ⇆ 100+

Windows Internal Database

Windows Internal Database, a variation on SQL Server Express, can be integrated with the SQL Client provider.

Wrike integration

Integrate Wrike with IT systems like Office 365 or SharePoint. Wrike → 100+

X

Xero Accounting integration

Xero accounting software data can be integrated with 100+ IT systems and apps. Xero accounting integration ⇆ 100+

XML integration

XML data can be integrated now with 100+ systems and apps. XML → 100+

Y

YouTube integration

Integrate YouTube with IT systems like SharePoint. Youtube → 100+

Z

ZappySys integration

ZappySys data can be integrated now with 100+ systems and apps. ZappySys ⇆ 100+

Zoho Creator integration

Zoho Creator can be integrated via the Layer2 Data Provider for XML. Zoho Creator → 100+ Systems

Zoho CRM

Integrate Zoho CRM with IT systems like Office 365 or Sharepoint via Layer2 Data Provider for XML. Zoho CRM → 100+

Take your next steps

Any Questions?

Drop us a short note with your enquiry by filling out the contact us form.

Contact us

About the Layer2 Cloud Connector

Get more information about the Layer2 Cloud Connector on the product page.

Learn more

Register for a free trial

Get your free trial version of the Layer2 Cloud Connector by a quick registration.

Register now