Connecting to Microsoft Access Data Sources
Connecting to Microsoft Access
Below are example connection strings to MS Access database files or streams, using the add-in's default data modeling configuration (see below)
| Service provider | DataSource formats | Connection example |
| Local | File Path file://localPath/MyDatabase.accdb | DataSource=C:/folder1/MyDatabase.accdb; |
| HTTP or HTTPS | http://remoteStream https://remoteStream | DataSource=http://www.host1.com/streamname1; |
| Amazon S3 | File Path s3://remotePath/MyDatabase.accdb | DataSource=s3://bucket1/folder1/MyDatabase.accdb;AWSSecretKey=secret1;AWSRegion=OHIO; |
| Azure Blob Storage | File Path azureblob://mycontainer/myblob/MyDatabase.accdb | DataSource=azureblob://mycontainer/myblob/MyDatabase.accdb;AzureStorageAccount=myAccount;AzureAccessKey=myKey; DataSource=azureblob://mycontainer/myblob/MyDatabase.accdb;AzureStorageAccount=myAccount;AuthScheme=OAuth; |
| Google Drive | File Path gdrive://remotePath/MyDatabase.accdb gdrive://SharedWithMe/remotePath/MyDatabase.accdb | DataSource=gdrive://folder1/MyDatabase.accdb;AuthScheme=OAuth; DataSource=gdrive://SharedWithMe/folder1/MyDatabase.accdb;AuthScheme=OAuth; |
| One Drive | File Path onedrive://remotePath/MyDatabase.accdb onedrive://SharedWithMe/remotePath/MyDatabase.accdb | DataSource=onedrive://folder1/MyDatabase.accdb;AuthScheme=OAuth; DataSource=onedrive://SharedWithMe/folder1/MyDatabase.accdb;AuthScheme=OAuth; |
| Box | File Path box://remotePath/MyDatabase.accdb | DataSource=box://folder1/MyDatabase.accdb;AuthScheme=OAuth; |
| Dropbox | File Path dropbox://remotePath/MyDatabase.accdb | DataSource=dropbox://folder1/MyDatabase.accdb;AuthScheme=OAuth;OAuthClientId=oauthclientid1;OAuthClientSecret=oauthcliensecret1;CallbackUrl=http://localhost:12345; |
| SharePoint SOAP | File Path sp://remotePath/MyDatabase.accdb | DataSource=sp://Shared Documents/folder1/MyDatabase.accdb;User=user1;Password=password1;StorageBaseURL=https://subdomain.sharepoint.com; |
| SharePoint REST V1 | File Path sprestv1://remotePath/MyDatabase.accdb | DataSource=sprestv1://Shared Documents/folder1/MyDatabase.accdb;User=user1;Password=password1;AuthScheme=NTLM;StorageBaseURL=http://sharepointserver/sites/mysite; DataSource=sprestv1://Shared Documents/folder1/MyDatabase.accdb;AuthScheme=AzureAD;StorageBaseURL=https://subdomain.sharepoint.com/sites/mysite; |
| SharePoint GRAPH | File Path spgraph://remotePath/MyDatabase.accdb | DataSource=spgraph://Shared Documents/folder1/MyDatabase.accdb;AuthScheme=OAuth;StorageBaseURL=https://subdomain.sharepoint.com; |
| FTP or FTPS | File Path ftp://server:port/remotePath/MyDatabase.accdb ftps://server:port/remotepath/MyDatabase.accdb | DataSource=ftps://localhost:990/folder1/MyDatabase.accdb;User=user1;Password=password1; |
| SFTP | File Path sftp://server:port/remotePath/MyDatabase.accdb | DataSource=sftp://127.0.0.1:22/folder1/MyDatabase.accdb;User=user1;Password=password1; DataSource=sftp://127.0.0.1:22/folder1/MyDatabase.accdb;SSHAuthmode=PublicKey;SSHClientCert=myPrivateKey |
| Azure Data Lake Store Gen1 | File Path adl://remotePath/MyDatabase.accdb adl://Account.azuredatalakestore.net@remotePath/MyDatabase.accdb | DataSource=adl://folder1/MyDatabase.accdb;AuthScheme=OAuth;AzureStorageAccount=myAccount;AzureTenant=tenant; DataSource=adl://myAccount.azuredatalakestore.net@folder1/MyDatabase.accdb;AuthScheme=OAuth;AzureTenant=tenant; |
| Azure Data Lake Store Gen2 | File Path abfs://myfilesystem/remotePath/MyDatabase.accdb abfs://[email protected]/remotepath/MyDatabase.accdb | DataSource=abfs://myfilesystem/folder1/MyDatabase.accdb;AzureStorageAccount=myAccount;AzureAccessKey=myKey; DataSource=abfs://[email protected]/folder1/MyDatabase.accdb;AzureAccessKey=myKey; |
| Azure Data Lake Store Gen2 with SSL | File Path abfss://myfilesystem/remotePath/MyDatabase.accdb abfss://[email protected]/remotepath/MyDatabase.accdb | DataSource=abfss://myfilesystem/folder1/MyDatabase.accdb;AzureStorageAccount=myAccount;AzureAccessKey=myKey; DataSource=abfss://[email protected]/folder1/MyDatabase.accdb;AzureAccessKey=myKey; |
| Wasabi | File Path wasabi://bucket1/remotePath/MyDatabase.accdb | DataSource=wasabi://bucket/folder1/MyDatabase.accdb;AccessKey=token1;SecretKey=secret1;Region='us-west-1'; |
| Google Cloud Storage | File Path gs://bucket/remotePath/MyDatabase.accdb | DataSource=gs://bucket/folder1/MyDatabase.accdb;AuthScheme=OAuth;ProjectId=test; |
| Oracle Cloud Storage | File Path os://bucket/remotePath/MyDatabase.accdb | DataSource=os://bucket/folder1/MyDatabase.accdb;AccessKey='myKey';SecretKey='mySecretKey';OracleNameSpace='myNameSpace' Region='us-west-1'; |
| Azure File | File Path azurefile://fileShare/remotePath/MyDatabase.accdb | DataSource=azurefile://bucket/folder1/MyDatabase.accdb;AzureStorageAccount='myAccount';AzureAccessKey='mySecretKey'; DataSource=azurefile://bucket/folder1/MyDatabase.accdb;AzureStorageAccount='myAccount';AzureSharedAccessSignature='mySharedAccessSignature'; |
| IBM Object Storage Source | File Path ibmobjectstorage://bucket1/remotePath/MyDatabase.accdb | DataSource=ibmobjectstorage://bucket/folder1/MyDatabase.accdb;AuthScheme='IAMSecretKey';AccessKey=token1;SecretKey=secret1;Region='eu-gb'; DataSource=ibmobjectstorage://bucket/folder1/MyDatabase.accdb;ApiKey=key1;Region='eu-gb';AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH; |
| Hadoop Distributed File System | File Path webhdfs://host:port/remotePath/MyDatabase.accdb | DataSource=webhdfs://host:port/folder1/MyDatabase.accdb |
| Secure Hadoop Distributed File System | File Path webhdfss://host:port/remotePath/MyDatabase.accdb | DataSource=webhdfss://host:port/folder1/MyDatabase.accdb |