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, you can 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.
- Source table selection criteria. Enter table names or name masks with wildcards.
- The task type, which can be either "application ingestion and replication" or "database ingestion and replication."
The source table selection criteria is optional in the first prompt. If you don't include it, you can enter it during the conversation, after you select a source schema. Enter include or exclude criteria that contains specific table or object names, the initial part of the names, or name masks with wildcards, for example, include tables with names starting with prod. In masks, you can use the * wildcard to represent multiple characters, or use the ? character to represent a single character. Alternatively, you can say "Select All" to select all tables or objects in the selected schema. When CLAIRE Copilot displays a summary for the task, your selection criteria is shown. In the task configuration wizard, the selection criteria is translated to include and exclude rules.
Examples of valid table selection criteria:
Text in the Prompt
Resulting Rule
Include tables with names starting with PROD.
Include PROD*
Exclude tables with names containing Temp
Exclude *Temp*
I want to include tables with names starting with order followed by any single character.
Include order?
I want to select the tables named contacts and lead.
Include contacts, Include lead
Note: Table selection text can't contain negative phrases with "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.
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*.