extract the data from database and send to XI in form of file

[Former Member]

hi,

I am working on a scenario in which i am to extract thew data from an ODBC database. and send it to Integration Engine using a file adapter. In this case which adapter i should use? If i go for file adapter then how i will extract the data and if i go for JDBCadapter then i can't send the data in the form of file which is my basic requirement.

Can someone help me out.

[Former Member]

Hi,

If I understood the problem correctly, then use JDBC receiver and file adapter as sender. Should do the trick for you.

[Former Member]

sorry dear but i have not talked about receiver, my sender is database system from which i am to extract the data and convert it into file and send it as a file.

[Former Member]

Hi,

No Need to Use Any other file Adapter to send the file to XI,

By Using the JDBC Adapter Itself you can Extract the data from Dbase and send the data in the form of xml to XI.

Thats all

Regards

Seshagiri

[dharamveer_gaur2]

U can BPM here.

flow Jdbc adapter->Recieve by BPM->File.

inside BPM transform data recieve by Jdbc adapter(transformaton bw jdbc-file) now again transform this file stucture data into Target file sturcture.

[Former Member]

Sorry maybe my earlier answer was confusing. I was using XI convension of sender and receiver, (which is actually confusing untill you get used to it )

Anyway Use JDBC adapter to extract data form your source database system. To send data as file to your receiver system use file adapter. I guess you might need some mapping (and or FCC in file adapter) if the receiver wants specific file format.

Hope its clear now?

[Former Member]

hi dear,

I am not clear with urs answer. Can u describe it more.

Should i need to use file adapter at sender end. How can i use security setting while using JDBC adapter as there is no such option in that adapter and i need to ZIP the data that i am going to do using PayLoadZipBean module for that but i need tosend digital certificate also. How to send it.

[Former Member]

Sorry dear, Actually I am taking till sending my data to XI engine. At receiver i am using web service.

I have got the solution. I m trying to do using BPM. Can u tell me how to send digital certificate along with data which i am sending using JDBC adapter as u told to do..

[Former Member]

hi

you can use the JDBC ADAPTER at sender side to get the data from the database using select query.

regards

kummari

[Former Member]

Hi,

You can Use JDBC Adapter to pull the data from Dbase very well.

Check this For Refference Use

Regards

Seshagiri

[Former Member]

hi,

Thanks for reply. But my Q. was when i am using JDBC for extracting then how can i use file adapter to send this data as file to XI. in that case what should i do.?

[Former Member]

hi,

Thanks for reply. But my Q. was when i am using JDBC for extracting then how can i use file adapter to send this data as file to XI because I am to send digital certificate along with data