2 Before You Install the Recipe

You must perform the following configuration tasks on your Zuora and Hasura instances to connect to them using Oracle Integration, and import order details.

Configure Zuora

To access Zuora using Oracle Integration you must perform some configurations on your Zuora Instance.

1. Log in to your Zuora application with administrator credentials.
2. Create an OAuth client for a user and obtain the client ID and client secret. See Create an OAuth Client for a User.
3. Create an OAuth provider in the Zuora application. See Add an OAuth 2.0 Provider.
4. Pass the Zuora minor version (for example 224.0) in the request header in the operations which require it.
5. Create order notification.
   1. Click the arrow adjacent to your profile name.
   2. In the drop-down list that opens, select Billing.
   3. Under the Billing Settings section, Select Setup Profiles, Notifications and Email Templates.
   4. Click Add New Notification.
      The Add notification window appears.
   5. In the Related Event drop-down list, select Order Processed.
   6. Enter the Name and Description for the Notification and select the Active checkbox.
   7. Under the Delivery Options:
      1. Select the Email and Callout checkboxes.
      2. Update the Base URL once you activate the recipe.
      3. Leave HTTP Method as POST.

      4. Add the parameter details. as shown in the table below.

         Parameter name	Parameter value
         AccountAccountNumber	Account.AccountNumber
         AccountId	Account.Id
         AccountName	Account.Name
         OrderCategory	Order.Category
         OrderDescription	Order.Description
         OrderId	Order.Id
         OrderOrderDate	Order.OrderDate
         OrderOrderNumber	Order.OrderNumber
         OrderStatus	Order.Status

      5. Select your OAUTH 2.0 provider.
   8. Click Add New Notification.

Configure Hasura

To access Hasura using Oracle Integration and import orders from Zuora, you must perform certain configuration tasks on your Hasura instance.

Log in to your Hasura instance as an Administrator and perform the following tasks.

1. Create a new project.
   1. Click New Project.
   2. Hasura auto-creates few basic information for this project. For example: Name, ID, GraphQL API, Admin Secret and so on.
   3. You can fill the required details in General, Env vars, Domains, Git Deploy, Usage, Integrations, and Alerting sections.
      Amongst all the configuration details entered above, GraphQL API and Admin Secret will be required to establish a connection with the GraphQL Adapter.
2. Connect to a new or existing database.
   1. Click Launch Console to open the Hasura console for the project.
   2. Navigate to Data, then Manage, and then click Connect Database.
   3. Select an existing database from the list or create a new database (for example: Postgres).
   4. Create a table with the columns: account _id, account_name, order_id, order _category, order_number, order_date, order_description and order_status.

For more details, see Quickstart with Hasura Cloud.