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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello,

 

I found this thread while trying to connet to vendor source as well.

In your case, would it make sense to create a dataflow within your premium space calling your vendors data. Your on premise source will use your on premise gateway, and the vendor data in your report will be called via the dataflow which uses the vendors gateway. Seeing as dataflow sources in a dataset do not need a connection setup directly it sounds like this may work for you.