How to display events from SQL list in Virto Office 365 calendar

The simple solution to add events from a SQL database to Office 365 calendar

Business Requirements

Add events from a SQL database to Office 365 calendar

Virto Software Components Used

Office 365 Calendar add-in

Solution Summary

Carnegie Hall in NY requires a SharePoint Online calendar that syncs with their SQL event lists.

Virto SharePoint Calendar web part for SharePoint 2016, 2013, 2010 or 2007 has the ability to overlay events from external data sources including Exchange Calendar, Google Calendar, SalesForce Calendar, SQL Tables and XML.

But Virto SharePoint Online Calendar does not support direct connection to SQL Server. However, you can add a SQL list to your Office 365 calendar with a few simple steps. You need to create External Content Type for your SQL server table and then create External List in your SharePoint Online which will display events from your SQL table. Then you can use this list as datasource for Virto Calendar for SharePoint Online. 

What to do:

Where to do it:

Step 1: Set permissions on the BCS Metadata Store  

SharePoint admin center (in SharePoint Online)

Step 2: Create a Secure Store Mapping

SharePoint admin center (in SharePoint Online)

Step 3: Create an External Content Type (ECT)

SharePoint Designer 2010 OR Visual Studio

Step 4: Create an External List

SharePoint admin center (SharePoint Online)

Step 5: Grant permissions to manage your ECT

SharePoint admin center (SharePoint Online)

Step 6: Select External List as a data source 

Virto Office 365 calendar settings

Learn more how to create External List from SQL Azure Table.

Now you can add created SQL list as a regular data source to any of your Office 365 calendars. 

3sql.PNG

Now you can overlay any number of SharePoint calendars, external SQL lists, Exchange Online Calendars, including Meeting rooms, in a single view of Virto Office 365 Calendar Add-in.