CLAIRE Copilot for Data Integration

Back Next

Guidelines for writing effective prompts

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 information:

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 task type, which can be either "application ingestion and replication" or "database ingestion and replication."

The source and target schema names if you know them.

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 and the yyy target connection. Load records from all tables in the bbb source schema 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:

Keyword	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