SQL List
Last updated
Last updated
Copyright Β© 2009 - 2023
You can use not only SharePoint lists as data sources but also data from SQL databases. To add an SQL list as a data source, browse to the βData Source Settingsβ block and use βCreate New Source.β
Type the SQL server name, enter a username and password, and then click βBrowseβ to choose the required database from the list.
The list of available databases will be displayed. Select the required one.
Then, select a table from which you will import items. If you want to move and edit events imported from the SQL list later, check the box βPrimary Key Fieldβ and define it. Otherwise, you will only be able to view the imported items.
You can sort events in the SQL table using the βORDER BYβ option.
Next, define other settings as described for SharePoint list data sources and click βSave.β
The SQL list will appear in the list of data sources. Click βOKβ to return to your calendar. Events from your SQL database will be displayed on the calendar.
You can create new events in the selected database using the Virto SharePoint calendar. If you delete the SQL list data source, items will disappear from the calendar but will be saved in the database on the SQL server.