1. Oracle WebCenter Portal Online Help
  2. Online Help Topics for Shared Assets
  3. Assets
  4. SQL Data Sources

SQL Data Sources

Out-of-the-box, no SQL data souces exist. You can create a SQL data source at the application level or at the portal level. Application-level SQL data sources are available for use in all portals, unless the portal has been specifically excluded. Portal-level SQL data sources are available for use only in the portal in which they are created.

The default SQL style for all database connections is Oracle. If the data source is a Microsoft SQL Server database, then the system administrator must perform the following tasks:

  • Manually override the SQL style with one that supports the SQL Server database. To do this, set the Java system property jbo.SQLBuilder to SQLServer. When Oracle WebLogic Server is started with this configuration, it supports the SQL style specified.

    Set the jbo.SQLBuilder property in any of the following ways:

    • Open the DomainHome/bin/setDomainEnv.sh file and add -Djbo.SQLBuilder=SQLServer to the JAVA_OPTIONS line.

    • Edit the managed server start script in a text editor and add -Djbo.SQLBuilder=SQLServer to the JAVA_OPTIONS line.

    • In the WebLogic Server Administration Console, navigate to the WC_Spaces managed server, click the Server Start tab and specify the system property in the Arguments text area.

  • Specify Java as a typemap entry using the jbo.TypeMapEntries property as follows: 

    -Djbo.TypeMapEntries="Java"

Select icons and actions in the toolbar to work with SQL data sources. Refer to the online help in the resulting dialogs for information and assistance.