​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint can connect almost any data source including the new Microsoft Access Web Apps in SharePoint Online. For any questions please use the FAQ Web Form or contact [email protected] directly.

How to create, publish and integrate Access Web Apps with SharePoint Online

You can connect and synchronize data from Microsoft Access Web Apps in SharePoint Online or on-premise with external data sources or native SharePoint lists, if required. The options are shown below step-by-step.

 

SharePoint-Online-Access-App-1.PNG
Fig.: Create an Access Web App using your local Office Access software
 
 You can select between several templates or start from scratch. You have to give a name and location.
 
SharePoint-Online-Access-App-2.PNG
 
Fig.: Enter your SharePoint Online web site as a storage location.
 
As a next step create your tables and forms using Microsoft Access. In this sample we are going to host a RSS news feed archive (just as a sample). First we create the appropiate table and fields required, e.g. a link, a title, a description and additional information like the publication date and source.
 
 
SharePoint-Online-Access-App-3.PNG
Fig.: Create the data table RSS in Microsoft Access 
 
As a next step we create the forms to display and manage in the app later on in a web browser.
 
SharePoint-Online-Access-App-4.PNG
Fig.: Create a form to display and manage the data
 
When you are finished with the data structure and forms simply publish the app. The web app is created automatically, it can be found at your SharePoint Online web site under web site settings > apps. Additionally a SQL Azure database is created automatically to keep the data. Now lets take a look, how to connect the SQL Azure data table to any external data, e.g for import or permanent synchronization. You can find out where your data lives directly in the Microsoft Access Info menu tab.
 
SharePoint-Online-Access-App-6.PNG
Fig.: Access database connectivity information for SQL Azure
 
Now, as we are know where the data is hosted, we can simply connect using the Layer2 Cloud Connector.
 
SharePoint-Online-Access-App-9.PNG
 
Fig.: Connecting the newly created Access Web App database using the Layer2 Cloud Connector
 
To connect to Azure please
  • select the SQLClient Data Provider
  • enter an appropiate connection string for SQL Azure
  • enter a select statement to your data table created previously (any SQL allowed)
  • enter a primary key required for replication

Please verify all settings and display the data preview to take a look.

Now we have to create the external data source, e.g. a RSS News Feed (just as a sample).

 

SharePoint-Online-Access-App-8.PNG
 Fig.: Data Entity settings for the RSS Feed as data source for the SQL Azure table.

To connect to any RSS Feed, please:

  • Select the RSS Data Provider (included in Cloud Connector Package).
  • Enter a valid connection string for RSS feeds. In most cases the URL to the feed is enough.
  • Enter a primary key (unique column), e.g. link or GUID if provided by the feed.

You can aggregate several feeds. Please use comma as delimter, e.g. Url=url1,url2,url3, if required.

Please verify all settings and display the preview data. As a next step please map the external data feed fields (RSS Feed) to the App data table (SQL Azure) in the mapping section of the Layer2 Cloud Connector. You can simply use the auto-mapping feature in this case because of simiar names on both sides.

 

SharePoint-Online-Access-App-mapping.PNG

  Fig.: Field mapping of both data source (RSS Feed) and destination (SQL Azure).

 

Please verify the mapping. Now you are ready to run the connection first time - manually in the Connection Manager (for testing) or in background (later on) using the Cloud Connector Windows service.

 

SharePoint-Online-Access-App-10.PNG

 Fig.: Sample Connection settings to sync the RSS News Feed with SQL Azure used by the Access Web App 

 
While the data entities are in sync now, just take a look at your Access Web App in SharePoint Online.
 
SharePoint-Online-Access-App-7.PNG
 
Fig.: Access Web App in SharePoint Online connected to an external RSS Feed by the Layer2 Cloud Connector.
 
Please note:
  • You can search for titles directly in the Access Web App and select any title in list to provide the details.
  • You can manage large data sets, no 5.000 items list view threshold - because it's SQL Azure, not a SharePoint list.
  • The form layout and field attributes are very basic at this time with Access Web Apps, e.g. no HTML Field. But you can modify at any time.
  • Connecting to RSS was just a sample, you can connect to almost any other external data source via the Layer2 Cloud Connector, including native SharePoint lists.
  • You can add the SQL Azure table or query as a SharePoint External List via BCS, if required for improved integration.
  • You can also sync the SQL Azure table directly with a native SharePoint list for maximum integration, e.g. alerts, workflows, SharePoint search integration etc.
  • Please note that this sample is not about bulk import. Only new source data is added to the data destination or modified / deleted, if required.
  • Data source and data destination are connected only while syncing (just for seconds). Your SharePoint users do access native SQL Azure tables with high performance and availability.
  • The "no delete" option in the data destination entity opens up the way to data aggregation.
  • You can aggregate multiple RSS News Feed sources to one list (e.g. in one connection string as shown above) or with different connections.
  • The Layer Cloud Connector is a no-code solution, but you can write your own data provider if required. The Layer2 Data Provider for RSS is included with source code as a good starting point. You can also make use of any 3rd party provider like ODBC, OLEDB, OData, XML or any database provider, like e.g. Oracle.
  • You will find more connectivity options here.

Next steps

Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

I must say how impressed I am with the functionality of the Layer2 Cloud Connector. This is going to be so useful for us.

 

 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
Contact
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

Layer2 now connects 100+ commonly used IT systems with Twitter via its Layer2 Cloud Connector

The Layer2 Cloud Connector is now able to connect Twitter to integrate data to a wide range of IT backend systems including Office 365, SharePoint, SQL, ERP/CRM.

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.
Related Downloads
PDF Image

Cloud Connector Instruction

Download this step-by-step instruction to connect and sync your corporate or cloud data sources bi-directional to any native SharePoint 2010/2013/2016 list or library, including Microsoft Office 365.
PDF Image

Feasibility Study: Connecting local SQL Server to SharePoint Online

The study compares different approaches for SharePoint Online data integration regarding performance, features, security and investment.
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

Layer2 Case Study: Cloud Connector helps ChemWerth to integrate the Microsoft Office 365 Cloud

"The Cloud Connector’s interface is easy to understand and use. Anyone familiar with utilities in the Microsoft stack will be productive immediately. Our recommendation: The Layer2 Cloud Connector is a no brainer.”
NoDoc Image

Layer2 Cloud Connector PAD File

This XML-based PAD file offers a Layer2 Cloud Connector product description for resellers to download and publish.
PDF Image

Office 365: How to sync with MS Dynamics CRM

You can sync any CRM data with native lists in SharePoint on-prem or online to make it available offline with Outlook.
PDF Image

Office 365: How to sync with SAP?

You can connect SharePoint and Office 365 with SAP via NetWeaver and OData.
PDF Image

Office 365: How to sync your local file share?

When you are moving to the cloud, there are a lot of reasons to keep your local file system. But you don't have to miss the benefits of the cloud.
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: 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.
PDF Image

Solutions Flyer: Data Integration with SharePoint, Office 365 and 100+

FileMaker can be integrated with 100+ other sources codeless using the Layer2 Cloud Connector.
Related Links

Layer2 Cloud Connector Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join the Cloud Connector Community Group to share your experience.

Microsoft Partner Story Book for Office 365 about Cloud Connector

​Know more about a Layer2 Cloud Connector customer reference at the Microsoft Office web site.

Purchase Layer2 Cloud Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.

 

cs-award-top-100-publisher-2014-15-large.gif

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.