Connecting to XML Data Sources
After connecting to your data source, set DataModel to more closely match the data representation to the structure of your data.
Connecting to XML
Below are example connection strings to XML files or streams, using the connector's default data modeling configuration (see below)
| Service provider | URI formats | Connection example |
| Local | Single File Path (One table) file://localPath/file.xml | URI=C:/folder1/file.xml; |
| Directory Path (One aggregated table from all files) file://localPath/ | URI=C:/folder1/; | |
| HTTP or HTTPS | http://remoteStream https://remoteStream | URI=http://www.host1.com/streamname1; |
| Amazon S3 | Single File Path (One table) s3://remotePath/file.xml | URI=s3://bucket1/folder1/file.xml;AWSSecretKey=secret1;AWSRegion=OHIO; |
| Directory Path (One aggregated table from all files) s3://remotePath/ | URI=s3://bucket1/folder1/;AWSSecretKey=secret1;AWSRegion=OHIO; | |
| Azure Blob Storage | Single File Path (One table) azureblob://mycontainer/myblob/file.xml | URI=azureblob://mycontainer/myblob/file.xml;AzureStorageAccount=myAccount;AzureAccessKey=myKey; URI=azureblob://mycontainer/myblob/file.xml;AzureStorageAccount=myAccount;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; |
| Directory Path (One aggregated table from all files) azureblob://mycontainer/myblob/ | URI=azureblob://mycontainer/myblob/;AzureStorageAccount=myAccount;AzureAccessKey=myKey; URI=azureblob://mycontainer/myblob/;AzureStorageAccount=myAccount;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; | |
| Google Drive | Single File Path (One table) gdrive://remotePath/file.xml gdrive://SharedWithMe/remotePath/file.xml | URI=gdrive://folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; URI=gdrive://SharedWithMe/folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; |
| Directory Path (One aggregated table from all files) gdrive://remotePath/ gdrive://SharedWithMe/remotePath/ | URI=gdrive://folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; URI=gdrive://SharedWithMe/folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; | |
| One Drive | Single File Path (One table) onedrive://remotePath/file.xml onedrive://SharedWithMe/remotePath/file.xml | URI=onedrive://folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; URI=onedrive://SharedWithMe/folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; |
| Directory Path (One aggregated table from all files) onedrive://remotePath/ onedrive://SharedWithMe/remotePath/ | URI=onedrive://folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; URI=onedrive://SharedWithMe/folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; | |
| Box | Single File Path (One table) box://remotePath/file.xml | URI=box://folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; |
| Directory Path (One aggregated table from all files) box://remotePath/ | URI=box://folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth; | |
| Dropbox | Single File Path (One table) dropbox://remotePath/file.xml | URI=dropbox://folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;OAuthClientId=oauthclientid1;OAuthClientSecret=oauthcliensecret1;CallbackUrl=http://localhost:12345; |
| Directory Path (One aggregated table from all files) dropbox://remotePath/ | URI=dropbox://folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;OAuthClientId=oauthclientid1;OAuthClientSecret=oauthcliensecret1;CallbackUrl=http://localhost:12345; | |
| SharePoint SOAP | Single File Path (One table) sp://remotePath/file.xml | URI=sp://Shared Documents/folder1/file.xml;User=user1;Password=password1;StorageBaseURL=https://subdomain.sharepoint.com; |
| Directory Path (One aggregated table from all files) sp://remotePath/ | URI=sp://Shared Documents/folder1/;User=user1;Password=password1;StorageBaseURL=https://subdomain.sharepoint.com; | |
| SharePoint REST V1 | Single File Path (One table) sprestv1://remotePath/file.xml | URI=sprestv1://Shared Documents/folder1/file.xml;User=user1;Password=password1;AuthScheme=NTLM;StorageBaseURL=http://sharepointserver/sites/mysite; URI=sprestv1://Shared Documents/folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=AzureAD;StorageBaseURL=https://subdomain.sharepoint.com/sites/mysite; |
| Directory Path (One aggregated table from all files) sprestv1://remotePath/ | URI=sprestv1://Shared Documents/folder1/;User=user1;Password=password1;AuthScheme=NTLM;StorageBaseURL=http://sharepointserver/sites/mysite; URI=sprestv1://Shared Documents/folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=AzureAD;StorageBaseURL=https://subdomain.sharepoint.com/sites/mysite; | |
| SharePoint GRAPH | Single File Path (One table) spgraph://remotePath/file.xml | URI=spgraph://Shared Documents/folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;StorageBaseURL=https://subdomain.sharepoint.com; |
| Directory Path (One aggregated table from all files) spgraph://remotePath/ | URI=spgraph://Shared Documents/folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;StorageBaseURL=https://subdomain.sharepoint.com; | |
| FTP or FTPS | Single File Path (One table) ftp://server:port/remotePath/file.xml ftps://server:port/remotepath/file.xml | URI=ftps://localhost:990/folder1/file.xml;User=user1;Password=password1; |
| Directory Path (One aggregated table from all files) ftp://server:port/remotePath/ ftps://server:port/remotepath/; | URI=ftps://localhost:990/folder1/;User=user1;Password=password1; | |
| SFTP | Single File Path (One table) sftp://server:port/remotePath/file.xml | URI=sftp://127.0.0.1:22/folder1/file.xml;User=user1;Password=password1; URI=sftp://127.0.0.1:22/folder1/file.xml;SSHAuthmode=PublicKey;SSHClientCert=myPrivateKey |
| Directory Path (One aggregated table from all files) sftp://server:port/remotePath/ | URI=sftp://127.0.0.1:22/folder1/;User=user1;Password=password1; URI=sftp://127.0.0.1:22/folder1/;SSHAuthmode=PublicKey;SSHClientCert=myPrivateKey | |
| Azure Data Lake Store Gen1 | Single File Path (One table) adl://remotePath/file.xml adl://Account.azuredatalakestore.net@remotePath/file.xml | URI=adl://folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;AzureStorageAccount=myAccount;AzureTenant=tenant; URI=adl://myAccount.azuredatalakestore.net@folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;AzureTenant=tenant; |
| Directory Path (One aggregated table from all files) adl://remotePath/ adl://Account.azuredatalakestore.net@remotePath/ | URI=adl://folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;AzureStorageAccount=myAccount;AzureTenant=tenant; URI=adl://myAccount.azuredatalakestore.net@folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;AzureTenant=tenant; | |
| Azure Data Lake Store Gen2 | Single File Path (One table) abfs://myfilesystem/remotePath/file.xml abfs://[email protected]/remotepath/file.xml | URI=abfs://myfilesystem/folder1/file.xml;AzureStorageAccount=myAccount;AzureAccessKey=myKey; URI=abfs://[email protected]/folder1/file.xml;AzureAccessKey=myKey; |
| Directory Path (One aggregated table from all files) abfs://myfilesystem/remotePath/ abfs://[email protected]/remotepath/ | URI=abfs://myfilesystem/folder1/;AzureStorageAccount=myAccount;AzureAccessKey=myKey; URI=abfs://[email protected]/folder1/;AzureAccessKey=myKey; | |
| Azure Data Lake Store Gen2 with SSL | Single File Path (One table) abfss://myfilesystem/remotePath/file.xml abfss://[email protected]/remotepath/file.xml | URI=abfss://myfilesystem/folder1/file.xml;AzureStorageAccount=myAccount;AzureAccessKey=myKey; URI=abfss://[email protected]/folder1/file.xml;AzureAccessKey=myKey; |
| Directory Path (One aggregated table from all files) abfss://myfilesystem/remotePath/ abfss://[email protected]/remotepath/ | URI=abfss://myfilesystem/folder1/;AzureStorageAccount=myAccount;AzureAccessKey=myKey; URI=abfss://[email protected]/folder1/;AzureAccessKey=myKey; | |
| Wasabi | Single File Path (One table) wasabi://bucket1/remotePath/file.xml | URI=wasabi://bucket/folder1/file.xml;AccessKey=token1;SecretKey=secret1;Region='us-west-1'; |
| Directory Path (One aggregated table from all files) wasabi://bucket1/remotePath/ | URI=wasabi://bucket/folder1/;AccessKey=token1;SecretKey=secret1;Region='us-west-1'; | |
| Google Cloud Storage | Single File Path (One table) gs://bucket/remotePath/file.xml | URI=gs://bucket/folder1/file.xml;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;ProjectId=test; |
| Directory Path (One aggregated table from all files) gs://bucket/remotePath/ | URI=gs://bucket/folder1/;InitiateOAuth=GETANDREFRESH;AuthScheme=OAuth;ProjectId=test; | |
| Oracle Cloud Storage | Single File Path (One table) os://bucket/remotePath/file.xml | URI=os://bucket/folder1/file.xml;AccessKey='myKey';SecretKey='mySecretKey';OracleNameSpace='myNameSpace' Region='us-west-1'; |
| Directory Path (One aggregated table from all files) os://bucket/remotePath/ | URI=os://bucket/folder1/;AccessKey='myKey';SecretKey='mySecretKey';OracleNameSpace='myNameSpace' Region='us-west-1'; | |
| Azure File | Single File Path (One table) azurefile://fileShare/remotePath/file.xml | URI=azurefile://bucket/folder1/file.xml;AzureStorageAccount='myAccount';AzureAccessKey='mySecretKey'; URI=azurefile://bucket/folder1/file.xml;AzureStorageAccount='myAccount';AzureSharedAccessSignature='mySharedAccessSignature'; |
| Directory Path (One aggregated table from all files) azurefile://fileShare/remotePath/ | URI=azurefile://bucket/folder1/;AzureStorageAccount='myAccount';AzureAccessKey='mySecretKey'; URI=azurefile://bucket/folder1/;AzureStorageAccount='myAccount';AzureSharedAccessSignature='mySharedAccessSignature'; | |
| IBM Object Storage Source | Single File Path (One table) ibmobjectstorage://bucket1/remotePath/file.xml | URI=ibmobjectstorage://bucket/folder1/file.xml;AuthScheme='IAMSecretKey';AccessKey=token1;SecretKey=secret1;Region='eu-gb'; URI=ibmobjectstorage://bucket/folder1/file.xml;ApiKey=key1;Region='eu-gb';AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH; |
| Directory Path (One aggregated table from all files) ibmobjectstorage://bucket1/remotePath/ | URI=ibmobjectstorage://bucket/folder1/;AuthScheme='IAMSecretKey';AccessKey=token1;SecretKey=secret1;Region='eu-gb'; URI=ibmobjectstorage://bucket/folder1/;ApiKey=key1;Region='eu-gb';AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH; | |
| Hadoop Distributed File System | Single File Path (One table) webhdfs://host:port/remotePath/file.xml | URI=webhdfs://host:port/folder1/file.xml |
| Directory Path (One aggregated table from all files) webhdfs://host:port/remotePath/ | URI=webhdfs://host:port/folder1/ | |
| Secure Hadoop Distributed File System | Single File Path (One table) webhdfss://host:port/remotePath/file.xml | URI=webhdfss://host:port/folder1/file.xml |
| Directory Path (One aggregated table from all files) webhdfss://host:port/remotePath/ | URI=webhdfss://host:port/folder1/ |
Modeling XML Data
The DataModel property controls how your data is represented into tables.
- Document (default): Model a top-level, document view of your XML data. The connector returns nested object arrays as aggregated XML objects.
- FlattenedDocuments: Implicitly join nested array objects and parent objects into a single table.
- Relational: View nested object arrays as individual, related tables containing a primary key and a foreign key that links to the parent document.
Next Steps
- See Parsing Hierarchical Data for examples showing how to query a dataset in each DataModel configuration.
- See Modeling XML Data for information on customizing schema discovery and how to execute SQL to XML.
- See Fine-Tuning Data Access for more advanced connection settings: fine-tune the default data modeling settings, connect through a firewall, or troubleshoot connections.