<p>Hi all, so I've looked at a couple examples demonstrating something like what I need, though not exactly, but they didn't really come with any useful explanation.</p>
<p> </p>
<p>Basically I'm trying to accomplish what you could easily do with a SQL JOIN, though the catch is that the tables I need to join exist on different servers, requiring me to use two data sources.</p>
<p> </p>
<p>The first data set, from the first data source, has a user_id column, among others. The second data set, from the second data source, has user_id and username columns. Basically, my report needs the results of the first data set, with the additional info of the usernames in the second data set.</p>
<p> </p>
<p>Simply using a joint data set between the two is not practical, as there are only a handful of records in the first data set, yet hundreds of thousands of records in the second data set (don't ask). I need a way of only retrieving the usernames of the user_ids that exist in the first data set from the database to make my report fast.</p>
<p> </p>
<p>Any ideas?</p>
