SSIS Components for Avro

Build 21.0.7930

URI

The Uniform Resource Identifier (URI) for the Avro resource location.

Data Type

string

Default Value

""

Remarks

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

See 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://localPath

HTTP or HTTPS http://remoteStream

https://remoteStream

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

ftps://server:port/remotepath

SFTP sftp://server:port/remotePath
Sharepoint sp://https://server/remotePath

Example Connection Strings and Queries

Below are example connection strings to Avro files or streams.

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

file://localPath

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

https://remoteStream

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

ftps://server:port/remotepath

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930