JDBC Driver for REST

Build 20.0.7654

URI

The Uniform Resource Identifier (URI) for the XML/JSON resource location.

Data Type

string

Default Value

""

Remarks

Set the URI property to specify a path to a file or stream.

A comma-separated list of URIs is supported to include multiple files. See Advanced Settings for more advanced features available for parsing and merging multiple files.

Below are examples of the URI formats for the available data sources:

Service providerURI formats
Local localPath/file.json

file://localPath/file.json

HTTP or HTTPS http://remoteStream

https://remoteStream

Amazon S3 s3://remotePath/file.json
Google Drive gdrive://remotePath/file.json
Box box://remotePath/file.json
FTP or FTPS ftp://server:port/remotePath/file.json

ftps://server:port/remotepath/file.json

SFTP sftp://server:port/remotePath/file.json
Sharepoint sp://https://server/remotePath/file.json

Example Connection Strings and Queries

Below are example connection strings to XML/JSON files or streams.

Service providerURI formats Connection exampleQuery example (if folder1 contains file1.XML/JSON or streamname1 is a XML/JSON stream)
Local localPath

file://localPath/file.json

URI=C:\folder1/file.json SELECT * FROM file1
HTTP or HTTPS http://remoteStream

https://remoteStream

URI=http://www.host1.com/streamname1; SELECT * FROM streamedtable
Amazon S3 s3://bucket1/folder1/file.json URI=s3://bucket1/folder1/file.json; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; SELECT * FROM file1
Google Drive gdrive://remotePath/file.json URI=gdrive://folder1/file.json;InitiateOAuth=GETANDREFRESH; SELECT * FROM file1
Box box://remotePath/file.json URI=box://folder1/file.json; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;SELECT * FROM file1
FTP or FTPS ftp://server:port/remotePath/file.json

ftps://server:port/remotepath/file.json

URI=ftps://localhost:990/folder1/file.json; User=user1; Password=password1; SELECT * FROM file1
SFTP sftp://server:port/remotePath URI=sftp://127.0.0.1:22/remotePath/file.json; User=user1; Password=password1; SELECT * FROM file1
Sharepoint sp://https://server/remotePath URI=sp://https://domain.sharepoint.com/Documents/file.json; User=user1; Password=password1; SELECT * FROM file1

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654