XML Codeless Data Integration Synchronization

Highrise data can be integrated and synchronized codelessly with various other data sources using the Layer2 Cloud Connector via the Layer2 Data Provider for XML. Please take a look here for supported systems and applications.

Highrise Integration with Office 365, SharePoint and 100+

Highrise is known to be a secret weapon to track tasks, contacts, and notes in the cloud. To connect to Highrise data, the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

Highrise-Data-Integration-Synchronization.PNG

 

Fig. Example connection configuration to connect to the Highrise Deals data.

Highrise Specific Configuration Settings

​Please note the following specific settings.
  • Select the Layer2 Data Provider for XML to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed. You will find a Layer2 Data Provider for XML specification here.
  • You can use a connection string like this to connect:
    url=https://<mycompany>.highrisehq.com/deals; Authentication=Windows; User=<AccessToken>; Password=x
  • Highrise uses HTTP Basic authentication, so please use the "Windows" authentication method.
  • The User parameter is your unique API access token, which you can find on the "My Info" screen in the Highrise UI (click the "Reveal authentication token for feeds/API" link).
  • The Password parameter uses a dummy value (set as "x" in the example above). The token acts as the username and password, but you still have to define something for the password field (don't leave it blank).
  • You can make use of Xpath to query your data as supported by the data provider and source system. You can map your data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported). See the Highrise API reference for what data is available.
  • Please enter an appropriate primary key (column with unique values - "account-id" in this example), depending on query (see data preview for this).
  • The data provider supports read-only, no write support to the Highrise XML data source.
  • Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.

Step-by-Step Intros for Highise Integration and Synchronization Scenarios

​The following step-by-step intros are available:

Just some other ideas:

  • Export XML from any enterprise system, e.g. ERP/CRM/CMS or database to connect to almost any other system.
  • Sync with local SQL or SQL Azure for better reporting.
  • Sync with Microsoft Exchange (on-premises or online) for notifications, tasks, calendar events, mobile access and offline availability on any device.
  • Sync with 3rd party tools based on SQL databases like Oracle, mySQL, or Microsoft SQL Server.
  • Sync with Microsoft SharePoint or Office 365 for better collaboration (for example with customers or partners) or for intranet publishing.

Do you already have implemented any specific scenario? Just let us know to add it here. Can't find what you are looking for? Please contact [email protected] for help.

Next Steps For Evaluation

​​​​You can register to download and evaluate the Layer2 Cloud Connector here.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

The product works! Transferring, adding, deleting data between SharePoint and SQL is easy once the data connections are setup properly. The setup is not always intuitive but it is just a learning curve and the support staff is very helpful.

 

 Download & Evaluation

 
Please register now to receive your free personal download link via email to your valid company email address.
Name: 
Company: 
Country: 
Phone: 
E-mail: 
Yes, I accept the licensing terms and conditions
How to buy this product

With the free Shareware Edition you can manage a limited number of items per connection. To order a license for the full version please click the shopping cart below.

Layer2 Cloud Connector
License List price Buy Now
FREE Shareware Edition * $0.00
FREE App Edition *
App Store only
$0.00 Go to App Store
Personal Edition
1 Single Server
License (one-time fee)
$499.00 Add to Shopping Card
1 Annual Software Assurance
for Personal Edition
$99.00 Add to Shopping Card
Professional Edition
1 Single Server
License (one-time fee)
$1,407.00 Add to Shopping Card
1 Annual Software Assurance for Professional Edition $281.00 Add to Shopping Card
Enterprise Edition **
1 Single Server
License (one-time fee)

$6,390.00

$1,290.00

File Sync Edition***
1 user annual subscription
$150.00
Prepaid Remote Support
1 Hour
$176.00 Add to Shopping Card
Please contact [email protected] in case you want to order directly via Layer2 based on quote, invoice and bank transfer to Germany.

 

* The Shareware Edition and App Edition is limited to sync 25 items per connection.

** Starting with January 2015 all features of the Enterprise Edition are already included in the Professional Edition.

*** The File Sync Edition is limited to local file synchronization with any specific Office 365, SharePoint or OneDrive4B. The license is per user annually with a minimum of 50 licenses. Not yet available for online order. Please contact [email protected] if interested.

Related Contacts
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related News

New Microsoft Teams Connectors: Layer2 adds 100+ typically used backend systems

​The Layer2 Cloud Connector is now able to connect to Microsoft Teams to quickly integrate more than 100 IT backend systems including local SQL, ERP/CRM.

Oracle now fully integrated with Microsoft Office 365 via Layer2 Cloud Connector

​100+ most common IT-systems and apps like SQL, ERP/CRM are supported for Oracle data integration and sync, as well as Microsoft Office 365, SharePoint, Dynamics, Exchange, Office Groups, and Azure.
Related Downloads
PDF Image

Product Flyer: Business Data List Connector for SharePoint

SharePoint on-premises external data integration with 100+ sources: Product flyer (PDF) in English for download.
PDF Image

Product Flyer: Cloud Connector for Microsoft SharePoint & Office 365

Flyer with features, benefits & pricing info for download as PDF.
PDF Image

Product Flyer: Layer2 Knowledge Management Suite for SharePoint

Assign accurate managed metadata automatically to SharePoint items and documents.
PDF Image

Product Flyer: SharePoint Online Local File Server Sync

You can centrally migrate, synchronize, or backup your local file server department shares and home drives very flexible with SharePoint Online to close known gaps and overcome limitations of the Microsoft OneDrive for Business client.