Question
Virtusa International BV
NL
Last activity: 11 Apr 2016 5:41 EDT
Save Data to Different table in a Different Database
Hi,
I need to save data from our current schema to a different schema in a different data base through RDB methods.
Is there any way to write SQL to save data to that table.
Message was edited by: Lochan to add Category
Pegasystems
IN
You can use two different Rule-Connect-SQL instances, one to read from source and the other to write to target provided both source and target are mapped to different classes and thus have different Data-Admin-DB-Table instances.
That said, kindly elaborate on the use case for doing this. If you are looking for a way to extract the data out, have you considered BIX?
Virtusa International BV
NL
We can't go for bix.
Ill explain it by an example.
Schema : Schema1(Pega Default Schema) and Schema2
Tables: Customer1 and Customer2 (Customer1 in Schema1 and Customer2 in Schema2)
I need to retrieve data from Customer1 and save to Customer2
How it possible?
Following error will be displayed
