Accessing SharePoint 2013 using SQL

SELECT * FROM Calendar in SharePoint 2013

SELECT * FROM Calendar in SharePoint 2013

SearchBlox allows you to search lists, calendars, announcements, tasks, contacts, document names and issues using plain SQL through our Database collection. Just pick the SharePoint connector, set the site url, username and password along with SQL to access the data from SharePoint 2013.

Connection String for SharePoint 2013 access

jdbc:sharepoint:user=myuseraccount;password=mypassword;Auth Scheme=NTLM;URL=http://sharepointserver/mysite;

SQL Statement to access calendar items

SELECT * FROM Calendar

SearchBlox simplifies access to SharePoint for data analysis and visualization. Text can be analyzed for sentiment analysis and entity extraction through our natural language processing (NLP) module.

Contact Us to learn more about enabling access to SharePoint 2013 through SearchBlox.