info reg reciever JDBC adapter's driver and connection

[Former Member]

Hello,

I have following questions related to JDBC receiver adapter.

1. can I supply jdbc driver and jdbc connection dynamically to supply the DB parameters dynamically?

2. if I cant supply dynamically, how do i achieve this purpose?

3. What are the receiver adapter parameters of JDBC receiver adapter that i can change dynamically?

thanks and regards,

Nikhil.

[former_member556603 · Accepted solution]

Hi,

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

follow this thread

SAP Note 850116 has details

Thanks,

Satya Kumar

Reward Points If it is Useful..

[Former Member · Accepted solution]

well,

i do know how to use JDBC parameters,

I am looking for some info on how do I dynamically place the parameters in receiver side JDBC.

its like i have to connect multiple Databases dynamically based on the database and I want to provide these parameters dynamically.

is there an option to do so ?

I dont see a check box " use adapter specific parameters in the receiver JDBC parameters "

how can i supply these parameters dynamically?

regards,

nikhil.

[former_member192892 · Accepted solution]

Well,

Use mutiple receivers... Use conditional receiver determination to route and configure each comm channels in the receiver to be DB specific...

There are no ASMA for jdbc adapter

[Former Member · Accepted solution]

Thanks Varun.

I am closing this post assuming there is no other solution.

if anyone has a different solution, please let me know to dynamically connect to different DBs without changing the CC parameters manually.

thanks again

Nikhil.

[Former Member]

Hi,

Check teh below thread for how to install JDBC derivers and what connection parameters are required.

U need to give the parameters in JDBC adapters only.

chirag