on 02-28-2008 6:34 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Have a Look at this Disscussion
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.