Muokkaa

Jaa


Connect to Oracle Database from Azure Logic Apps

Applies to: Azure Logic Apps (Consumption + Standard)

In Azure Logic Apps, you can insert or manage data in your Oracle Database from within your workflow. You can use the Oracle Database connector to access an on-premises Oracle Database or an Azure virtual machine with Oracle Database installed.

For example, you can perform the following tasks with the connector:

  • Add a new customer to a customer database.
  • Update an order in an order database.
  • Get a row of data, insert a new row, or delete an existing row.

Supported versions

  • Oracle 9 and later
  • Oracle Data Access Client (ODAC) 11.2 and later

Prerequisites

Known issues and limitations

This connector doesn't support the following items:

  • Any table with composite keys
  • Nested object types in tables
  • Database functions with nonscalar values

For more information, see the connector's reference documentation.

Connector technical reference

For available connector operations, see the connector's reference documentation.

Add an action

  1. Follow these generic steps to add the Oracle Database action that you want.

    This example continues with the Get row action.

  2. In the connection box, provide the required connection information.

  3. For the Gateway property, select the Azure subscription and Azure gateway resource to use.

  4. After the connection is complete, from the Table name list, select a table.

  5. For the Row Id property, enter the row ID that you want in your table.

    In the following example, job data is returned from a Human Resources database:

    Screenshot shows Get row action with table name and row ID.

  6. Add any other actions to continue building your workflow.

  7. When you're done, save your workflow.

Common errors

Error: Cannot reach the Gateway

Cause: The on-premises data gateway can't connect to the cloud.

Mitigation: Make sure your gateway is running on the on-premises computer where you installed the gateway and has internet connectivity. Avoid installing the gateway on a computer that might be turned off or go to sleep. You can also try restarting the on-premises data gateway service (PBIEgwService).

Error: The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' To install the official provider, see https://go.microsoft.com/fwlink/p/?LinkID=272376.

Cause: The Oracle client SDK isn't installed on the computer where the on-premises data gateway is running.

Resolution: Download and install the Oracle client SDK on the same computer as the on-premises data gateway.

Error: Table '[Tablename]' does not define any key columns

Cause: The table doesn't have a primary key.

Resolution: The Oracle Database connector requires that you use a table with a primary key column.