Using File-XI-JDBC Scenario

[Former Member]

Dear All,

I am having one scenario in which I have to update third party's SQL Tables with the data from a flat file. The data is stored in the flat file in the following way:

0000000119690607Sunjay Shrivas

0000000419641029Shishir Bhandarkar

0000000519671004Harvinder Singh

0000000619700101Shashi Kant Tiwari

0000000719690911Kamala Rai

0000000819680914Vishav Bhushan Monga

0000000919610829Moloy Mitra

In this file, first eight characters are for employee number, next eight are for date of birth of employee, next 40 characters for employee first name and then for employee last name.

Kindly guide me out in creating in the Data Types and Message Mapping for this scenario.

Warm Regards,

N.Jain

[Former Member · Accepted solution]

Hi,

Create a datatype with fields.Create in the following format

datatype_name

<record>

<recordset>

employee number

date of birth

first name

last name

</record>

</recordset>

Regards,

S.Ramnarender

[vikas_agarwal]

Hi Nishu,

First create the data type as:

datatype_name

<record>

<recordset>

EmpNo

DOB

FName

LName

</record>

</recordset>

Then in Sender Communication Channel do the FCC

Document Name - MessageType Name

Document Namespace- Namespace of the message type

Recordset Structure- record,1,recordset,*

Recordset.fieldNames-EmpNo,DOB,FName,LName

Recordset.fieldFixedLenghts- 8,8,40

Recordset.endSeparator- 'nl'

And use this blog to create the DataType for JDBC

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

Hope it will sove yr problem.

Regards

Vikas

[Former Member]

Hi,

As said create the stucture like that..In addition to that

datatype_name - Complex type

<Record> - Subelement

<Recoedset> - Subelement set the occurence 0 to unbounded

Field1

Filed2

</Recordset>

</Record>

This is for file and for database..

As Sridhar mentioned refer this blog

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

regards,

vasanth

[former_member192892]

Hi nishu

Ram's reply is good enough...

You need to use a JDBC receiver adapter to do the update or insert

[Former Member]

Hi

Have a look

jdbc /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

JDBC receiver

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

use SELECT statement in JDBC

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken] [original link is broken]

stored procedure

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Sender adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

for jdbc adapter...

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

for configuring receiver jdbc adapter...

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

Might be useful.