Not display views/tables on DB connect source system

[Former Member]

Dear Experts,

After creating a oracle DB connect source system, I want to create data sources based on oracle db. But it is not showing any view/table.

Connection is up and running.

Please advice.

Thanks,

Thilini

[sander_vanwilligen · Accepted solution]

Hi Thilini,

Are you sure that the DB user on Oracle has sufficient authorizations?

Does the search help support wildcards? Did you try w/o any wildcard or enter a table or a view name supplied by your Oracle DBA?

Best regards,

Sander

[Loed]

Hi Thilini,

Check your view or table..Ensure that the FIELD names are in CAPITAL LETTERS and with VARCHAR type..

Regards,

Loed

[RamanKorrapati]

Hi,

if DB user name is not mandatory then remove it.

Later enter your db table name and create a data source.

Table/View - Enter DB Table name here.

Thanks