Add a synchronization schedule

After you registered a data source, you can manually synchronize the schemas in the registered data source or you can create a synchronization schedule to automatically synchronize one or more schemas in a data source on a regular basis.

Note Currently, you cannot filter on specific schemas and tables that you want to synchronize.

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 a database.
• You have set up the metadata synchronization.

Steps