Bulk Insert in JDE bssv

[karthik9891]

Hello All,

Anyone knows how to bulk insert records to jde tables using business service. I see only basic operations select,insert,update, delete available as a apart of JDeveloper wizard which allows to do stuffs one at a time .

Any thoughts or insights on this?


Thanks,
Karthik

 

[johndanter]

Call a BSFN to do it.
Or find out how to loop and generate the unique key in java

 

[ONYX]

Hello karthik9891,
It sound like it is an ETL task rather than a web-service oriented task.
You might (I'd say you will definitely) hit certain limits while trying to insert substantial number of record into a table.

Is bssv the only choice for this task?

If bssv must be just a trigger to initiate an action in JDE you could break task in two sub tasks:
Insert records in db with proper ETL tool (lets say Microsoft Server Integration Services or similar with a unique id, and then call bssv passing unique id to it so it processes only necessary records).

 

[karthik9891]

Hello ONYX ,

Thanks for your inputs. It makes more sense to go with an ETL process if the bulk inserts are going to be frequent. But in my case, the bulk inserts are not going to happen frequently (3 months once) ...and will be having 5-15 batches each batch with 50 records. I was under the impression that a bssv would suffice for this. I don't explicitly see api's in bssv package to insert records in batches (it passes one record at a time and not all). I'm not sure how will I do this batch process in a BSFN since the data structure can have only one value/field. Just curious to know if I'm missing something on this.

Thanks

 

[ONYX]

Hello ONYX ,

Thanks for your inputs. It makes more sense to go with an ETL process if the bulk inserts are going to be frequent. But in my case, the bulk inserts are not going to happen frequently (3 months once) ...and will be having 5-15 batches each batch with 50 records. I was under the impression that a bssv would suffice for this. I don't explicitly see api's in bssv package to insert records in batches (it passes one record at a time and not all). I'm not sure how will I do this batch process in a BSFN since the data structure can have only one value/field. Just curious to know if I'm missing something on this.

Thanks

Hello karthik9891,
BSSV server will definitely survive while processing 50 records.
You can easily define an array (in general whatever structure you want) as inbound payload for a bssv (web-service).

Please have a look at standard bssv JP43A000 - PurchaseOrderReceiptManager.
It accepts a collection/array of purchase order lines to receive.
You can accommodate same approach for your ~50 records to insert into database.

 

[alfredorz]

Hi karthik9891,

You should create a input class with a array attribute of other class. Finally, you should loop the array and insert by method. For 50 or 100 records you shouldn't any problem.

Regards.

 

[karthik9891]

Okay..just wondering if inserting one by one would be a costly operation..

 

[alfredorz]

Hi karkthik9891,

I think shouldn't be costly operation, the same cost if you insert the same rows in a batch or application.

Regards.

 

[Chan Rana]

Either you use BSSV, UBE or app all has to do insert for each record. If there is no validation required then you can just use straight Insert in BSSV to have them in table.

Chan