CLAIRE Copilot for Data Integration > Using CLAIRE Copilot with Data Ingestion and Replication > Guidelines for writing effective prompts
  

Guidelines for writing effective prompts

Use the following guidelines to write effective prompts for creating ingestion and replication tasks in CLAIRE Copilot.

Example prompt

Let's break down the following example prompt:
Create a database ingestion and replication task that performs a combined load of data from an Oracle source to an Oracle target. Use the xxx source connection, the bbb source schema, and the yyy target connection. Include source tables that have names starting with Cust and exclude tables that have names starting with Temp.
The following table lists the keywords in the prompt and how they correspond to elements of the task definition:
Text in prompt
Task element
database ingestion and replication
Task type
combined load
Load type
Oracle source
Source type
Oracle target
Target type
xxx source connection
Name of the Oracle Database Ingestion connection to use for the source
yyy target connection
Name of the Oracle Database Ingestion connection to use for the target
bbb source schema
Name of the Oracle schema that contains the source tables
Include source tables that have names starting with Cust and exclude tables that have names starting with Temp.
Source table selection criteria, which will be translated to the rules Include Cust* and Exclude Temp*.