Test cases for File to JDBC scenario?

[Former Member]

Hi Experts,

I would like to know what are the things needs to be tested to ensure that the File to JDBC scenario holds good in the PI box. Your valuable inputs are required to verify /check my scenario configuration is free of errors.

Thanks & Regards,

Pcv.

[former_member200962 · Accepted solution]

Hi,

You can try the following:

1) If the end systems require authentication and the same is not provided in PI then it should throw an error.

2) Check what happens when you dont give a mandatory field.

3) check what result you will get when you give a wrong input.

4) Check whether all your restrictions (in mapping and/or in receiver determination) are working properly.

5) Check what you need to do when the target system is down.

6) If using any FCC then check whether the conversion is done properly.....

7) See to it that you have defined a proper DB structure when you are communication with JDBC

😎 Check with the end system whether your statement (Insert/Update/Delete etc) is performed properly

Regards,

Abhishek.

Edited by: abhishek salvi on Dec 4, 2008 9:58 AM

[Former Member]

HI Praveen

Most important thing is load testing. As JDBC can face issues with High load so test this as well. Other than this while developing just take care of mapping and XML Query structure given by SAP.

Thanks

Gaurav

[Former Member]

Hi,

First and foremost you should do is to check your query manually... This you should do for different kinds of inputs that are in the file.

And then Test your message mapping and validate whether it is as the target structure specified in the saphelp document:

[Document Formats for Receiver JDBC Adapter|http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm]

Rest things like Oracle system is down etc you will get to see in the JDBC adapter. Also for errors on file side you can monitor in sxmb_moni and File adapter.

Regards