Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Recommend Database Client for Multiple Data Sources

Posted on 2016-08-16
13
Medium Priority
?
83 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
  • 6
  • 4
  • 2
12 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In this tutorial, we’re going to learn how to convert Youtube to mp3 for Free. We'll show you how easy it is to make an mp3 from your video clips so that you can enjoy them offline.
In today’s time where quality is an essential factor all over the world, software testing and effective QA (Quality Assurance) is an all-important element for any business to ensure less risk for an end product. A good software testing company deliv…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

571 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