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

Business users can add data model column synonyms 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 and make it easier for users to search and find columns from the home page or Oracle Analytics AI Assistants.

You can do partial imports of the CSV file. For example, instead of circulating one copy of the CSV file among several business users to provide synonyms, you can distribute copies of the CSV file that contain subsets of columns to several business users to gather their updates. You can then import each of the CSV file copies as users complete them. Remember that if you use this method and business users mistakenly provide synonyms for the same column, that the last import overwrites synonym changes for the same column from an earlier import.

Indexing starts automatically after you upload 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 data column synonyms: About Managing Data Model Indexing and Synonyms Using a CSV File and Tips on Using Synonyms for Home Page and AI Assistants Search.

Alternatively, the administrator can add synonyms to specific data model columns listed in the Data Model tab to make them easier to search and find from the home page or Oracle Analytics AI Assistants. See Specify Synonyms for Data Model Columns from the Console.

Tip:

You can also use the CSV import and export process to easily 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. In the Console under Configuration and Settings, click Search Index.
  3. To export the data model as a CSV file:
    1. In the Data Model tab, click the data model 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 the updated CSV file containing new or updated synonyms:
    1. In the Data Model tab, click the data model to import as a CSV file. Clicking the model activates the Import and Export buttons.
    2. Click Import and in the Upload Crawl Config dialog, browse for and select the CSV file to import. Click OK.