Create New/Edit SQL Data Source
Use the Create New SQL Data Source wizard (or Edit SQL Data Source wizard) to create a new SQL data source for all portals (if accessed through the Shared Assets page) or for the current portal (if accessed through the Assets page). More
| Element | Description |
|---|---|
|
Name |
(Required) Enter a name for the new SQL data source. |
|
Description |
Enter a description for the new SQL data source. |
|
JDBC Data Source |
(Required) Enter a JNDI name of JDBC data source. |
|
Password |
(Required) Enter a password for the JDBC data source. |
|
SQL Statement |
Enter a SQL statement. You can use |
|
Updatable |
Select to allow this SQL data source to be updated. The underlying table must have a primary key defined on the table for this feature to work. |
|
Test |
Click to confirm whether required entries are complete and valid. |
Related Topics
"Creating, Editing, and Managing Assets" in Building Portals with Oracle WebCenter Portal
"Working with Shared Assets" in Building Portals with Oracle WebCenter Portal