Skip to Content
avatar image
Former Member

Info required for flat file lookup

Hi Gurus,

I'm having a requirement where in which I need to do a flatfile lookup in a mapping.

I refered to one blog:

Making CSV File Lookup Possible In SAP XI !!!

Which adapter I need to create fot his mapping lookup?(JDBC or File)

Since Mapping Lookup supports only SOAP,RFC and JDBC adapter type communication channels.

So if I'm creating communication channel of JDBC adapter type, what driver name I need to specify and what connection I need to give?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 08, 2008 at 10:22 AM

    Use my Wiki page https://wiki.sdn.sap.com/wiki/display/XI/FileLookupin+UDF for File look-up

    Thanks

    Farooq

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi farooq,

      I am having a similar requirement as mentioned in your blog.I tried to implement the same but i am getting some errors

      1.For using URL class in the UDF ,which package we need in imported.I am getting an error "cannot resolve symbol URL class and URL connection class"

      2.The information stored in the file which i am using is not having "=" instead it has a ":" in between the source and the value

      like in this case it will look like :FFFF:66666 in my file.

      Can we do the lookup if the file is in this format ?

      Your inputs will help me allot

      Regards

      Sri

  • avatar image
    Former Member
    Aug 08, 2008 at 10:26 AM

    Hi I think the connection parameters in JDBC adapter might be,

    JDBC Driver: com.jdbc.MySQL.Driver

    Connection: jdbc:oracle:thin:@<server IP>:<port>:<DataSource name>

    Here if I use Mysql driver then what is the port I need to give?

    Server IP I can give where the file residing?

    What is the port that I need to give?

    What is the data souce(generally it is table Name) I need to give? but here I'm looking into Txt file.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 08, 2009 at 10:56 AM

    ok

    Add comment
    10|10000 characters needed characters exceeded