Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Merging tables from two different data sources

  Hello   I am experiencing a very interesting problem which I'm struggling to resolve and hope you can help.   I have 2 tables from 2 different data source. First table is located on ...
Tips and Tricks
  • edhans's avatar
    edhans
    7 years ago

    Is your enterprise gateway set to refresh cloud data? Also, make sure your on prem SQL table is navigating directly to the table. Don't have a source query that is a list of all SQL tables, then your table is actually a reference to the SQL table list, then a navigation to that specific table.

     

    You don't need a personal gateway. Ignore that warning. I don't know why that is in the refresh setting. It is irritating and makes you think you have a need for a personal gateway even when an enterprise gateway is properly set up.

edhans's avatar
edhans
Community Champion
7 years ago

Is your enterprise gateway set to refresh cloud data? Also, make sure your on prem SQL table is navigating directly to the table. Don't have a source query that is a list of all SQL tables, then your table is actually a reference to the SQL table list, then a navigation to that specific table.

 

You don't need a personal gateway. Ignore that warning. I don't know why that is in the refresh setting. It is irritating and makes you think you have a need for a personal gateway even when an enterprise gateway is properly set up.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thank you edhans  adding the gateway setting has worked.