I’m not sure what that means. I have a connection to MS SQL database, and one to an Oracle database set up in TDP. I can run individually against either one. But when I try to build a cross query, something about the format of the connections isn’t working. This is the SQL that is generated.
FROM sqlprodidpb\batch (my login ID).ODS.ConsRptg.T_STAGE_CONSRPTG_TRADE_UDF T_STAGE_CONSRPTG_TRADE_UDF
We would be happy to help you with this issue. can you open a support case? We need to ask several questions as well as get some log files in order to debug this. Support knows how to help you get this info for us. You will need to turn on logging, reproduce the error and send us the supportbundle.