My Oracle Support Banner

EBC: Access Database View In Siebel Database (Doc ID 1500391.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Financial Services CRM - Version [21238] and later
Information in this document applies to any platform.


On : [21238] version, Configuration - General

Trying to create new external schema based on the Siebel DB (Oracle DB) using tools.
The wizard in tools is not showing the database views.

The wizard should show the database views.

To reproduce:
Connect to Tools in Oracle DB environment.
Open the New Object > External Table Schema Import.
Select ODBC from the Specify the type of schema source.
Select ODBC connecting to the Siebel database and specify the table owner.
In the select tables, you cannot see any database view, only tables

Connecting to MSSQL ODBC is showing database views as well.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.