OracleClient

Namespace: AVEVA.IntegrationService.DataAPI.SDK

Interface: IOracleClient

Description: OracleClient is used to communicate with Oracle Database ProductCategory products. It inherits all base methods from BaseClient.

Methods

OracleClient uses all methods from the BaseClient (refer Common Methods (Available in BaseClient) section for more information).

Example:

var oracleClient = dataApiClient.OracleClient;

// Get datasource information

var datasource = await oracleClient.GetDataSource("MyOracleDataSource");

Console.WriteLine($"Datasource: {datasource.Name}, Status: {datasource.Status}");

// Get all tables

DataTable tables = await oracleClient.GetTables("MyOracleDataSource");

// Get table data with filter

DataTable projectData = await oracleClient.GetTableData(

"MyOracleDataSource",

"Projects",

filter: "Budget gt 1000000"

);

// Post data

DataTable newProjects = new DataTable("Projects");

newProjects.Columns.Add("ProjectID", typeof(string));

newProjects.Columns.Add("Name", typeof(string));

newProjects.Columns.Add("Budget", typeof(decimal));

newProjects.Rows.Add("PRJ001", "Plant Upgrade", 2500000.00);

AcknowledgementResult result = await oracleClient.PostTableData(

"MyOracleDataSource",

"Projects",

newProjects,

""

);