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

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.7 [21238] version, Configuration - General

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
The wizard should show the database views.

STEPS
-----------------------
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.

Cause

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 hundreds of Community platforms