JDBC Adapter: Select from a view

[Former Member]

Hi experts,

i want to use a jdbc-receiver adapter and select data from a view.

How do I configure the connection string correctly to work with a view?

Regards,

Chris

[VijayKonam · Accepted solution]

It is not different from any other JDBC scenario. Replace the table name with view name. By the way, to selct data you should use JDBC sender adapter.

VJ

[Former Member · Accepted solution]

tx ... sure sender

[Former Member]

> i want to use a jdbc-receiver adapter and select data from a view.

>

You will require a JDBC-Sender Adapter rather jdbc-receiver, because jdbc-receiver will update the data into databse rather fetching the data from the database.. correct.

> How do I configure the connection string correctly to work with a view?

>

So you need to configure a sender jdbc adapter, but before configuring it you need to install the jdbc [Drivers|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfcf3a].

Search on sdn to know the configuration details about Sender jdbc adapter.