Connecting to XML Datasources

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 provider's default data modeling configuration (see below):

Service provider	URI formats	Connection example
Local	localPath file:///localPath/file.xml	URI=C:\folder1\file.xml;
HTTP or HTTPS	http://remoteStream https://remoteStream	URI=http://www.host1.com/streamname1;
Amazon S3	s3://bucket1/folder1/file.xml	URI=s3://bucket1/folder1/file.xml; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;
Azure Blob Storage	azureblob://mycontainer/myblob/	URI=azureblob://mycontainer/myblob; AzureAccount=myAccount; AzureAccessKey=myKey;
Google Drive	gdrive://remotePath/file.xml	URI=gdrive://folder1/file.xml;InitiateOAuth=GETANDREFRESH;
Box	box://remotePath/file.xml	URI=box://folder1/file.xml; InitiateOAuth=GETANDREFRESH;
Dropbox	dropbox://remotePath/file.xml	URI=dropbox://folder1/file.xml; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;
Sharepoint	sp://remotePath/file.xml	URI=sp://Documents/folder1/file.xml; User=user1; Password=password1; SharepointUrl=https://subdomain.sharepoint.com;
FTP or FTPS	ftp://server:port/remotePath/file.xml ftps://server:port/remotepath/file.xml	URI=ftps://localhost:990/folder1/file.xml; User=user1; Password=password1;
AzureDataLakeStoreGen2	abfs://myfilesystem/remotePath/file.xml abfss://[e-mail]/remotepath/file.xml	URI=abfs://myfilesystem/folder1/file.xml; AzureAccount=myAccount; AzureAccessKey=myKey; URI=abfss://[e-mail]/folder1/file.xml; AzureAccessKey=myKey;
AzureDataLakeStoreGen2 with SSL	abfss://myfilesystem/remotePath/file.xml abfs://[e-mail]/remotepath/file.xml	URI=abfss://myfilesystem/folder1/file.xml; AzureAccount=myAccount; AzureAccessKey=myKey; URI=abfss://[e-mail]/folder1/file.xml; AzureAccessKey=myKey;
Wasabi	wasabi://bucket/remotePath/file.xml	URI=wasabi://bucket/folder1/file.xml; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=NorthenVirginia;

Modeling XML Data

The DataModel property is the controlling property over how your data is represented into tables and toggles the following basic configurations.

• Document (default): Model a top-level, document view of your XML data. The provider returns nested elements as aggregated XML.

• FlattenedDocuments: Detect nested documents and implicitly join them into a single table.

• Relational: Return individual, related tables from hierarchical data. The tables contain a primary key and a foreign key that links to the parent document.

See Parsing Hierarchical Data