cancel
Showing results for 
Search instead for 
Did you mean: 

different database instance

sahana_ps
Participant
0 Kudos

Hi all,

I have a requirement ,where i need to read data and write data to some tables of database PSMTEST and this is working fine.

Now this tables are also present in 2nd instance but they do not have PSMTEST environment.i need to update this tables also.

so,what needs to be done for setting up the queries for 2nd instance?

Accepted Solutions (0)

Answers (2)

Answers (2)

iaki_vila
Active Contributor
0 Kudos

Hi Sahana,

I don't understand well your requeriments you could clarify a bit the problem.

I suppose that you are using a JDBC sender and/or JDBC receiver.

Which version PI are you using? Database version?. When you says that those tables are not in database PSMTEST, which kind of connectivity do you have? via JDBC? are in SAP ECC?.

Regards.

Former Member
0 Kudos

Dear Sahana

You would have to create 2 scenarios in PI. One which writes data to one DB and other to another.

Regards

Monika

iaki_vila
Active Contributor
0 Kudos

Hi,

You could follow the Monika advice. If you want to update the two databases at the same time you could put multiple receivers in Receiver determination, using the same Interface determination for both and finally to have two differents receiver agreement.

Regards.