cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Any suggestion on ?

Former Member

on ‎08-10-2006 10:33 PM

0 Kudos

I have following end-2-end scenario.

1) Need to get SQL WHERE clause values from file

2) Fetch the data from SQL SERVER DB

3) Validate the SQL response into Invalid and Valid records

<u><b>Process for INVALID RECORDS</b></u>

4) Send invalid records to Shared file folder

5) Send an ALERT to the user of the invlaid records

<u><b>Process for VALID RECORDS:</b></u>

6) Execute a stored procedure to insert/update in a table

7) FTP the file to Target System

😎 Back up the file to File folder

<u><b>My Solution</b></u>

1) Get SQL input data using File adapter

2) Fetch SQL DB data using JDBC synchronous Adapter

3) Create 2 ABSTRACT Interfaces one for VALID and the other for INVALID records

4) Develop a Java mapping program to segregate the input

5) Develop 2 BPM Processes separately for VALID & INVALID

Will this work.

I greatly appreciate any input on this..

Thanks

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

moorthy
Active Contributor
‎08-10-2006 10:56 PM
0 Kudos

Your BPM steps-

1) Receive the File Message

2) Send this message into SQL i.e Sync Send

( This file req and SQL req mapping is done outside the BPM and SQL resp and response structre mapping)

3) Get the Response back into BPM and then execute the Transformation step (i.e 1:N mapping-)to segregate the valid and invalid records. Here mapping(i.e java) it depends on the complexity.

3)So now you have 2 messages , you can send these 2 simulatneously with the help of Fork step . one is for Table and one is for File system.

4) Raise the alert for the invalid records.

<i>5) Develop 2 BPM Processes separately for VALID & INVALID</i>

>>>Are you going to create 2 bpms ??? not required.

Regards,

Moorthy

Show replies
Show replies
Former Member
‎08-11-2006 12:17 AM
0 Kudos

Moorthy,

Thanks... Your answer is very helpful.

I clicked the very help ful radiobuttin to award the point. Is this the correct way? I am new to this site and never done this before..

One more thing:

You said:

1) <i>Receive the File Message</i>

I meant, thru a ASYNCHRONOUS FILE SENDER, you mean the same right.

2) <i>Send this message into SQL i.e Sync Send</i>

Can I send a message from

OUTBOUND FILE ASYNCHRONOUS

OUTBOUND JDBC SYNCHRONOUS

Please clarify..

Thanks

Venu

Former Member
‎08-11-2006 12:40 AM
0 Kudos

1) yes u need to receive the file message 'Asynchronously' in BPM. The actual Asynchronous file send step is outside the BPM>

2) Synch Send step is from BPM. These are the steps usually,

a) Send the file (outside the BPM)

b) Receive the file (BPM)

c) Synch Send step (for JDBC) - also with in the BPM

And then the other process Moorthy has mentioned

Former Member
‎08-11-2006 12:55 AM
0 Kudos

Can you explain little more as I don't kow much about BPM

Will I have two interfaces for my SQL file input?

1) First one is for pushing the data to XI

2) Second one to receive it into BPM.

Can I do following?

1) FILE ASYNCHRONOUS SEND

2) Have mapping done to SQL REQUSET (JDBC-SYNC-SEND)

3) Map JDBC-SYNC-OUT to INVALID and VALID record types(inside BPM)

Thanks

Venu

Former Member
‎08-11-2006 1:10 AM
0 Kudos

Moorthy,

Can you clrify my misunderstaning about BPM in my scenario.

<b>Assume that I have 2 BPMS in My SOlution:</b>

<u>OUTSIDE BPM</u>

1) FILE ASYNCHRONOUS SEND

2) JDBC-SYNC-SEND

3) SLECT 2 BPMS in receive agrrement for INVALID and VALID

<b>Within 1st(INVALID) BPM</b>

4) FILE ASYNC SEND

5) Control step for ALERT

<b>Within 2n BPM (For VALID)</b>

6) FILE ASYNC SEND

7) FILE ASYNC SEND

Will this work..

Thanks in Advance..

Ask a Question