Tell all the advanced mode parameters in JDBC and FILE adapters

[Former Member]

Hello,

Can anyone tell what all the advanced mode parameters in JDBC and FILE adapters that we use to configure a scenario..

THanks,

Soorya

[Former Member · Accepted solution]

advanced features of file adapter

1)scheduling File Adapter at specified intervals of time, might be a day or some hours.check the link below

part1-https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d458a870-0601-0010-caab-b99c79741964

part2-https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/4f61fddf-0601-0010-7ab5-fb749538f6ab

2)to pick up two different XML files using the Sender file adapter,

In file adapter we have "Additional Files" option.

Give your second file name in this option,you can enter many file names over here with comma separated.

Adapter will pick your file from the one you have entered in file name and also in additional file name.

check the below link

https://weblogs.sdn.sap.com/pub/wlg/1685 [original link is broken] [original link is broken] [original link is broken]

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter

note:reward points if solution found helpfull.....

regards

chandrakanth.k

[Former Member · Accepted solution]

Can you please tell the advanced mode parameters for JDBC adapter also

[Former Member · Accepted solution]

Hi Surya,

Wat is ur requirement. Unless u specify properly we are not able to answer you.

Have u refer the sap note which is provided, have u gone through the link

Chirag

[Former Member · Accepted solution]

Hi Chirag,

I have gone through the sap online help to configure the scenario.

Now i am in testing face to try all the parameters in advanced mode for both sender and receiver.

So can you help me out in finding some parameters to put in that advanced mode table to run and test the scenarios. I know few of th em like,

tastTimeout, logSQLStatement,

Do we have any more parameters like this,

Is there any parameter to limit the size of the message sending or receiving either in advanced mode or in the Channel configuration,

Thanks,

Soorya

[Former Member]

hi

in JDBC Adapter

You now have the option of canceling a particular operating system command after a specified duration

check the link below

sender jdbc adapter

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

receiver jdbc adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

Please refer to note 793922 which refers to Additional module parameters.

JDBC-Adapter: 801367

note:reward points if solution found helpfull.....

regards

chandrakanth.k

[Former Member]

Hi,

Advanced Mode

To specify additional parameters in the adapter configuration, set the Advanced Mode indicator.

● Msecs to Wait Before Modification Check

Enter the number of milliseconds that the adapter must wait before it checks whether the files have been changed.

This parameter is not available if you have selected File Content Conversion as the Message Protocol and then made an entry under Recordsets per Message that splits an input file into several messages.

● Maximum File Size

Specify the maximum file size in bytes.

The adapter only processes files that are smaller than the specified size. An error occurs if files are any larger.

● Table

Specify the additional parameter names and parameter values in the table.

Additional parameters are published in SAP Note 801926.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

Chirag