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;
0 comments
