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.