Forum Discussion

fvicente's avatar
fvicente
Frequent Visitor
6 years ago
Solved

Connect datasets to 2 gateways

Hi,   I have a report that I've connected to a SQL Server database and an Oracle database.  I need to combine data from both databases on the report.  The SQL Server database is on-prem and the Ora...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi fvicente ,

    If your dataset contains multiple data sources, each data source must be added in the same gateway.

    You can refer to this document.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Icey's avatar
Icey
Community Support
6 years ago

Hi fvicente ,

If your dataset contains multiple data sources, each data source must be added in the same gateway.

You can refer to this document.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

fvicente's avatar
fvicente
Frequent Visitor
6 years ago

Hi Icey 

 

Thanks for the clarification.  I was hoping that that wasn't the case but everything I've run into with troubleshooting and testing seems to prove this to be true.  Thanks for the replies from both you and venal 

 

FVicente