Configure Asset Synchronizations

You can synchronize Oracle Content Management with another database where your content is maintained. This could be an on-premise or a cloud-based database. The file import agent synchronizes content for you based on the asset synchronizations you've configured.

To configure asset synchronizations:

1. On the Metadata tab of your procedure, go to the Asset Synchronizations table, and click to create an asset synchronization, or edit one by selecting it and clicking . You can delete an asset synchronization by clicking .

2. On the Asset synchronization page, enter a name in the Synchronization Name field (for example, Vendor Asset Synchronization).

3. Select the Online check box to make this asset synchronization available during processing.

   You can activate or deactivate an asset synchronization by clicking Online/Offline on the Asset Synchronizations table of the Metadata tab.

4. In the Frequency field, enter the time duration honoring which the file import agent will synchronize content items.

5. In the Source Database section:

   1. From the Database drop-down list, choose the database schema of the database in which content is maintained.
   2. From the Table drop-down list, choose the database table that you want to use for synchronization.
6. In the Target Type section:
   1. From the Repository drop-down list, choose the Oracle Content Management repository that should be synchronized with the database you chose in the previous step.
   2. From the Asset Type drop-down list, select an asset type that should be synchronized.
7. Edit the Asset Field and Data Source Value field mappings as necessary. These fields show values from asset type and the database table that you selected in the previous steps. Asset fields shown in this section are defined in the Oracle Content Management repository. The columns in the data source value are of the table you selected in the Source Database section. To successfully complete the asset synchronization, you must map those asset fields that have asterisk (*) next to them. These are the required asset fields. You also need to map all primary keys of the table.

   Click to open the Asset Field Mapping dialog and make the required changes. Only the relevant data source values are shown for the asset fields. You can select from these values as required.

8. In the Restricted Asset Name Value Handling section, choose the next action if the asset name is assigned a value containing invalid characters:
   • Remove invalid characters: Characters that are considered invalid in asset names are: ; " : ? < > % { } \ / * |
   • Skip record synchronization: Logs the record details in the capture.log file of the file import agent.
9. Click Submit to complete the configuration.