SharePoint Online Excel to Sisense Linux ElastiCube via Custom JDBC

The CData JDBC Driver for Microsoft SharePoint Excel supports retrieving Excel data from SharePoint On-Premises via the REST API and the OData API introduced in SharePoint 2013. It is compatible with Microsoft SharePoint 2013 and 2016.

For newer environments such as Microsoft SharePoint Online, the appropriate driver is the CData JDBC Driver for Microsoft Excel Online.

Step-by-Step Guide: 

1. Download the Driver

   Download the CData JDBC Driver for Microsoft Excel Online from Sisense Certified Connectors site
   

2. Install the Driver on Your Local Machine 

1. 1. Extract the downloaded .zip file.
   2. Run "java -jar setup.jar" or "java -jar setup.jar -console" .
      1. If Java is not installed, please install the Java Runtime Environment (JRE), or run the installer on a machine where JRE or JDK is already available. 
      2. The default installation path of version 2025 in the Windows environment is:
         C:\Program Files\CData\CData JDBC Driver for Microsoft Excel Online 2025

2. Configure the Connector in Sisense

   1. 1. 1. Log in to Sisense as a user with Admin privileges.
         2. Open Configuration Manager:
            Admin > Server & Hardware > System Management > Configuration
         3. Scroll to the bottom and click Manage Connectors.
         4. In the left pane, click +JDBC Connector.
         5. Fill in the required fields on the Create JDBC Connector page:
            1. Connector ID: Excel_Online
            2. Display Name: Excel Online
            3. Class Name: cdata.jdbc.excelonline.ExcelOnlineDriver
            4. Upload JAR File: Upload cdata.jdbc.excelonline.jar from the /lib directory of the installed driver, e.g.:
               C:\Program Files\CData\CData JDBC Driver for Microsoft Excel Online 2025\lib\cdata.jdbc.excelonline.jar
         6. Click "create" to register the connector.

Conclusion

Once these steps are completed, the Excel Online connector will be available in your Sisense environment.

To establish a connection, you must include the following parameter in your connection string:

• SharepointURL=https://mysite.sharepoint.com/

For additional required parameters and configuration details, please refer to the official CData JDBC Driver documentation:

•  CData JDBC Driver for Microsoft Excel Online: Establishing a Connection.

References/Related Content

• https://www.cdata.com/solutions/bi/sisense/
• https://docs.sisense.com/main/SisenseLinux/connecting-to-sharepoint-excel-services.htm
• https://docs.sisense.com/main/SisenseLinux/deploying-a-custom-connector.htm