Knowledge Base Article

Use CSV and Excel From Hosting File Sites - FTP/S3/DropBox/GoogleDrive etc'

When using one of the file hosting sites (HTTP or HTTPS, Amazon S3, Azure Blob Storage, Google Drive, Box, Dropbox, Sharepoint, AzureDataLakeStoreGen2, AzureDataLakeStoreGen2 with SSL, FTP or FTPS, SFTP) you are able to connect to that DB by using our partner CData JDBC driver.
The CSV Driver can be downloaded here and connection string for the various provider can be found here
And installed using Sisense documentation
Make sure to add RowScanDepth=0; variable 
Example - for FTPS with user name and password
jdbc:csv:URI="ftps://sitename.sisense.com:990/customer data";RowScanDepth=0;
mceclip0.png
Updated 02-21-2024
No CommentsBe the first to comment