After you create database connections, you can begin creating data sources for those connections for use in projects.
You must create the database connection before you can create a data source for it. See Creating Database Connections.
- In the Data Sources page, go to the Create pane, and click Data Source.
- In the Create Data Sources dialog, click the connection to the database that you want to use for your data source.
- In the Create Source dialog, browse or search for and double-click the table that you want to use. Add the columns that you want to include in the data source.
- Complete the Create Source dialog fields as necessary. Note the following options:
- Click Enter Logical SQL to display the Logical SQL Statement field. Use this field to write a SQL statement to specify the tables and columns that you want to use in your data source.
- Click Refresh Data to view a snapshot of the data in the columns that you selected.
- Click the Filter icon at the top of the dialog to create column data filters. After you add a filter, click Refresh Data to review the filtered data.
- Click the General icon at the top of the dialog to specify a name and description for the data source.
- Click the General icon and change the Query Mode for a database table. The default is Live because database tables are typically large and shouldn’t be copied to Oracle Data Visualization. If your table is small, then select Auto and the data is copied into the cache if possible. If you select Auto, you must refresh the data when it’s stale.
- Click OK.The new data source is created and is included in the Databases section of the Display pane. The data source contains a cached copy of the data, and you can refresh the data and metadata from that data source, as needed.