on 07-07-2008 1:45 PM
Hello Experts,
If i want to perform File to JDBC Scenario, Is it require any pre-requisite for JDBC Adapter configuration.
Thank you
Hi ravi kumar chandragiri ,
The following websites will answer u'r question:
JDBC is a technical Adapter provided by SAP.
Configuring the Sender JDBC Adapter
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm
Configuring the Receiver JDBC Adapter
http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm
SAP XI Utilize SAP Adapters to connect to heterogenous systems
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
File to JDBC:-
For Configuring jDBC adapter -
http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm
To do Jdbc scenarios initially we have to install jdbc drivers in the XI server to get connected to the database . and specify the connection details in the jdbc communication channel.
Regards,
Pradeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need to have your JDBC drivers installed in the SAP XI server and you can start configuring the JDBC details with the driver and the connection parameters.
Regards,
Nithiyanandam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Pre-requisites for JDBC Adapter is
Install JDBC drivers on XI Server
Follow the bellow guide on how to install
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.
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The Prerequisite for JDBC adapter :
-Access to a database system or any other database that provides
JDBC drivers, to write the data into DB.
-The Driver should be deployed in the Server.
-Configure User in the SQL enterprise manager tool or similar tool for any other databases
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, it is necessary to follow the structure of the JDBC to insert the data into the database else throws exception, but as UPDATE command is mandatory you should use it, if you dont want to any updation just type <TEST> there in the Update column.
follow this links it will be very useful
Receiver Structure
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
JDBC Discussions
Step By Step Process
regards,
Kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.