JDBC Driver for Excel

Build 20.0.7503

Connecting to Storage Sources

Below are example connection strings and queries to Excel storage sources.

Service provider URI formats Connection example Query example (if the specified excel file contains Sheet1)
HTTP or HTTPS http://remoteStream

https://remoteStream

URI=http://www.host1.com/test.xlsx; SELECT * FROM Sheet1
Amazon S3 s3://bucket1/file; URI=s3://bucket1/test.xlsx; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; SELECT * FROM Sheet1
Wasabi wasabi://bucket1/file; URI=wasabi://bucket1/test.xlsx; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; SELECT * FROM Sheet1
Azure Blob Storage azureblob://mycontainer/myblob/ URI=azureblob://mycontainer/test.xlsx; AzureAccount=myAccount; AzureAccessKey=myKey; SELECT * FROM Sheet1
Google Drive gdrive://remotePath URI=gdrive://test.xlsx; InitiateOAuth=GETANDREFRESH; SELECT * FROM Sheet1
Box box://remotePath URI=box://test.xlsx; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345; SELECT * FROM Sheet1
Dropbox dropbox://remotePath URI=dropbox://test.xlsx; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345; SELECT * FROM Sheet1
AzureDataLakeStoreGen2 abfs://myfilesystem/remotePath URI=abfs://myfilesystem/test.xlsx; AzureAccount=myAccount; AzureAccessKey=myKey; SELECT * FROM Sheet1
AzureDataLakeStoreGen2 with SSL abfss://myfilesystem/remotePath URI=abfss://myfilesystem/test.xlsx; AzureAccount=myAccount; AzureAccessKey=myKey; SELECT * FROM Sheet1
FTP or FTPS ftp://server:port/remotePath

ftps://server:port/remotepath

URI=ftps://localhost:990/test.xlsx; User=user1; Password=password1; SELECT * FROM Sheet1
SFTP sftp://server:port/remotePath URI=sftp://127.0.0.1:22/test.xlsx; User=user1; Password=password1; SELECT * FROM Sheet1
Sharepoint sp://remotePath URI=sp://Documents/folder1/test.xlsx; User=user1; Password=password1; SharepointUrl=https://subdomain.sharepoint.com; SELECT * FROM Sheet1

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7503