<div>
&gt;Does anyone know if there is a text-based client that can do this?<br />
Define 'text-based', as afaik all reporting applications will use ODBC connections to multiple other data sources, <br />
<br />
&gt;have no administrative rights on the database servers.<br />
Can't consume what you can't connect to, so either (1) you'll have to have the DBA on those servers give you limited privs so you can access it, or (2) somebody needs to build an ETL feed of data on those servers into a format that you can consume.
</div>


<div>
What I mean is something like dbVisualizer, Management Studio query editor, or any other textual query client.<br />
<br />
I can connect and query data from the servers. &nbsp;I already consume data from them. &nbsp;I cannot make changes to the servers.
</div>


<div>
Okay, I see what you mean, a combination of a reporting application and a querying tool with custom T-SQL editing against multiple data sources such as <a href="https://www.dbvis.com/" rel="ugc">DbVisualizer</a>. &nbsp;<br />
<br />
SSRS has the ability to connect to a data source and enter custom T-SQL, but it won't parse it. &nbsp;<br />
<br />
I'm not familiar with other reporting apps, so I'll step back to encourage other experts to respond.
</div>


<div>
I've worked in Tableau and I've never seen anything like that editor where you can access multiple data sources. &nbsp;It's definitely unique and well thought-out.<br />
<br />
And I'd be surprised if you can find anything that mimics that ability. &nbsp;It's part of what makes Tableau such a great graphic software.
</div>


<div>
I love Tableau for that ability, but it is a very slow tool when performing a quick query between two data sources. &nbsp;If I want visualization, that is fine. &nbsp;But, if I just want a report of a list of users that touched a particular item and need their phone number or email address (in a different database), then I would like to be able to do that in a text-based query editor.
</div>


<div>
A different database in the same SQL instance is possible without a linked server, using SSMS. &nbsp;Just qualify the database in your query, like so:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41758279-1"><span>SELECT t1.Field1, t2.Field2</span>
<span>FROM Database1.dbo.Table1 t1</span>
<span>INNER JOIN Database2.dbo.Table2 t2 ON t2.ID = t1.ID</span>
</code></pre>
<br />
However, if your tables are not in the same SQL instance, I believe you are out of luck. &nbsp;As I said previously, I've never seen an editor that does what Tableau query editor does. &nbsp;That's why people go through the trouble to set up Linked Servers.
</div>


<div>
I am trying to find a CLIENT-SIDE application that will do this. &nbsp;I have no access to the SQL Servers other than &quot;VIEW&quot; permissions.
</div>


<div>
Well, that IS a client side solution. &nbsp;SSMS is a client tool, and if you're dealing with databases that are in the same SQL instance, you can query them using that approach. &nbsp;I'm not sure what you mean by &quot;VIEW&quot; permissions. &nbsp;I'm assuming you mean permission to read the data, which would allow you to SELECT.<br />
<br />
If you are looking for that tool that's in Tableau, I'm almost certain it's proprietary to Tableau, which means you aren't going to find it somewhere else.
</div>


<div>
I'm going to object. &nbsp;Just because the answer is No doesn't mean it's not useful or the right answer.
</div>


<div>
SSRS is not an option, as I clearly stated in the original question:<br />
<br />

<blockquote>
For example, I can grab data from MSSQL, MySQL, DB2, Excel, and a CSV file and tie them all together.
</blockquote>
<br />
I was hoping for some digging to find such a tool. &nbsp;I have been searching, but have not found a tool such as the one that I am describing. &nbsp;However, that does not mean that it does not exist. &nbsp;It just means that nobody in this thread has located it. &nbsp;This question will not be useful to anyone else and therefore should be deleted.
</div>


<div>
No other solutions provided were helpful. &nbsp;This software does what I need (although a less expensive alternative would have been appreciated).
</div>


<div>
<div class="content wysiwyg-content">
I am looking for a database client that can access data from multiple sources. &nbsp;We use Tableau (<a href="http://www.tableau.com" rel="ugc">http://www.tableau.com</a>) for data visualization and it is able to use many different data sources at the same time. &nbsp;For example, I can grab data from MSSQL, MySQL, DB2, Excel, and a CSV file and tie them all together.<br />
<br />
Basically, it queries the multiple data sources, builds a local table with the data, and then blends the data sources locally.<br />
<br />
Does anyone know if there is a text-based client that can do this? &nbsp;I cannot used linked sources and have no administrative rights on the database servers.
</div>
</div>


I am looking for a database client that can access data from multiple sources.  We use Tableau (http://www.tableau.com (http://www.tableau.com)) for data visualization and it is able to use many different data sources at the same time.  For example, I can grab data from MSSQL, MySQL, DB2, Excel, and a CSV file and tie them all together.

Basically, it queries the multiple data sources, builds a local table with the data, and then blends the data sources locally.

Does anyone know if there is a text-based client that can do this?  I cannot used linked sources and have no administrative rights on the database servers.

Recommend Database Client for Multiple Data Sources

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.