本記事では CData サポート担当からこんなことを聞かれたらどこを確認すべきか?という観点で、よく頂くお問合せ内容をご紹介します。
記事はこちら →The CData ADO.NET Provider for Google Spanner enables you to use the Windows Communication Foundation (WCF) framework to rapidly develop service-oriented applications that provide Google Spanner data to OData consumers. This article shows how to create an entity data model to provide the underlying connectivity to the Google Spanner data, as well as how to create a WCF Data Service to expose the OData service. You can then consume the feed with any OData client, for example, Power Pivot or an application that uses the CData ADO.NET Provider for OData.
Follow the steps below to create a WCF service application that will provide connectivity to Google Spanner data via OData.
In the Connection properties dialog, select the CData Google Spanner Data Source and enter the necessary credentials. A typical connection string is below:
ProjectId='project1';InstanceId='instance1';Database='db1';
GoogleSpanner はOAuth 認証標準を利用しています。各ユーザーやドメイン内のユーザーの代わりに、本製品がGoogle API にアクセスすることを許可できます。詳しくは、ヘルプドキュメントの「OAuth の使用」を参照してください。
See the help documentation for guides to connecting in Visual Studio.
Specify the data source class and configure access to the new WCF Data Service. In the example below, the Access Rule for the entities is set to All. This means that any user will be able to read and modify data.
using System;
using System.Collections.Generic;
using System.Data.Services;
using System.Data.Services.Common;
using System.Linq;
using System.ServiceModel.Web;
using System.Web;
namespace GoogleSpannerService{
public class GoogleSpannerDataService : DataService {
public static void InitializeService(DataServiceConfiguration config) {
config.SetEntitySetAccessRule("*", EntitySetRights.All);
config.DataServiceBehavior.MaxProtocolVersion = DataServiceProtocolVersion.V3;
}
}
}
You can now use the service from any OData client; for example, Excel Power Pivot.