clarification of doubt in File-XI-JDBC scenario

[Former Member]

I had one doubt in this scenario.can anybody Plz clarify in this scenario File-XI-JDBC.

1)where we have to specify the table name in the receiver JDBC comm channel to insert the data into sql database from file.My doubt is,there are so many tables in existence.in the comm channel i am not mentioning the table name any where.

currently i am using SQL server and created one table name "EMP" with n columns.

2)Is i need to configure this sql driver to the J2ee server or by default this will be shipped with XI?

3)Generally,what are the datbase drivers shipped with XI?

Thanks in Advance

Sridhar Raju

[Former Member]

Hi,

>> The Table name needs to be specified in the Receiver Data Type for your scenario.

>> Yes, the JDBC drivers need to be configured in the XI server. For Detailed procedure refer to the Document "How To Install and Configure External Drivers for JDBC & JMS Adapters" in the below link,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Hope this helps you

[Former Member]

1) the table name is specified in the data type for the recvr interface.

chk this:

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

2) SQL drivers need to be deployed in ur server.

3)XI is not shipped with any drivers as such...you need to deployed the drivers for the databases tht you plan to connect to.

[former_member8655]

Hi Sridhar

1) You dont require to mention the name of table in comm channel. You specify it in your data type . your xml format should be

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

Please refer the link for more detail

http://help.sap.com/saphelp_erp2004/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

2) Basically there is an driver file which has to be deployed to the server. But it may be there by default.

You configure and check your scenario, if driver file is not deployed you will get the message in RWB-> Adapter Monitoring.

Regards,

Mitesh.