Example prompts for ingestion and replication tasks
You can enter your initial prompt for creating an application ingestion and replication task or database ingestion and replication task in plain English.
The following example prompts demonstrate that the variety of ways in which a prompt can be entered:
•Create a data migration path from Workday using xxxx connection to Amazon S3 using yyyy connection.
•Create a data flow from SAP HANA with ABCD source schema to Kafka, using source connection XXXX and target connection stream_api.
•For the SAP system at connection XXXX, perform a data transfer to the 'Amazon S3' bucket. For this task, exclude tables with pattern TEMP_* and include file partitioning by date with a maximum of 100 files. The target file format should be Parquet.
•From SAP source system, set up a data pipeline to Amazon S3 bucket using the connection XXXX. The source's data will be processed and required to use the Avro format for efficient storage.
•Set up a migration load from Workday to Snowflake using the source connection XXXX and target connection YYYY. This task should be configured to pull the records and prioritize the ingestion of tables with the prefix "INC_PAYROLL_". If schema changes occur, such as column drops or renames, alert the maintenance team but continue processing.
•Perform a data capture from Oracle schema MYSCHEMA with connection XXXX and replicate the data to zzzz. Enable comprehensive logging for all changes and use a high-throughput Kafka topic to handle the volume. Filter out any transient records marked for deletion within the source database.
•Perform a data load from Workday to "Amazon S3".
•Transfer Workday data from XXXX connection to Oracle.
•Move records from Workday to PostgreSQL.
•Generate a task that moves data from PostgreSQL database with connection XXXX to 'Amazon S3'. The tables to be selected are from the ABCD schema in the source.
•Set up a task that moves data from PostgreSQL database connection Dev_XXXX to 'Amazon S3' bucket connection YYYY.
•Move only new data from the SRC schema in source to the target.
•Generate a task to handle loads from PostgreSQL to Oracle. Use "abcd" as the source connection with schema "1234".
•Extract data from Netsuite using the XXXX connection and load it into Kafka.
•Transfer data from XXXX connection to Kafka via YYYY connection.
•Perform data load from source via XXXX connection to Oracle target using connection YYYY.
•Move records from SAP under the XXXX source connection to Snowflake using the YYYY connection.
•Replicate the records from SAP source via the XXXX connection to Oracle using YYYY connection. The target Oracle schema is abc.