1 Reply Latest reply on Apr 18, 2016 4:59 PM by patrick.byrne.0

    Wants to have data from Oracle and SQL Searver on one sheet

    p g

      Hi,

       

      I have 2 tables on oracle and 1 on sql server.

       

      I need to write a custom query at sql , which need the 2 tables from oracle so that I can use join on all three tables together.

       

      I have connected to all three data and also used data relationships between all 3 data sources.

       

      but when I try to write custom query it simply not allows me to access another data source.

       

      and if I directly go to sheet and start plotting for data. it gives me all data where as the out should be 10 to 20 data rows after the relationship

       

      Does ay one have faced such issue ?

       

      Thanks