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.

Examination of a detailed prompt for creating an ingestion and replication task

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. Load records from source tables that have names starting w. Cust to the target and then switch to replicating only new changes to keep the source and target in sync.
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
….source tables with names starting w. Cust
Source table selection criteria, which will be translated to into the rule Include Cust*