JDBC Adapter help required.

[Former Member]

Hi All,

Suppose I want to use JDBC Receiver adapter for new database.

Please tell the process/blogs what steps I need to do in XI and Visual Admin for ---

Database Connection Part:

JDBC Driver, Connection, User Name , Password.

Please suggest.

Regards

[dharamveer_gaur2]

Hi

In ServerHostName can I give IP address?

Yes You can use IP address of Oracel server.

What is SID?

SID is Oracle Server Name to access globaly

[Former Member]

Hi...

Please find the below links.

Regards,

Leela

[Former Member]

hi ,

kindly look into these links .

[http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm]

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2590] [original link is broken] [original link is broken] [original link is broken];

[https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/jdbc%252b2%252bjdbc]

thanks and regards

Edited by: ROBIN C on Nov 12, 2008 12:46 PM

[Former Member]

HI Rick

You can find the no. of blogs in SDN.

For JDBC Drivers:

In Visual Admin go to Service.

Find JDBC connector.

Select the JDBC connector.

Find the drivers.Choose the driver.

There you can able to find the JDBC Driver.

Check this for installing Drivers...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

For Drivers...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b3848d77...

After deploying jdbc drivers you need to configure the Communication Channel by providing these values

user name: <Database user>

password: <user login password>

driver: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@<ServerHostName>:1521:<SID>

Find below link will help u for more information

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#02_02

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html

Regards

Goli Sridhar

[Former Member]

Hi ,

I need to use Oracle Database. Pls let me know the below steps:

1. Steps I need to do in Visual Admin: --

In Visual Admin go to Service.

Find JDBC connector.

Select the JDBC connector.

Find the Oracle driver -- which one will be Oracle Driver . Pls tell?

2. How will I deploy the above Oracle Driver? Pls tell?

3. In XI in JDBC Receiver Adapter I have toi give

JDBC Driver -- oracle.jdbc.driver.OracleDriver

Connection -- url:jdbc:oracle:thin:@<ServerHostName>:1521:<SID>

In ServerHostName can I give IP address?

What is SID?

Regards

[prateek]

Have u seen this?

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

In ServerHostName , u may give the Ip address.

Regards,

Prateek

[Former Member]

Hi ,

I am not getting much from this.

Please tell me the general procedure for all this.

Regards

[Former Member]

wat u r not getting. can u pls explain.

refer this weblog.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

and deployment process.

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

forgive me if i some one has already provided the above link.

chirag

[dharamveer_gaur2]

Hi

server detail

user name: Database user name

password: Database password

driver: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@<ServerHostName>:<PortNo(1521 default)>:<SID>

look this thread for Jdbc receiver configuration

use this document for JDBC receiver structure

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

[Former Member]

Hi Rick,

When ever Receiver is JDBC Adapter we will use the Standard Structure.Check this blogs its very useful.

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1772. [original link is broken] [original link is broken] [original link is broken]

Regards,

Sateesh N.