using BCS to point to external database
create two Secure Store Application ids , one with production credentails and another with staging credentails
I have several external content types (ECT) using an external system(ES) pointing to staging databases.
Now i want to change only one of my ECT to point to production DB but suprisingly the only way i could achieve this was by modifying the ES that all the other ECT are using, this is not practicaly because this makes all the ECTs point to production and not
just the one that i want.
Question is how can i have different ES and how can i make only one ECT out of all the ones to point to production, i tried using the "Switch connected systems" but did not like it and below are the details:
Created a new ECT pointing to production which would show the ES being used in BCD services and then i used the "Switch Connected Ssytems" option under designer to switch the staging ECT to the production ES. Dos the job but the problem is that if
there are no ECT pointing to staging ES then it does not appear under BCS services which mean neither can i switch my ECT back to it nor would it be available when i am creating new ECT whch need to point to staging.
Hope i was clear, please suggest how to handle this sit
View Complete Post