Add or edit a synchronization schedule

To keep the content of Collibra Data Intelligence Cloud synchronized with the schemas in the registered data source, you can synchronize manually or add a schedule to automatically do this at fixed intervals.

Note You can only add one synchronization schedule for all schemas of a datasource. All schemas with table rules will be synchronized at the specified intervals.

Prerequisites

• You have a global role with the Catalog global permission, for example Catalog Author.
• You have a resource role with the Configure external system resource permission, for example Owner.
• You have a global role with the View Edge connections and capabilities global permission.
• You have the permissions to retrieve the metadata of the following database components through the JDBC Driver Database Metadata methods:
  • Schemas
  • Tables
  • Columns
  • Primary keys
  • Foreign keys
• You have registered your database.
• You have configured the synchronization of your data source.

Steps

1. Open a Database asset page.
2. In the tab pane, click Configuration.
3. In the Synchronization schedule section of the Metadata extraction tab page, click Add schedule to add a new schedule, or to edit an existing schedule.
4. Enter the required information.

   Field	Description
   Repeat	The interval when you want to synchronize automatically, for example daily, weekly or based on a Cron expression.
   Cron	The Quartz Cron expression that determines when the synchronization takes place. This field is only visible if you select Cron expression in the Repeat field.
   Every	The day on which you want to synchronize, for example Sunday. This field is only visible if you select Weekly in the Repeat field.
   Every first	The day of the month on which you want to synchronize, for example Tuesday. This field is only visible if you select Monthly in the Repeat field.
   At	The time at which you want to synchronize automatically, for example 14:00. This field is only visible if you select Daily, Weekly or Monthly in the Repeat field.
   Time zone	The time zone for the schedule.

5. Click Save.
   All schemas with table rules are synchronized according to the synchronization schedule.