This will require Data Admin privileges to setup and Builder for implementation.
SQList for SharePoint
Creating a JDBC connection is the preferred way to derive data into iDashboards. There are known limitations connecting to SharePoint Lists that make a JDBC connection directly to the List prohibitive. However there are other options available for connecting iDashboards to SharePoint Lists. One such option tested is the product from AxioWorks called SQList. This is the preferred method of having SharePoint Lists as a data source and is partially supported by the iDashboards Support Services team. When installed, the SQList service acts as a middleware between an installed MS SQL Server database (2000 – 2008 including SQL Server Express) and a SharePoint Lists. Once configured, the AxioWorks SQList service pulls data from SharePoint Lists and creates tables in one or more specified SQL Server databases. Users can then create an iDashboards SQL Server data source that connects to the database that contains the derived SQList SharePoint List data.
- Download SQList
- Installation and Instructions
- The trial version of SQList Professional provides you with:
- The ability to export up to 20 SharePoint sites...
- ...to a maximum of 20 SQL Server databases
- Full functionality for 30 days
- The trial version of SQList Professional provides you with:
SQList is available for purchase in three version based on the customers needed features; SQList Entry, SQList Standard, and SQList Professional.Advantages:
- The SQList service automatically creates the necessary tables in the SQL Server database to
match the SharePoint lists.
- The SQList service exports SharePoint list data to single or multiple SQL Server databases.
- The SQList service can write to SQL Server databases that reside on a different server i.e. not the same server as where Sharepoint or SQList software are installed.
- The table names created by the SQList service will have the SharePoint site name appended to them: SharePointSiteName:SharePointListName
- The SQList service is continuously running behind the scenes so the data in the database is
refreshed automatically every time there is a change made to the SharePoint list. The SQList
service will modify the data in the database as rows are modified in the SharePoint list.
Refreshing or reopening the dashboard will return the most recent data from the database.
- Since iDashboards is connected to the MS SQL Server database using JDBC, there is more control when it comes to writing SQL Queries and stored procedures on SharePoint List database.
- The iDashboards Support Services team will support the connection to the SQList database.
- The SQList service does not provide a direct connection to SharePoint Lists from iDashboards.
- The SQList service cannot connect to a SharePoint website that is hosted across the Internet, from a Microsoft server or otherwise.
- The very First column of the SharePoint list will always have the column header of Title in the SQL Server database. This cannot be changed as it is a SharePoint requirement.
- Any changes made to the SharePoint List column headers will not get replicated in the SQL
Server tables as this is a SharePoint limitation.
- The tables that are created by the SQList service in SQL Server contain some additional columns containing referential data that might not be required for creating charts. Additional Columns: ID, ContentType, Modified, Created, Author, Editor and GUID.
- The SQList service will need an additional SQL Server database if one is not available from the customer.
- The iDashboards Support Services team will not support the installation and maintenance of the AxioWorks SQList product. iDashboards recommends SQList but does not have a partnership with AxioWorks.
CDATA for SharePoint
iDashboards is able to connect to Microsoft SharePoint API by using a JDBC driver. A JDBC driver is a software component enabling a Java application to interact with a database. To connect with individual databases, JDBC (Java Database Connectivity API) requires specific drivers for each database. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between the client and the database. iDashboards implements native protocols and does not require additional software installed on the driver host. In other words, iDashboards provides driver connectivity with the JDBC Data Source via the specified driver. This document explains a step-by-step procedure to create the Data Source with a Premium Data Connector.
CData JDBC Driver for SharePoint is where we get the documentation on making this connection, however, the Premium Data Connectors are not a straight forward process which is why we make articles like this to help you make the connections more easily. The SharePoint API data connector is part of the Premium Data Connectors if you do not have these please contact your Client Success Manager.
Unfortunatley, after extensive testing from the the Technical Support Engineers, we have been unable to connect to any useful data. It is a driver to get stats on the actual SharePoint, not the data inside. we do not think there is a conduit between SharePoint and data inside of articles (or files attached to them) that we are aware of. We have tried a variety of different options and nothing will allow it to connect to actual data within SharePoint.
For More Information:
- Creating a Database URL (Connection String)
- MS SharePoint Documentation
- iDashboards Admin Manual 10. Managing Data Sources
Disclaimer: iDashboards Technical Support Engineers are not proficient in the Management and Integration of every API that exists as new APIs are being created everyday with each company that wants to provide seamless integration with other software. However, we do our best to help you make these connections because we want to assist you in your success. If you do not see an article for a connection you would like to make please contact iDashboards Support and know that it will take a bit of time to figure out what is necessary for this integration.
If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.