1. Using the GraphQL Adapter with Oracle Integration 3
  2. Implement Common Patterns Using the GraphQL Adapter
  3. Insert Zuora Order Records into a Hasura Database Using the GraphQL Adapter

Insert Zuora Order Records into a Hasura Database Using the GraphQL Adapter

The GraphQL Adapter enables you to seamlessly transfer Zuora order records into the Hasura Database immediately upon their creation in Zuora. Similarly, you can insert other records from an application into the Hasura Database using the GraphQL Adapter.

This use case provides an overview of importing the Zuora order records into Oracle Integration and subsequently inserting those records into the Hasura Database using the GraphQL Adapter.

The following adapters and their operations are used in this use case:
  • Order processed event (Zuora Adapter): Enables you to receive a notification for the configured event (that is, Order Processed Event) in Oracle Integration.
  • Mutation operation (GraphQL Adapter): Inserts order records into the Hasura Database.

This implementation pattern provides an overview of the steps.

  1. Create Zuora Adapter and GraphQL Adapter connections.
  2. Create an application integration.
  3. Drag a Zuora Adapter into the integration as a trigger connection.
  4. Configure the Zuora endpoint as follows:
    1. On the Basic Info page, provide an endpoint name.
    2. Select Orders as the business object, and then select Order Processed Event as the trigger event name.
    3. Review your selections on the Summary page.
  5. Drag a GraphQL Adapter into the integration canvas as an invoke connection.
  6. Configure the GraphQL Hasura endpoint as follows:
    1. On the Basic Info page, provide an endpoint name.
    2. On the Operations page, enter the GraphQL mutation query and GraphQL variables of the Hasura Database application.


      The View Operations is shown. The GraphQL invoke label is shown. Below this is the Enter your GraphQL query field. Below this is the GraphQL Variables field. Below this is the Try Query button. In the lower right are the Close, Previous, and Next buttons.

    3. Review your selections on the Summary page.
  7. In the mapper, perform the required mappings to insert the records into the Hasura Database through the GraphQL Adapter.
  8. When complete, activate the integration.

    As a result, the integration is invoked when a new order record is created in Zuora and the same record details are imported/inserted into the Hasura Database through the GraphQL Adapter.


    The integration shows a trigger connection, map action, and invoke connection.