Export and Import a CSV File Containing Synonyms for Data Model Columns

Business users can add synonyms for data model columns to a CSV file exported from Oracle Analytics by the administrator. After the administrator uploads the modified file, the synonyms are applied to the data model. The synonyms make it easier for users to search and find columns when they search from the home page or use Oracle Analytics AI Assistants.

Administrators can import updates from partial CSV files. Instead of sharing a single CSV file with multiple business users to add synonyms, create and distribute separate CSV files, that include only the columns assigned to each business user. Import each file after the assigned user completes it. If more than one user adds synonyms for the same column, the most recent import overwrites earlier changes to that column.

Indexing starts automatically after you import the file, so there is no need for you to run indexing manually. The index process is fast and the synonyms are implemented for use in the home page and AI Assistant in a few minutes.

Share these links with business users to help them properly assign synonyms for data columns: About Managing Data Model Indexing and Synonyms Using a CSV File and Tips on Using Synonyms for Search.

Alternatively, administrators who have access to the Search Index page can add synonyms to specific data model columns through the Data Model tab. See Specify Synonyms for Data Model Columns from the Console.

Tip:

Use the CSV import and export process to migrate AI-ready data model metadata between environments.
  1. On your home page, click Navigator Navigator icon used to display the Navigator, then click Console.
  2. Under Configuration and Settings, click Search Index.
  3. To export the data model index configuration in a CSV file:
    1. In the Data Model tab, click the data model you want to export as a CSV file. Clicking the model activates the Import and Export buttons.
    2. Click Export to create the CSV file and download it to your computer.
  4. To import an updated CSV file containing new or updated synonyms:
    1. In the Data Model tab, click the data model you want to import as a CSV file. Clicking the model activates the Import and Export buttons.
    2. Click Import.
    3. In the Upload Crawl Config dialog, browse for and select the CSV file to import, and click OK.