Recommend Database Client for Multiple Data Sources

I am looking for a database client that can access data from multiple sources.  We use Tableau (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.
LVL 16
Brian PringleSystems Analyst II, SCM, ERPAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Does anyone know if there is a text-based client that can do this?
Define 'text-based', as afaik all reporting applications will use ODBC connections to multiple other data sources,

>have no administrative rights on the database servers.
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.
0
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
What I mean is something like dbVisualizer, Management Studio query editor, or any other textual query client.

I can connect and query data from the servers.  I already consume data from them.  I cannot make changes to the servers.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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 DbVisualizer.  

SSRS has the ability to connect to a data source and enter custom T-SQL, but it won't parse it.  

I'm not familiar with other reporting apps, so I'll step back to encourage other experts to respond.
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

zephyr_hex (Megan)DeveloperCommented:
I've worked in Tableau and I've never seen anything like that editor where you can access multiple data sources.  It's definitely unique and well thought-out.

And I'd be surprised if you can find anything that mimics that ability.  It's part of what makes Tableau such a great graphic software.
0
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
I love Tableau for that ability, but it is a very slow tool when performing a quick query between two data sources.  If I want visualization, that is fine.  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.
0
zephyr_hex (Megan)DeveloperCommented:
A different database in the same SQL instance is possible without a linked server, using SSMS.  Just qualify the database in your query, like so:

SELECT t1.Field1, t2.Field2
FROM Database1.dbo.Table1 t1
INNER JOIN Database2.dbo.Table2 t2 ON t2.ID = t1.ID

Open in new window


However, if your tables are not in the same SQL instance, I believe you are out of luck.  As I said previously, I've never seen an editor that does what Tableau query editor does.  That's why people go through the trouble to set up Linked Servers.
0
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
I am trying to find a CLIENT-SIDE application that will do this.  I have no access to the SQL Servers other than "VIEW" permissions.
0
zephyr_hex (Megan)DeveloperCommented:
Well, that IS a client side solution.  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.  I'm not sure what you mean by "VIEW" permissions.  I'm assuming you mean permission to read the data, which would allow you to SELECT.

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.
0
zephyr_hex (Megan)DeveloperCommented:
I'm going to object.  Just because the answer is No doesn't mean it's not useful or the right answer.
0
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
SSRS is not an option, as I clearly stated in the original question:

For example, I can grab data from MSSQL, MySQL, DB2, Excel, and a CSV file and tie them all together.

I was hoping for some digging to find such a tool.  I have been searching, but have not found a tool such as the one that I am describing.  However, that does not mean that it does not exist.  It just means that nobody in this thread has located it.  This question will not be useful to anyone else and therefore should be deleted.
0
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
I think that I found a tool that will do this...

http://arbutussoftware.com/products-solutions/analyzer/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
No other solutions provided were helpful.  This software does what I need (although a less expensive alternative would have been appreciated).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.