Connect to Oracle Eloqua Reporting Data from Blazor Apps

Blazor is a framework for developing modern, client-side web UIs using .NET technology. Instead of coding in JavaScript, developers can use the familiar C# language and .NET libraries to build app UIs.

The CData ADO.NET Provider for Oracle Eloqua Reporting can be used with standard ADO.NET interfaces, such as LINQ and Entity Framework, to interact with live Oracle Eloqua Reporting data. Since Blazor supports .NET Core, developers can use CData ADO.NET Providers in Blazor apps. In this article, we will guide you to build a simple Blazor app that talks to Oracle Eloqua Reporting using standard SQL queries.

Install the CData ADO.NET Provider for Oracle Eloqua Reporting

CData ADO.NET Providers allow users to access Oracle Eloqua Reporting just like they would access SQL Server, using simple SQL queries.

Install the Oracle Eloqua Reporting ADO.NET Data Provider from the CData website or from NuGet. Search NuGet for "Oracle Eloqua Reporting ADO.NET Data Provider."

Create a Oracle Eloqua Reporting-Connected Blazor App

Start by creating a Blazor project that references the CData ADO.NET Provider for Oracle Eloqua Reporting

1. Create a Blazor project on Visual Studio.
👁 Create a Blazor app project.

2. From the Solution Explorer, right click Dependencies, then click Add Project Reference.
3. In the Reference Manager, click the Browse button, and choose the .dll file of the installed ADO.NET Provider (e.g. System.Data.CData.OracleEloquaReporting.dll, typically located at C:\Program Files\CData\CData ADO.NET Provider for Oracle Eloqua Reporting\lib etstandard2.0).
👁 Reference ADO.NET for Oracle Eloqua Reporting .dll in the Blazor app.

SELECT Oracle Eloqua Reporting Data from the Blazor App

1. Open the Index.razor file from the Project page.
2. In a OracleEloquaReportingConnection object, set the connection string:

   Oracle Eloqua Reporting supports the following authentication methods:

   • Basic authentication (User and Password)
   • OAuth 2.0 code grant flow
   • OAuth 2.0 password grant flow

   Basic Authentication (User and Password)

   To perform authentication with a user and password, specify these properties:

   • AuthScheme: Basic.
   • Company: The company name associated with your Oracle Eloqua Reporting account.
   • User: Your login account name.
   • Password: Your login password.

   OAuth Authentication (Code Grant Flow)

   To authenticate with the OAuth code grant flow, you must set AuthScheme to OAuth and create a custom OAuth application. For information about how to create a custom OAuth application, see the Help documentation.

   Then set the following properties:

   • InitiateOAuth: GETANDREFRESH. Used to automatically get and refresh the OAuthAccessToken.
   • OAuthClientId: The client Id assigned when you registered your application.
   • OAuthClientSecret: The client secret that was assigned when you registered your application.
   • CallbackURL: The redirect URI that was defined when you registered your application.

   When you connect, the driver opens Oracle Eloqua Reporting's OAuth endpoint in your default browser. Log in and grant permissions to the application. When the access token expires, the driver refreshes it automatically.

   OAuth Authentication (Password Grant Flow)

   With the OAuth password grant flow, you can use your OAuth application's credentials alongside your user credentials to authenticate without the need to grant permission manually via a browser prompt. You must create an OAuth app (see the Help documentation) to use this authentication method.

   Set the following properties:

   • AuthScheme: OAuthPassword
   • Company: The company's unique identifier.
   • User: Your login account name.
   • Password: Your login password.
   • OAuthClientId: The client Id assigned when you registered your custom OAuth application.
   • OAuthClientSecret: The client secret assigned when you registered your custom OAuth application.

   For example: AuthScheme=Basic;User=user;Password=password;Company=MyCompany;

3. The code below creates a simple Blazor app for displaying Oracle Eloqua Reporting data, using standard SQL to query Oracle Eloqua Reporting just like SQL Server.

    @page "/"
    @using System.Data;
    @using System.Data.CData.OracleEloquaReporting;
    
    <h1>Hello, world!</h1>
    
    Welcome to your Data app.
    
    <div class="row">
    <div class="col-12">
    
    @using (OracleEloquaReportingConnection connection = new OracleEloquaReportingConnection(
    "AuthScheme=Basic;User=user;Password=password;Company=MyCompany;"))
    {
    var sql = "SELECT , FROM WHERE = ''";
    var results = new DataTable();
    
    OracleEloquaReportingDataAdapter dataAdapter = new OracleEloquaReportingDataAdapter(sql, connection);
    dataAdapter.Fill(results);
    
    <table class="table table-bordered">
    <thead class="thead-light">
    <tr>
    @foreach (DataColumn item in results.Rows[0].Table.Columns)
    {
    <th scope="col">@item.ColumnName</th>
    }
    </tr>
    </thead>
    <tbody>
    @foreach (DataRow row in results.Rows)
    {
    <tr>
    @foreach (var column in row.ItemArray)
    {
    <td>@column.ToString()</td>
    }
    </tr>
    }
    </tbody>
    </table>
    }
    </div>
    </div>
    

4. Rebuild and run the project. The ADO.NET Provider renders Oracle Eloqua Reporting data as an HTML table in the Blazor app. 👁 Query Oracle Eloqua Reporting from Blazor app.
   

   At this point, you have a Oracle Eloqua Reporting-connected Blazor app, capable of working with live Oracle Eloqua Reporting data just like you would work with a SQL Server instance. Download a free, 30-day trial and start working with live Oracle Eloqua Reporting data in your Blazor apps today.