Skip to Content
avatar image
Former Member

JDBC adapter questions

Hello all,

I have been playing around with the JDBC adapter on my XI sandbox to figure it out. I read through a few guides and I almost have a good handle on it, but there is still a big question lingering. I have configured an example scenario in which I would like to pull data out of the USR01 table from the XI database and transform some user data and place it back in the same table. I was able to get my connections correct and have the communication channel successfully execute SQL statements to alter the data. For example, my <b>Query SQL Statement</b> in the sender communication channel is as follows:

SELECT * FROM USR01 WHERE BNAME='ZTEST2'

And the <b>Update SQL Statement</b> in the sender communication channel is:

UPDATE USR01 SET BNAME='ZTEST' WHERE BNAME='ZTEST2'

This works fine and when I go to transaction se16 and pull up that table I see that the username gets modified when the interface is activated. However, I haven't really figured out exactly how to configure the communication channel / data types so that I can run a SQL statement that will populate my data type that I created for mapping. In other words, lets say I created a data type that looks as follows:

mt_sender
    row
         MANDT
         BNAME
         STCOD

And I want to populate that data type with data from the USR01 table (in the corresponding fields), what would my SQL statement look like in the sender communication channel? I read a few weblogs on how to do scenarios like this, so I built my receiving Data Type to look like this:

mt_receiver
     STATEMENT
          ROW
               action
               TABLE
               access
                    MANDT
                    BNAME
                    STCOD

But I still don't understand how exactly XI correlates the data types / mapping and transformations to the SQL statements....

I'm having a hard time putting this into words, but basically I'm asking a rather high level question I think. How does XI relate the data types to the data it pulls from the SQL statements? How do I actually get the SQL statement to populate my data types so I can do mapping and then repopulate the database table again? Does this make sense?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers