Power BI Connector for Parquet

Build 20.0.7587

DSN の作成

このセクションでは、DSN 設定の編集方法と、Parquet API へ認証および接続について説明します。

DSN 設定の編集

Microsoft ODBC データソースアドミニストレーターを使ってDSN 設定を編集できます。DSN はインストールプロセス中に作成されることに注意してください(コネクタのインストール 参照)。

DSN 設定を編集するには、次の手順を実行してください。

  1. [スタート]->[検索] を選択し、[検索]ボックスに[ODBC データソース] と入力します。
  2. Power BI Desktop インストールのビット数(32-bit または64-bit)に対応するODBC アドミニストレーターのバージョンを選択してください。
  3. [システムDSN] タブをクリックします。
  4. システムデータソースを選択して[構成]をクリックします。
  5. [接続]タブの情報を編集して[OK]をクリックします。

Connecting to Parquet Data Sources

The CData Power BI Connector for Parquet allows connecting to local and remote Parquet resources. Set the URI property to the Parquet resource location, in addition to any other properties necessary to connect to your data source.

Service provider URI formats OAuthClientId OAuthClientSecret OAuthAccessToken OAuthAccessTokenSecret User Password AuthScheme AzureAccount AzureAccessKey AWSAccessKey AWSSecretKey AWSRegion AccessKey SecretKey Region OracleNamespace ProjectId
Local localPath

file://localPath/file.parquet

HTTP or HTTPS http://remoteStream

https://remoteStream

OPTIONAL OPTIONAL OPTIONAL
Amazon S3 s3://remotePath/file.parquet REQUIRED (your AccessKey) REQUIRED (your SecretKey) OPTIONAL
Azure Blob Storage azureblob://mycontainer/myblob/ REQUIRED REQUIRED (your AccessKey)
Azure Data Lake Store Gen1 adl://remotePath

adl://Account.azuredatalakestore.net@remotePath

OPTIONAL OPTIONAL OPTIONAL REQUIRED
Azure Data Lake Store Gen2 abfs://myfilesystem/remotePath REQUIRED REQUIRED (your AccessKey)
Azure Data Lake Store Gen2 with SSL abfss://myfilesystem/remotePath REQUIRED REQUIRED (your AccessKey)
Google Drive gdrive://remotePath/file.parquet OPTIONAL OPTIONAL OPTIONAL OPTIONAL
OneDrive onedrive://remotePath/file.parquet OPTIONAL OPTIONAL OPTIONAL OPTIONAL
Box box://remotePath/file.parquet REQUIRED REQUIRED OPTIONAL OPTIONAL
Dropbox dropbox://remotePath/file.parquet REQUIRED REQUIRED OPTIONAL OPTIONAL
SharePoint Online SOAP sp://remotePath/file.parquet REQUIRED REQUIRED
SharePoint Online REST sprest://remotePath/file.parquet OPTIONAL OPTIONAL OPTIONAL
FTP or FTPS ftp://server:port/remotePath/file.parquet

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

REQUIRED REQUIRED
SFTP sftp://server:port/remotePath/file.parquet OPTIONAL OPTIONAL
Wasabi wasabi://bucket1/remotePath/file.parquet; REQUIRED (your AccessKey) REQUIRED (your SecretKey) OPTIONAL
Google Cloud Storage gs://bucket/remotePath/file.parquet; OPTIONAL OPTIONAL OPTIONAL OPTIONAL REQUIRED
Oracle Cloud Storage os://bucket/remotePath/file.parquet; REQUIRED (your AccessKey) REQUIRED (your SecretKey) OPTIONAL REQUIRED

Connecting to Local Files

Set the URI to a folder containing Parquet files.

Below is an example connection string:

URI=C:\folder1\file.parquet;

You can also connect to multiple Parquet files which share the same schema. Below is an example connection string:

URI=C:\folder; AggregateFiles=True;

Connecting to Amazon S3

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

  • AWSAccessKey: Set this to an Amazon Web Services Access Key (a username).
  • AWSSecretKey: Set this to an Amazon Web Services Secret Key.
For example:
URI=s3://bucket1/folder1; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO;
Optionally, specify AWSRegion in addition.

Note: It is also possible to connect to S3-compatible services by specifying its base Url. For example, if the Url conn prp is set to http://s3.%region%.myservice.com and Region is region-1, then we will generate request URLs like https://s3.region-1.myservice.com/bucket/... (or like https://bucket.s3.region-1.myservice.com/..., if the UseVirtualHosting property is true).

Connecting to Oracle Cloud Object Storage

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

  • AccessKey: Set this to an Oracle cloud Access Key.
  • SecretKey: Set this to an Oracle cloud Secret Key.
  • OracleNamespace: Set this to an Oracle cloud namespace.
For example:
URI=os://bucket/remotePath/; AccessKey=token1; SecretKey=secret1; OracleNamespace=myNamespace; Region=us-ashburn-1;
Optionally, specify Region in addition.

Connecting to Wasabi

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

  • AWSAccessKey: Set this to a Wasabi Access Key (a username)
  • AWSSecretKey: Set this to a Wasabi Secret Key.
Optionally, specify AWSRegion in addition.

For example:

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

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 this to the access key associated with the Azure blob.
For example:
URI=azureblob://mycontainer/myblob/; AzureAccount=myAccount; AzureAccessKey=myKey;

Connect to Azure Data Lake Store Gen 2

Set the URI to the name of the file system and the name of the folder which contacts your Parquet files. Additionally, set the following properties to authenticate:

  • AzureAccount: Set this to the account associated with the Azure data lake store.
  • AzureAccessKey: Set this to the access key associated with the Azure data lake store.
For example:
  URI=abfs://myfilesystem/folder1; AzureAccount=myAccount; AzureAccessKey=myKey;
  URI=abfss://myfilesystem/folder1; AzureAccount=myAccount; AzureAccessKey=myKey;

Connecting to Box

Set the URI to the path to a folder containing Parquet files. To authenticate to Box, use the OAuth authentication standard. See Box への接続 for an authentication guide.

For example:

URI=box://folder1;  OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;

Connecting to Dropbox

Set the URI to the path to a folder containing Parquet files. To authenticate to Dropbox, use the OAuth authentication standard. See Dropbox への接続 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 connection string below:

URI=dropbox://folder1;  OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345;

Connecting to SharePoint Online SOAP

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

For example:

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

Connecting to SharePoint Online REST

Set the URI to a document library containing Parquet files. SharepointUrl is optional. If not provided, the driver will work with the root drive. To authenticate, use the OAuth authentication standard.

For example:

URI=sp://Documents/folder1; InitiateOAuth=GETANDREFRESH; SharepointUrl=https://subdomain.sharepoint.com;

Connecting to FTP

Set the URI to the address of the server followed by the path to the folder to be used as the root folder. To authenticate, set User and Password.

For example:

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

Connecting to Google Cloud Storage

Set the URI to the path to the name of the file system and the name of the folder which contacts your Parquet files. To authenticate to Google APIs, provide a ProjectId.

For example:

URI=gs://bucket/remotePath/; ProjectId=PROJECT_ID; 

次のステップ

次の手順については、データの取得 を参照してください。作業したいデータへの接続について説明します。

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