How to update SQL table using BRE directly?
I have a msg which has 3 elements ( Name,City,State) and i subscribe this msg to orchestration. Now i have a table in my SQL DB which has the same 3 columns. Now i want to use BRE by calingl a CALL RULE shape.
Which has to perform following Actions:
In my case ,
In Condition if my STATE= TRUE or FALSE I need to update my SQL table. This shd happen when ever i sent a new msg like if i have 10 msg i need to get 10 rows with 3 columns and so on........
I want to know whether it is possible, by using some Facts.
Note: I know i can update using storeprocedure and .net components in orchestration but i want to know if their are any possible ways to update SQL table directly in BRE withoout using Storeprocedures and .NetComponents.
CAN SOME GIUDE ME IF THERE IS A POSSIBLE WAY TO DO THIS.
Hi
if you are using an orchestration you can use a map, first you need to generate a schema out of the table and then use the map to transform the incomming schema to the table schema and you can insert directly to the DB using an SQL adapter with out writing a SP, i hope this will help you to achive.
Regards,
Murali