JDBC - Question

[Former Member]

Hai,

at the moment I got folowing process: 3 systems SAP R3; XIT and a SYBASE DB. We use the JDBC Adapter to select data from sybase via query push them to a IDOC and send it to R3.

This polling may generate a lotz of traffic on DB so I like to make a push variant - but at the moment I find now way to create a JDBC Sender with push scenario...

Any ideas how to solute - may in a different way?

THX Matt

[MichalKrawczyk · Accepted solution]

Hi Matthias,

let me give you a more general idea:

all modern databases have export mechanisms

like DTS (Data Transformation services) for Ms Sql Server

how can you use it with your scenario?

- schedule the export from SYBASE to an XML file for instance

- then use the standard file/ftp adapter the get the file to XI and map it to an IDOC...

wouldn't this be an easy push scenario ?

Regards,

michal

[Former Member · Accepted solution]

may this would be easier...

so their is no way to use JDBC in the push(ing) way?

I thougth may if I set the interval to zero - it could work?

And 2nd question - how can I connect a BPM to that "File Solution way"?

THX Matt

[MichalKrawczyk · Accepted solution]

Hi Matthias,

>>>And 2nd question - how can I connect a BPM to that "File Solution way"?

standard file -> BPM scenario

take a lok at this weblog:

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

on the file to BPM part

also this one Walkthrough with BPM :

/people/krishna.moorthyp/blog/2005/06/09/walkthrough-with-bpm

Regards,

[Former Member · Accepted solution]

...thx and sorry for may stupid questions - I'm pretty new in XI

[MichalKrawczyk · Accepted solution]

>>> sorry for may stupid questions

it would be much worts if you where affraid to ask

keep asking if you got any doubts there are so many

people on the forum willing to help that it's a very

high change you'll get a good answer

>>>I'm pretty new in XI

we all were

Regards,

michal

[Former Member · Accepted solution]

a small question is still open

Is their any method to replace the interval with an event?So that the adapter doesn't poll every 10 seconds but wait for a event an poll after that?

That was the reason why I'm asking if I may set interval to 0 - adapter will wait for any events?!?!

THX Matt

Message was edited by: Matthias Boettger

[MichalKrawczyk · Accepted solution]

hi:)

>>>So that the adapter doesn't poll every 10 seconds but wait for a event an poll after that?

I don't think so

but you can achive this with the file - jdbc scenario

you can set an event on your database system to put the export file whenever something happens

this way the adapter will only get the file after the event ...

Regards,

michal

[MichalKrawczyk · Accepted solution]

but there might be also another way:

you can build a BPM (integration process)

that will be started with an event

this can be receiver of any type...

file, jms, http -

your even will send a message to this adapter

what will iniciate a process

then inside the BPM the second step will be send step (with jdbc adapter)

this way the jdbc will be staretd with an event...

Regards,

michal