?
Solved

Recommend Database Client for Multiple Data Sources

Posted on 2016-08-16
13
Medium Priority
?
70 Views
Last Modified: 2016-09-04
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.
0
Comment
Question by:Brian Pringle
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 2
13 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 41757927
>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
 
LVL 16

Author Comment

by:Brian Pringle
ID: 41757931
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
 
LVL 66

Expert Comment

by:Jim Horn
ID: 41757947
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41758065
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
 
LVL 16

Author Comment

by:Brian Pringle
ID: 41758103
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
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41758279
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
 
LVL 16

Author Comment

by:Brian Pringle
ID: 41765552
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
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41765593
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
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41765661
I'm going to object.  Just because the answer is No doesn't mean it's not useful or the right answer.
0
 
LVL 16

Author Comment

by:Brian Pringle
ID: 41765706
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
 
LVL 16

Accepted Solution

by:
Brian Pringle earned 0 total points
ID: 41777044
I think that I found a tool that will do this...

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

Author Closing Comment

by:Brian Pringle
ID: 41783524
No other solutions provided were helpful.  This software does what I need (although a less expensive alternative would have been appreciated).
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question