Create a new regular datasource

Create a new datasource for any dataset that you want to import and merge into the Oracle Site Select site profile database. You will determine the unique identifier for the datasource and set up definitions for each field in the datasource.

You must have a role with Data Source Management permission to complete this procedure.

Note:

This procedure applies only to regular datasources. If your organization will use composite datasources, please contact your Oracle Project Manager for assistance.

1. Click menu in the page header. Then open the Account menu, and click Account data sources.
2. On the Account data source management page, click Create new data source.
3. On the Definition tab, at Step 1: Define datasource structure, enter a unique Datasource name, optional Description, and Upload a CSV schema file (max size 1MB).
   Once uploaded, the file name displays below the upload field, and the page auto-saves. You'll see the save timestamp to the right of the upload field.
4. At Step 2: Map the imported columns to Select data columns, use the Unique ID column from imported data drop-down to specify the unique ID column for the new datasource.
5. The left side includes the columns from the CSV upload. You can Search for a specific column, and optionally check Show only unmapped columns to filter the list. The right side includes Oracle Site Select standard data fields.
6. For each column on the left, find (optionally Search) a matching column on the right. You can drag and drop the field from the left to the right side or right side to left. When you've dropped the column to match it, the Mapped to: line in the field updates and mapped icon displays. Map all columns, including the unique identifier column.
   Click the column properties icon to open the Data column properties drawer where you can view, but not edit a Select standard column's definition and attributes.
7. Optional: If an imported column doesn't easily map to an Oracle Site Select standard column, drop it into the Create custom column field at the top of the right side column. In the Data column properties drawer, adjust drop-down entries for all applicable fields (Display name is required) and check filtering and scoring options as available/preferred. At the top of the drawer, click Save.
8. When you've completed mapping, at Step 3: Publish the datasource, click Publish datasource.
9. Review the statements in the confirmation window, and click Proceed.