Skip to Content
0
Former Member
May 18, 2012 at 03:19 PM

DBConnect datasource not displaying fields

124 Views

Hi experts,

I have a requirement to take data from an Oracle database (Oracle 11g) to BW using DBConnect.
The user used in the definition of the DBConnect source (also referred to as BI User) has
(1) Read access to the required table which is in another schema.
(2) Has a view on this table in its's own schema.
However when I try to create a Datasource on this view, I get no entries in the Proposal and Fields tabs.
Both external database and BW database --> Oracle 11g.
What is more perlexing is that our Application component has an existing datasource on the same view
(created about 3-4 years back),the fields tab of which has entries.Iam also able to preview the data in this
datasource.
Kindly advise on how I should proceed so as to successfully load this data to BW using DBConnect.

Regards,

Unnikrishnan.R