Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 23, 2008 at 07:03 AM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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..

  • avatar image
    Former Member
    Sep 23, 2008 at 06:55 AM

    Hi,

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

    Check this For Refference Use

    PERIODIC SCHEDULING OF DATA BETWEEN ORACLE DB & R/3 SYSTEM

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 23, 2008 at 06:59 AM

    hi

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

    regards

    kummari

    Add comment
    10|10000 characters needed characters exceeded