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 | 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://Documents/folder1/MyDatabase.accdb; User=user1; Password=password1; StorageBaseURL=https://subdomain.sharepoint.com; |
| SharePoint REST | File Path sprest://remotePath/MyDatabase.accdb | DataSource=sprest://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 | 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 | 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 | 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 |