mapping of messages from database

[Former Member]

Hi all,

can somebody explain me how can I do a mapping between some XML message and message, that comes from database in Design Integration Builder?

I have already done this mapping between 2 xml message and it works.

Now I have to change input-message, it should be from database. I don't know, how I describe this message?

Have I defined there a database structure or only a structure of queryresult? How I can do it? Is there any specification, how it should be done?

I find only an explanation how you can configure JDBC adapter

http://help.sap.com/saphelp_nw04/helpdata/en/e1/091640a991c742e10000000a1550b0/frameset.htm -

[Former Member]

Hi Anna,

Please go through these links and i am sure they will help you understand how the structure for the database should look like...

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

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

Also go through these links to get more info on the scenario you are trying...

http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Abhy

Message was edited by: Abhy Thomas

[Former Member]

Hi Anna:

1) communication channel:

First you have to identify the structure of your database table. For this you can use a sender-communication channel the read data from the database by a select statement

2) SXMB_MONI

If your select-statement works correct, you will see a message in SXMB_MONI. This is how you have to design your datatype & message type.

(Do not forget to set your CC inactive. Otherwise you will get lots of messages in SXMB_MONI)

3) Mapping

On this base you can do your mapping

Regards Mario

[Former Member]

Hallo Mario!

thank you for your answer.

The first one I'v already done. But can not see any message in SXMB_MONI.

I could not create either a "sender agreement" or "interface determination", because I did not have any interface for this channel yet. Order to create this interface I need a date type -- message type -- message interface.

It was my question, how I can define date type or message type from the message from db?

regards and thank you

[Former Member]

Hi Anna,

if you can't see messages in SXMB_MONI --> check your Adapter!!!

Every messages that comes inside XI must first go through an adapter (JAVA stack)

Messages that you can see in SXMB_MONI passed the adapter and are now in the integration engine (=ABAP stack)

Regards Mario

[Former Member]

I could not create either a "sender agreement" or "interface determination", because I did not have any interface for this channel

>>> it is enough to configure the sender agreement with communication channel, that the messages reaches SXMB_MONI!!

You will see a red flag, because there is no receiver- & interface determination.

But for the first step (your mapping) you just need the payload from SXMB_MONI.

Then take the payload and design your date type/message type/message-interface.

Regards Mario

[Former Member]

Hello friends,

thank you for your help. I use one of blogs, that Abhy adviced me.

Mario you were right, it is a problem with adapter.

The driver was loaded successfully, but it is not compliant to JDBC.

Could you say me please, which values should I put into connection-field? What driver for MySQL is JDBC compliant?

The error-message, what I am getting, is below:

Processing Error: Accessing database connection 'jdbc:mysql://test:3306;DatabaseName=test;SelectMethod=cursor' failed: java.sql.SQLException: No suitable driver

Addtional information: JDBC driver 'com.mysql.jdbc.Driver' loaded successfully, additional driver information:

Available JDBC drivers:

com.mysql.jdbc.Driver, 3.0 NOT JDBC compliant

[Former Member]

Hi Anna,

sorry, but I do not know which driver to use for MySQL.

Regards Mario