XML

To connect with the provider's data modeling defaults, set the URI of the XML resource and authenticate. This section provides connection and authentication guides for the available XML data sources. See Connecting to XML Data Sources to control the data representation.

Authenticating to the Data Source

Here is an overview of the authentication properties corresponding to each data source:

Service provider	URI formats	InitiateOAuth	OAuthClientId	OAuthClientSecret	OAuthAccessToken	OAuthAccessTokenSecret	User	Password	AuthScheme	AzureAccount	AzureAccessKey	AWSAccessKey	AWSSecretKey	AWSRegion
Local	localPath file://localPath
HTTP or HTTPS	http://remoteStream https://remoteStream						OPTIONAL	OPTIONAL	OPTIONAL
Amazon S3	s3://remotePath											REQUIRED (your AccessKey)	REQUIRED (your SecretKey)	OPTIONAL
Azure Blob Storage	azureblob://mycontainer/myblob/									REQUIRED	REQUIRED (your AccessKey)
Google Drive	gdrive://remotePath	OPTIONAL	OPTIONAL	OPTIONAL	OPTIONAL	OPTIONAL
Box	box://remotePath	OPTIONAL	REQUIRED	REQUIRED	OPTIONAL	OPTIONAL
Dropbox	dropbox://remotePath	OPTIONAL	REQUIRED	REQUIRED	OPTIONAL	OPTIONAL
SharePoint Online	sp://remotePath						REQUIRED	REQUIRED
FTP or FTPS	ftp://server:port/remotePath ftps://server:port/remotepath						REQUIRED	REQUIRED
Wasabi	wasabi://bucket1/remotePath;											REQUIRED (your AccessKey)	REQUIRED (your SecretKey)	OPTIONAL

Connecting to Local Files

Set the URI to an XML file. Below is an example connection string:

URI=C:\folder1\file.xml;

Connecting to HTTP XML Streams

Set the URI to the HTTP or HTTPS URL of the XML resource you want to access as a table. Set AuthScheme to use the following authentication types. The provider also supports OAuth authentication; see Using OAuth for more information.

• HTTP:To use HTTP Basic or Digest, set the User and Password and set the corresponding AuthScheme. Set CustomHeaders if you need access to the request headers. Set CustomUrlParams to modify the URL query string.

• Windows (NTLM): Set the Windows User and Password to connect and set AuthScheme to "NTLM".

• Kerberos and Kerberos Delegation: To authenticate with Kerberos, set the User and Password and set AuthScheme to NEGOTIATE. To use Kerberos Delegation, set AuthScheme to KERBEROSDELEGATION.

For example:

URI=http://www.host1.com/streamname1;AuthScheme=BASIC;User=admin;Password=admin

Connecting to Amazon S3

Set the URI to an XML document in a bucket. Additionally, set the following properties to authenticate:

• AWSAccessKey: Set to an Amazon Web Services Access Key (a user name).

• AWSSecretKey: Set to an Amazon Web Services Secret Key.

For example:

URI=s3://bucket1/folder1/file.xml; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;

Optionally, specify AWSRegion.

Connecting to Wasabi

Set the URI to the bucket and folder. Additionally, set the following properties to authenticate:

• AWSAccessKey: Set this to an Wasabi Access Key (a username)

• AWSSecretKey: Set this to an Wasabi Secret Key.

For example:

URI=wasabi://bucket1/folder1/file.xml; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;

Optionally, specify AWSRegion in addition.

Connect to Azure Blob Storage

Set the URI to the name of your container and the name of the blob. Additionally, set the following properties to authenticate:

• AzureAccount: Set this to the account associated with the Azure blob.

• AzureAccessKey: Set the to the access key associated with the Azure blob.

For example:

URI=azureblob://mycontainer/myblob; AzureAccount=myAccount; AzureAccessKey=myKey;

Connecting to Google Drive

Set the URI to the path to an XML file and authenticate using the OAuth standard. See Connecting to Google Drive for an authentication guide. You can connect with a user account or a service account. In the user account flow, you do not need to set any connection properties for your user credentials, as shown in the following connection string:

URI=gdrive://folder1/file.xml;InitiateOAuth=GETANDREFRESH;

Connecting to Box

Set the URI to the path to an XML file and authenticate using the OAuth standard. See Connecting to Box for an authentication guide. You can authenticate with a user account or a service account. In the user account flow, you do not need to set any connection properties for your user credentials, as shown in the following connection string:

URI=box://folder1/file.xml; InitiateOAuth=GETANDREFRESH;

Connecting to Dropbox

Set the URI to the path to an XML file and authenticate using the OAuth standard. You can authenticate with a user account or a service account. In the user account flow, you do not need to set any connection properties for your user credentials, as shown in the following connection string:

URI=dropbox://folder1/file.xml; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;

Connecting to SharePoint Online

Set the URI to a document library containing XML files. To authenticate, set User and Password and SharepointUrl.

URI=sp://Documents/folder1/file.xml; User=user1; Password=password1; SharepointUrl=https://subdomain.sharepoint.com;

Connecting to FTP

Set the URI to the address of the server followed by the path to an XML file. To authenticate, set User and Password.

URI=ftps://localhost:990/folder1/file.xml; User=user1; Password=password1;

Securing XML Connections

By default, the provider attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store. To specify another certificate, see the SSLServerCert property for the available formats to do so.