I search for a lot of document for  ABAP Proxy and JDBC, some of them are implement in an older SAP system, and others are not detail enough.So I want to write a step by step guide to record the procedure I implement such a interface, hope it can help others who are interesting in ABAP Proxy or JDBC.

The content is:

1.    Deploy JDBC Driver

1.1    Download SAPXI3RDPARTY

1.2    Download JDBC Driver

1.3    Prepare com.sap.aii.adapter.lib.sda

1.4    Using SUM to deploy the sda file

2.    Configure ESR

2.1    Create Data Type

2.2    Create Message Type

2.3    Create Service Interface

2.4    Create Message Mapping

2.5    Create Operation Mapping

3.    Generate ABAP Proxy Consumer

3.1    Configure RFC destination to ESR

3.2    Generate Consumer

4.    Configure Integration Runtime

4.1    SLD Connection from ABAP to AEX SLD

4.2    RFC Destination to PI SOAP Adapter

4.3    Integration Engine Configuration

4.4    Register the jobs to auto execute queues

4.5    Activate the XI engine service

5.    Configure ID

5.1    Configure Scenario via wizard

5.2    Configure the SOAP adapter

5.3    Configure the JDBC adapter

6.    Test

7.    Reference

Now let’s begin.

1. Deploy JDBC Driver

1.1 Download SAPXI3RDPARTY

My Company’s Application Components My Company’s Software SAP NETWEAVER SAP NETWEAVER 7.4 Entry by Component Process Integration

/wp-content/uploads/2015/09/1_781931.png

/wp-content/uploads/2015/09/2_781932.png

1.2 Download JDBC Driver

According to different database, I need deploy different JDBC Driver. The database in this demo is MSSQL Server 2012, so download the microsoft JDBC Driver 4.0.

http://www.microsoft.com/en-in/download/details.aspx?id=11774

/wp-content/uploads/2015/09/3_781933.png

/wp-content/uploads/2015/09/4_781934.png

1.3 Prepare com.sap.aii.adapter.lib.sda

Unzip the file com.sap.aii.adapter.lib.sda from SAPXI3RDPARTY

/wp-content/uploads/2015/09/5_781935.png

Unzip the JDBC Driver 4.0

/wp-content/uploads/2015/09/6_781936.png

Open the file com.sap.aii.adapter.lib.sda with compression tool, add the file “sqljdbc4.jar” to lib

/wp-content/uploads/2015/09/7_781940.png

Decompression the file server\provide.xml,

Add new line contain the JDBC Driver jar,

/wp-content/uploads/2015/09/8_781941.png

replace into the file com.sap.aii.adapter.lib.sda

/wp-content/uploads/2015/09/9_781942.png

If you want to deploy the sda file another time, you need to change the component version to higher by modify the files MANIFEST.MF and SAP_MANIFEST.MF:

/wp-content/uploads/2015/09/10_781946.png

/wp-content/uploads/2015/09/11_781947.png

/wp-content/uploads/2015/09/12_781948.png

1.4 Using SUM to deploy the sda file

Copy the sda file to PI server:

/wp-content/uploads/2015/09/13_781952.png

Download and decompression the SUM(SAP Update Management):

/wp-content/uploads/2015/09/14_781953.png

Execute the STARTUP.BAT with user <sid>adm:

/wp-content/uploads/2015/09/15_781954.png

/wp-content/uploads/2015/09/16_781955.png

Open the url http://host:4239/

/wp-content/uploads/2015/09/17_781956.png

Run the sdtdsu.jnlp

/wp-content/uploads/2015/09/18_781957.png

/wp-content/uploads/2015/09/19_781958.png

/wp-content/uploads/2015/09/20_781959.png

/wp-content/uploads/2015/09/21_781960.png

Specify the folder caontain the sda file.

/wp-content/uploads/2015/09/22_781961.png

/wp-content/uploads/2015/09/23_781962.png

/wp-content/uploads/2015/09/24_781963.png

The target version is I maitain above.

Click “continue” always

/wp-content/uploads/2015/09/25_781964.png

  1. Completed.

Check the deploy library in following folder:

D:\usr\sap\PIQ\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib

/wp-content/uploads/2015/09/26_781965.png

The links of other parts:
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply