Hello

I am using Oracle Dataguard and I wonder if I can import data from Talend into my tables.

My connection string is like that :

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521 ))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(LOAD_BALANCE=false)(FAILOVER=true))(CONNECT_DATA=(SERVICE_NAME=)(SERVER=DEDICATED)))

one server is the primary and the other one is juste a mirror. I don't know which one is the primary. It can change at any time. If the primary fails the other one become the primary.

I tried to give that connection string to Talend in an Oracle with service name connection but, when I want to add "ADDRESS_LIST", Talend turn to Oracle with SID and I lose my string.

Does someone try to use Oracle Dataguard with Talend? Is it possible?

Thanks for your help