cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC

Former Member
0 Kudos

While handling the sender JDBC ..What are the information we need to do ...Prerequisite or what we have to ask client.what should be installed or configured

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

1. Which Data base they are using

2. Install the JDBC drivers in the XI server(we should know the

JDBC Drivers and connection path)

3. User name and password of the database.

4. Which table in which fields we use(know the table name

and fields name)

Ex : If the data base is my-sql then

JDBC Driver : com.mysql.jdbc.Driver

Connection : jdbc:mysql://<XI_servername : port>/db_name

user name : root

password : india

SQL stmt : select f1 f2 .... fn from <tab_name> where <cond>

Edited by: Ramesh on Feb 28, 2008 4:00 PM

nisarkhan_n
Active Contributor
0 Kudos

Firstly on the basis angle

1. Check the Database which is it and install the appropriate Driver files on the XI server.

2. Depending upon the Database type use the appropriate Connection string, to write the connectin string

you might need

Hostname, database name and Authentication details.

from developer point of view check the tables names and you have acess to it. build the approiate stcutre in XI and proceed.

Former Member
0 Kudos

Hi,

For this you need to install the JDBC drivers on XI Server First

you have to take the Driver name and connection, so that u can specify those in the adapter.

How to install JDBC drivers

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

Have a Look at this Disscussion

Regards

Seshagiri