Solved

Recommend Database Client for Multiple Data Sources

Posted on 2016-08-16
13
50 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 42

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 42

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 42

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 42

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

777 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