Create OCI Task Schedules from Excel

David Allan
2 min readAug 31, 2023

Often the scheduling of your tasks is captured in Excel spreadsheets, rather than keying this in again, let’s see how we can automate this and create the task schedules from your data. Here we will see how to create schedules and task schedules in OCI Data Integration from a tab delimited file.

The workspace ocid and application key are passed as parameters. The schedules and task schedules are created in this application/workspace and the referenced tasks and schedules are within it. This depends on the OCI Python SDK which is available in the OCI Console Cloud Shell preconfigured or can be installed locally (see here for details).

Save the Python file create_task_schedules.py in the gist below into your client (easiest is Cloud Shell), then save same tsv file(s) for your schedules or task schedules. If you have the OCI Python SDK installed which is already installed in CloudShell, get your workspace OCID and application key and you can run the script.

See the gist here for the script and also example files — you will need to use your own workspace, application etc — note the schedule creation only creates CRON expression in the script but could do all other OCI Data Integration schedules;

This is useful to script the creation of schedules for your environment, it is also an accelerated way of creating the schedules for tasks in the first place! Let me know what you think.

--

--

David Allan

Architect at @Oracle The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.