Solved

Recommend Database Client for Multiple Data Sources

Posted on 2016-08-16
13
38 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
13 Comments
 
LVL 65

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 65

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
 
LVL 42

Expert Comment

by:zephyr_hex
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 42

Expert Comment

by:zephyr_hex
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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 42

Expert Comment

by:zephyr_hex
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 42

Expert Comment

by:zephyr_hex
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now