on 01-16-2014 3:25 AM
Hi all
Very happy new year.
Please send me how to do JDBC to SAP PI and vice versa.
I have searched and found many documents on 7.1 please help on SAP PI 7.3.
Urgent required.
Thanks in Advance
Regards
Sharada
Hi,
In our scenario wish to connect to Sql server from PI.
Wish to get some links for connection to sql server .
Regards
Sharada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sharada - I'm not sure if you had a look into the notes which i shared earlier.
There is an SAP note #1931899 - AEX/PI - Deploying external drivers with SUM which clearly explains on how to deploy the JDBC drivers. Step by step explained with screenshots:
http://scn.sap.com/docs/DOC-25113
How and from where to download the drivers : refer to first few screenshots from the below document :
Best practices :
Samples:
Hello ,
The connection error solved after activate the RFC in sender channel.
Have wriiten a call function in abap as
CALL FUNCTION 'ZTEST' in background task DESTINATION 'RFC2JDBC'
When I am running the abap code after completing for sending data from R3 to JDBC in SM58 this error is coming.
The status message is given as follows.
Commit fault: com.sap.aii.adapter.rfc.afcommunication.RfcAFWException: se
For adapter checking in SAP PI what tcodes to be used for this particular error.
Thanks in Advance
Sharada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did you registered the business system of ECC in PI via SLD or created the business service ...
if you used business service then check the adapter specific identifiers of the service contains the relevant systems details of ECC...
For monitoring the Channels in PI go to you configuration and monitoring link in PI and there select communication channel monitoring and check for your channel state...
HTH
Rajesh
Hi,
1.Created a business system .
Host name added in SAP R3 for sql server with support of Basis.
2.While checking in Monitoring in PI in receiver
Monitoring in ping of adapter engine getting
an error in
Database connectivity test .:Could not open connection jdbc:microsoft.sqlserver://<hostname> : <Portname> ;DatabaseName=test.
3.RFC_SEND_communication channal
Gateway test - no error
metadata repository - no error
mock message send - no error
*Interface metadata availability test - (Error ) No bindings found
How to check if the sqlserver driver is installed or JDBCODBC driver is installed properly.
Regards
Sharada
Hi Prabhaker,
Go through the below link to check the JDBC drivers deployed properly or not?
You should download the drivers which are given for that particular database version.
If it the drivers are properly configured, ask your basis team to ping the JDBC server from the server.
check whether it is working or not?
Also check if any firewalls are blocking the connection..
Regards
Bhargava krishna
Hi Sharada -
SAP provides an ear file to do such validations you just need to deploy an EAR file "FTP_JDBC_ConnectionValidation_731.EAR"
Please refer to the below note for process steps..
1085539 - XI JDBC/FTP connection Test and XML Validation Application
After the deployment check the below blog.
Hello Sharada,
Perhaps you are new to the SCN forums? Please familiarise yourself with the forum Rules of Engagement.
Regards
Moderator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks mr Amit Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Mr Rajesh pasupala.
Got stuck in creating the TCP/IP connection in SM59
Error
Logon Connection Error
Error Details Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=67
Error Details ERROR: program ZPRODTOJDBCSH not registered
Error Details LOCATION: SAP-Gateway on host bidevl / sapgw00
Error Details DETAIL: TP ZPRODTOJDBCSH not registered
Error Details COMPONENT: SAP-Gateway
Error Details COUNTER: 1100
Error Details MODULE: gwr3cpic.c
Error Details LINE: 1833
Error Details RETURN CODE: 679
Error Details SUBRC: 0
Error Details RELEASE: 720
Error Details TIME: Thu Jan 16 11:47:30 2014
Error Details VERSION: 2
Kindly help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Once you create the TCP/IP destination with program id...dont test it unless the same program id has been configured in the RFC sender channel in PI System...
Once you activate the RFC sender channel then test the RFC destination....connection should work that time... if require more info on this advice you to search on SDN for configuring the same...
HTH
Rajesh
Thanks Mr Rajesh pasupala.
Got stuck in creating the TCP/IP connection in SM59
Error
Logon Connection Error
Error Details Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=67
Error Details ERROR: program ZPRODTOJDBCSH not registered
Error Details LOCATION: SAP-Gateway on host bidevl / sapgw00
Error Details DETAIL: TP ZPRODTOJDBCSH not registered
Error Details COMPONENT: SAP-Gateway
Error Details COUNTER: 1100
Error Details MODULE: gwr3cpic.c
Error Details LINE: 1833
Error Details RETURN CODE: 679
Error Details SUBRC: 0
Error Details RELEASE: 720
Error Details TIME: Thu Jan 16 11:47:30 2014
Error Details VERSION: 2
Kindly help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Scenario is R3 to PI and PI to JDBC adapter to sql server and vice versa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you cannot get step by step guides for every version & scenario of PI here....
if you are using the single stack of PI then you can configure your scenario with ICO objects.
else same existing how to guides applies for your PI system also.
Start the scenario and post your queries if you get stuck up some one here can help you out..
Gud Luck
Rajesh
Hello,
Did u search SDN?
Sometime typing few letters can do wonders for u...
Thanks
Amit Srivastava
Im new to SAP PI . So difference does matter can you give some step by step documents.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sharada - There are no major changes b/w 7.1 and 7.3
- confirms no changes b/w 7.1 and 7.3
Configuring the Sender JDBC Adapter - Advanced Adapter Engine - SAP Library
You can follow the documents on 7.1.
Let us know if you are facing any issue/ looking for specific requirement.
Have a look at the below notes..
1931899 - AEX/PI - Deploying external drivers with SUM
831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter
Message was edited by: Hareesh Gampa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.