Thanks for your post, it looks very useful and it is very well described! :)
I have a question about database connections. In many cases the login password can change (security reasons, developer and customer can use different login, etc..). If we create many database connector datafeed, then the password change can be very difficult, and needs to know, how exactly datafeeds work. It cannot be a task for customers IT administrator.
Is it possible to give authetication paramteres (user name, password) only once, on the administration/database connections form?
I think it should work, user id and password can be contained by the connection string.
I tried it, Mashzone accepted my connstring, no error appeared, but the authentication was still neccessary, in a popup :(
Thanks in advance,
as you already indicated there are two ways to store credentials for DB access:
- As part of the JDBC-URL - the password will be visible (and possibly transferred) in plaintext, every data feed reuses that credential.
- As part of the data feed - password is not visible and each feed might specify a different credential
If you invoke Test database connection option within the administrative interface a user name password prompt comes up. If you already entered credentials in the URL you may leave it blank to verify your settings.
is it possible to achieve the same feature using a date range as an input rather a particular field being common in two tables.
A simple query where the data is fetched based on the date range eg: 2012-04-05 12:12:12 to 2012-04-05 13:13:00
Users are more interested to know if they can fetch information on date ranges from a single table
eg: select count (*) from table where date_range >='2012-04-05 12:12:12' and date_range<='2012-04-05 13:13:00'
where the date range comes as a user input..
can you please share a sample on the date range stuff as an input query.
I have tried the way you had asked me for using the user input fields as Date and then converting to the date pattern to feed the query.
I assume there should be a way to pass the values i used in user input in the data feed.from the mashapp.
However i have not been able to create the front end mash app to pass the values to the data feed dynamically.
your inputs on it will be really useful.
That's similar to filtering of values. Assuming there is a data feed having a user input operator:
A very basic MashApp to utilize this feed could look like this:
There is a text field to enter values and a label to print the result. Lets connect the feed to the result label.
As the data feed being used contains a variable we see it below the list of columns. Now we need to bind the variable to a UI widget, i.e. the form field. Its done using a gesture which is comparable to filtering.
As there is a variable to compare with MashZone enables us to choose between filtering or user inputs. The second option has already been selected. Accept and run the MashApp.
Great post, let me try your solution!!!
Hello Mr Stephan Freudl,
I've a question ¿how can i work if my DB have more than 10.000 row?. I'm think in SAP DB with more than 300.000 row. So, is posibile to create a correct KPI with out consider all data?.