Sorry, your question really doesn't make any sense..can you please rephrase this in a way that's understandable?
To start I'd check out scripted inputs. You can probably use some sort of hard-coded service account with a read-only password to your tables and execute a query from a command line in some short perl or BASH shell script (i.e. mysql). Splunk will basically index the anything from the stdout stream. That will at least get your data in the index so that you can perform query operations against it.
You've got several things to address with regard to this subject. The proper way to get sql data into splunk is via a scripted input. You'd set up a script to pull data from the database, and then have splunk eat that data. Information on that can be found here:
There are some sample scripts in splunk you can take a look at which are referenced in that document. Additionally, this may be useful to you:
With regard to setting up a dashboard, the first thing you need to do is ensure that the fields are being extracted in the manner you expect. You can do that via index time field extractions:
Once you have the fields extracted in the manner you desire, you'll need to develop a search with the data that you'd like to analyze over the dashboard. Once you have that search, you can finally move on to creating a dashboard.
What you are looking to do is completely feasible, though not a trivial task. Following the steps outlined above you should be able to achieve this goal.
Isn't DB Connect and Saved Searches replacing that? I already got saved sql searches (a query) to work at a specified time... now the question is how to set it as data input (specific columns of it, rows, etc or the whole data)