3.6.1.2 Creating a Dataset from Database Tables or Views

Using a database connection, you can create a dataset from tables and views in the Oracle Database.

Perform the following steps to create a dataset using a database connection:

1. Navigate to the Datasets page.
2. Click Create Dataset.
   The Create Dataset window opens.
3. Select the From table/view option.
4. Select a connection from the Select Connection drop-down.
5. Click Create.

   The Select items to create datasets window opens listing all the tables, views and GeoRaster data present in the database.

   Figure 3-10 Select the Data Source

   
   Description of "Figure 3-10 Select the Data Source"
6. Select a database item from the list and click OK.

   Tip:

   You can also use the Search box to quickly locate your table. This is especially useful or even necessary if your database connection has many tables, as the drop-down list only shows up to 500 tables or views.

   The new dataset is added and listed on the Datasets page.