Sharepoint

How to Integrate Denodo to access Excel file in Sharepoint

Create Data Source Excel Connection.

e.g ds_sp_excel

Property in the connection

Type of File Set to "Excel 2007 or later"

Data Route Set to "http Client"

HTTP Method Set to Get

Base URL Set to "Root URL/@foldername/@filename"

Authentication Section

Authentication Set to NTLM

Credential Set your connection credential in Login / Password / Domain. Your credential should be your service account which granted right to read the respective Site and Folder.

Integrate a single File

To create a view to read single file, you simply For Single File: Do we need to create one unique DS and Unique View ?