Use the following guidelines to write effective prompts for creating ingestion and replication tasks in CLAIRE Copilot.
•Be clear and concise when you describe the use case and task details.
•Use terminology consistent with the published documentation.
•When you refer to the service, use the proper name of "Data Ingestion and Replication" instead of an acronym such as CDIR.
•When you refer to a specific ingestion type, use "Application Ingestion and Replication" or "Database Ingestion and Replication" instead of an abbreviation such as app ingestion or db ingestion.
•Use the proper names of the source and target types and connector types.
•In prompts for creating tasks, include the following details:
- The source and target types or connector types. You can also include the connection names if you know them.
- The load type, which can be initial load, incremental load, or combined initial and incremental load. You can use “combined load” as the short form.
- The source and target schema names if you know them.
- The task type, which can be either "application ingestion and replication" or "database ingestion and replication."
Also, in the first prompt at the beginning of a conversation, you can optionally include criteria in natural language for selecting the source tables or objects. You can enter specific table or object names or enter part of the name. You can't enter this selection criteria later in the conversation. When CLAIRE Copilot displays a summary for the task during a conversation or at the end of a conversation and when the generated task is displayed in the task wizard, your selection criteria is expressed as include and exclude rules that contain table names or name masks. Masks can include the * wildcard to represent multiple characters or the ? character to represent a single character.
Examples of valid table selection criteria:
Text in the Prompt
Resulting Rule
I want to select the tables starting with PROD.
Include PROD*
I don’t want tables containing Temp in the name.
Exclude *Temp*
I want to select tables starting with order followed by any single character.
Include order?
I want to select the contacts and lead tables.
Include contacts, Include lead
Note: Table selection text can't contain negative phrases that include "not," for example, "include all tables with names that do not begin with TEMP" or "exclude tables that don't have names starting with US." These criteria are ignored.
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*