1. Data Extraction Tool
  2. Set Up the SQL to BQL Agent Guided Journey

Set Up the SQL to BQL Agent Guided Journey

Set up the SQL to BQL Agent Guided Journey to help users convert SQL statements to Business Object Query Language (BQL) when they create a user-defined query.

After setup, the Convert SQL to Business Object Query Language task appears on the New User-Defined Query page. Users can select Ask Oracle to use the Data Extraction Query Transformer Workflow agent.

Before You Start

Ensure that the Data Extraction Query Transformer Workflow agent is available before you create the guided journey.

Create the Guided Journey

  1. Sign in to Oracle Fusion Cloud Applications.

  2. Select My Client Groups > Journeys Setup.

  3. Select Guided Journey.

  4. Select Create.

  5. Select New.

  6. Enter the following values:

    Field Descriptions

    Field Value
    Name SQL to BQL agent
    Code USER_DEFINED_QUERY_GUIDED_JOURNEY_CODE

  7. Leave Allow access for external users disabled.

  8. Select Create Draft.

Add the SQL to BQL Agent Task

  1. In the Tasks section, select Add.

  2. Enter the following task details.

    Field Descriptions

    Field Value
    Task Name Convert SQL to Business Object Query Language
    Date From Current date
    Task Type Agent
    Agent Type Workflow Agent
    Workflow Agent Data Extraction Query Transformer Workflow

  3. Keep the task status as Active.

  4. Select Save.

  5. Select Preview.

  6. Verify that the Convert SQL to Business Object Query Language task appears in the preview.

  7. Select Ask Oracle, and verify that the Data Extraction Query Transformer Workflow agent opens.

  8. Activate the guided journey.

Associate the Guided Journey with User-Defined Queries

Use the following Guided Journey code when you create the journey:

USER_DEFINED_QUERY_GUIDED_JOURNEY_CODE

The Data Extraction application uses this code to associate the Guided Journey with the New User-Defined Query page. Use the code exactly as shown.

Verify the Guided Journey

  1. Open Tools > Data Extraction.

  2. Select User-Defined Queries, and then select Create.

  3. Verify that the Convert SQL to Business Object Query Language task is available on the New User-Defined Query page.

    The agent helps users define a BQL query. Users must still enter the required user-defined query details, such as the name, pillar, family, execution mode, and query definition, before they create the query.