はじめに

The ADO.NET provider for Google Analytics provides a wide range of features that enable connectivity to Google Analytics from .Net applications . The documentation will help you understand the C1.AdoNet.GoogleAnalytics namespace, which includes all the available classes that can be used to connect and retrieve data from Google Analytics

DataConnectors, are mostly used in combination with other ComponentOne components, such as DataEngine and FlexPivot. The procedure below describes the first steps to use the DataConnector in a console application within Visual Studio.

How to create a new Console Application

Open Visual Studio.
In the Get started pane, select Create a new project.
In the Create a new project window, select Console Application and click Next, as in the screenshot below:
In the Configure your new project window, write your project's name, choose location to save your project and click Create.

How to add the NuGet packages

To use the ADO.NET provider for Google Analytics in an application, the respective NuGet package should be added:

From the Project menu, select Manage NuGet Packages.
In the NuGet Package Manager, click the Package source drop down and select nuget.org
In the left pane of the Browse tab, select C1.AdoNet.GoogleAnalytics.
In the right pane of the Browse tab, click Install to add the reference to the package

How to use ADO.Net provider for Google Analytics to retrieve data

Follow the steps provided below to learn and implement data retrieval using ADO.NET provider for Google Analytics.

The first step is to add the KeyFile, which contains service account credentials in JSON format, and the ViewId from which data is required to be retrieved to the connection string. For more details on how to get KeyFile and ViewId go to the Authorization section.

C#	コードのコピー
const string KeyFile = "*****"; const string ViewId = "**********";

In the next step, C1GoogleAnalyticsConnection is used to retrieve the data. Click here for more information on creating connections.

C1GoogleAnalyticsConnection implements the ADO.NET DbConnection, similar to standard ADO.NET connection object that retrieves a single result set of all the data that matches a query. Once the connection is established, it retrieves the data from the source as shown in the following code.

C#	コードのコピー
static void ReadData() { //接続文字列を定義します。 string connectionString = string.Format("Key File={0};View Id={1}", KeyFile, ViewId); //コマンドを定義します。 string sql = "SELECT Source, Sessions FROM Traffic WHERE Sessions > 500 AND StartDate = '14DaysAgo' AND EndDate = 'Today'"; //データを取得します。 using (var con = new C1GoogleAnalyticsConnection(connectionString)) { con.Open(); var command = con.CreateCommand(); command.CommandText = sql; var reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(String.Format("{0} --> \t\t{1}", reader["Source"], reader["Sessions"])); } } }

コードのコピー

static void ReadData()
{
    //接続文字列を定義します。
    string connectionString = string.Format("Key File={0};View Id={1}", KeyFile, ViewId);
//コマンドを定義します。
    string sql = "SELECT Source, Sessions FROM Traffic WHERE Sessions > 500 AND StartDate = '14DaysAgo' AND EndDate = 'Today'";
    //データを取得します。
    using (var con = new C1GoogleAnalyticsConnection(connectionString))
    {
        con.Open();

        var command = con.CreateCommand();
        command.CommandText = sql;
        var reader = command.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0} --> \t\t{1}", reader["Source"], reader["Sessions"]));
        }
    }
}