Learn more
 

Ready to get started?

Download a free trial of the Oracle SCM Data Provider to get started:

 Download Now

Learn more:

Oracle SCM Icon Oracle SCM ADO.NET Provider

Rapidly create and deploy powerful .NET applications that integrate with Oracle SCM.

In this article

Related articles

Connect to Oracle SCM Data from PowerBuilder


This article demonstrates how to access Oracle SCM data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle SCM.

This article demonstrates using the CData ADO.NET Provider for Oracle SCM in PowerBuilder, showcasing the ease of use and compatibility of these standards-based controls across various platforms and development technologies that support Microsoft .NET, including Appeon PowerBuilder.

This article shows how to create a basic PowerBuilder application that uses the CData ADO.NET Provider for Oracle SCM to retrieve data.

  1. In a new WPF Window Application solution, add all the Visual Controls needed for the connection properties. Below is a typical connection string:

    Url=https://myinstance.oraclecloud.com;User=user;Password=password;

    The following connection properties are required to connect to Oracle SCM data.

    • Url: The URL of the account that you want to connect to. Typically, this will be the URL of your Oracle Cloud service. For example, https://servername.fa.us2.oraclecloud.com.
    • User: The username of your Oracle Cloud service account.
    • Password: The password of your Oracle Cloud service account.

  2. Add the DataGrid control from the .NET controls.
  3. Configure the columns of the DataGrid control. Below are several columns from the Account table: <DataGrid AutoGenerateColumns="False" Margin="13,249,12,14" Name="datagrid1" TabIndex="70" ItemsSource="{Binding}"> <DataGrid.Columns> <DataGridTextColumn x:Name="idColumn" Binding="{Binding Path=Id}" Header="Id" Width="SizeToHeader" /> <DataGridTextColumn x:Name="nameColumn" Binding="{Binding Path=CarrierId}" Header="CarrierId" Width="SizeToHeader" /> ... </DataGrid.Columns> </DataGrid>
  4. Add a reference to the CData ADO.NET Provider for Oracle SCM assembly.

Connect the DataGrid

Once the visual elements have been configured, you can use standard ADO.NET objects like Connection, Command, and DataAdapter to populate a DataTable with the results of an SQL query:

System.Data.CData.OracleSCM.OracleSCMConnection conn conn = create System.Data.CData.OracleSCM.OracleSCMConnection(connectionString) System.Data.CData.OracleSCM.OracleSCMCommand comm comm = create System.Data.CData.OracleSCM.OracleSCMCommand(command, conn) System.Data.DataTable table table = create System.Data.DataTable System.Data.CData.OracleSCM.OracleSCMDataAdapter dataAdapter dataAdapter = create System.Data.CData.OracleSCM.OracleSCMDataAdapter(comm) dataAdapter.Fill(table) datagrid1.ItemsSource=table.DefaultView

The code above can be used to bind data from the specified query to the DataGrid.