Executing Tasks using OCI CLI in Oracle Cloud Infrastructure Data Integration

Run a task from the OCI Console
Run the task and pass runtime parameters.
oci data-integration task-run create --workspace-id YOUR_WORKSPACE_OCID --application-key YOUR_APPLICATION_KEY --registry-metadata '{"aggregator-key":"YOUR_TASK_KEY"}'
Execute the create task run command

Data Entity Parameters

Example of a CSV data file parameter named INVENTORY_DATA
Example of a JSON data file parameter named INVENTORY_DATA.
oci data-integration task-run create --workspace-id YOUR_WORKSPACE_OCID --application-key YOUR_APPLICATION_KEY --registry-metadata '{"aggregator-key":"YOUR_TASK_KEY"}' --config-provider '{"bindings":{"INVENTORY_DATA":{"rootObjectValue":{"modelType":"ENRICHED_ENTITY","entity":{"key":"dataref:0a5ae9ef-5b74-447a-9d5b-49511f3b7600/a_supplierx_stage/FILE_ENTITY:supplierx_inventory2.csv","name":"supplierx_inventory2.csv","modelType":"FILE_ENTITY","resourceName":"FILE_ENTITY:supplierx_inventory2.csv"},"dataFormat":{"formatAttribute":{"modelType":"CSV_FORMAT","encoding":"UTF-8","delimiter":",","quoteCharacter":"\"","hasHeader":true,"timestampFormat":"yyyy-MM-dd HH:mm:ss.SSS","isFilePattern":false,"escapeCharacter":"\\"},"type":"CSV","compressionConfig":{"codec":"NONE"},"isFilePattern":false}}}}}'
Monitor the tasks running from within the OCI Console
The compression options are defined when selecting the entity.

Data Asset / Connection / Schema Parameters

oci data-integration task-run create --workspace-id YOUR_WORKSPACE_OCID --application-key YOUR_APPLICATION_KEY --registry-metadata '{"aggregator-key":"YOUR_TASK_KEY"}'
--config-provider '{"bindings":{
"DATA_ASSET_PARAM":{"rootObjectValue": {"modelType":"ORACLE_ADWC_DATA_ASSET","key":"your_data_asset_key", "name":"your_data_asset_name"}},
"CONNECTION_PARAM":{"rootObjectValue":{"modelType":"ORACLE_ADWC_CONNECTION","key":"your_connection_key", "name":"your_connection_name"}},
"SCHEMA_PARAM":{"rootObjectValue":{"modelType":"SCHEMA","key":"dataref:your_connection_key/your_schema_name", "name":"your_schema_name"}}}}'

Filter / Join / Literal Parameters

oci data-integration task-run create --workspace-id YOUR_WORKSPACE_OCID --application-key YOUR_APPLICATION_KEY --registry-metadata '{"aggregator-key":"YOUR_TASK_KEY"}'
--config-provider '{"bindings":{
"FILTER_PARAMETER":{"simpleValue": "FILTER_1.USER1OBJECTS_CSV.PID is not null"},
"JOIN_PARAMETER":{"simpleValue":""},
"LITERAL_PARAMETER":{"simpleValue":"777"}}}'

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store