Azure Table Storage Integration and Synchronization

 

 

Azure Table Storage data can be integrated and synchronized codeless with various other data sources using the Layer2 Cloud Connector via 3rd party data providers. Please take a look here for supported target systems and applications like SQL, Office 365, SharePoint, Exchange, Dynamics and others.​​​​​

 

​Azure Table Storage offers highly available, massively scalable storage, so that your application can automatically scale to meet user demand. Azure Table storage is Microsoft’s NoSQL key/attribute store – it has a schemaless design, making it different from traditional relational databases. With this design it's easy to adapt your data as the needs of your application evolve.

 

Azure Storage Integration & Synchronization Layer2

 

Fig.: Configuring Azure Table Storage in the Microsoft Cloud. 

 

To connect to Azure Table Storage the source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

 

Integrate Azure Table Storage Configuration Settings

 

Fig.: Sample connection configuration to connect to Azure Table Storage via Layer2 Cloud Connector.

Azure Table Storage Specific Integration Settings

 

​Please note the following Azure Table Storage specific settings.

 

  • Install the RSSBus ADO.NET Provider for Azure, also available from CDATA.com. This provider is not part of the Layer2 Cloud Connector ADO.NET provider package and should be installed separately from the vendor's product page. It requires extra licensing.
  • Choose “RSSBus ADO.NET Provider for Azure” (exact name might vary) as “Data Provider” for your data entity (source and / or destination).
  • Follow the vendor instructions for setting up the connection string and select statement (see below for samples).
  • Set the connection string as required, e.g. Account=myStorageAccount; Access Key=myAzureStorageKey.
  • “autocache=true” cases the provider to always read the live data and not rely on cached data.
  • Set the data query as required, e.g. SELECT * FROM myAzureStorageTable.
  • Please ensure that you map PartitionKey and RowKey and that the combination their values is always unique as this is a requirement from Azure Table Storage – for more information please refer to Designing a Scalable Partitioning Strategy for Azure Table Storage
  • You can map your Azure Table Storage data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • No installation or changes are required at the Azure Table Storage data source or data destination.
  • 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 Codeless Azure Table Storage Integration And Synchronization

 

Just some ideas what to connect next:

 

  • Sync with Microsoft Exchange (on-premises or online) for calendar events and appointments, mobile access and offline availability on any device. Public folders also supported.
  • Sync with 3rd party tools like ERP/CRM/CMS 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. Change notofications and workflows fully supported.
  • Integrate with Microsoft Dynamics CRM/ERP/NAV etc.
  • Connect to SAP via NetWeaver and OData or Hana.
  • More supported systems and applications to connect with Azure Table Storage.

FIND RELATED SOLUTIONS HERE.

Learn more about similar solutions for data migration, backup, integration, and synchronization by vendor and topic.

Ready to go next steps?

Register for free download.

Keep your Sharepoint in sync. Download and try today.

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.