SQL Drilldown or Crawling web app?
-
We often need quick access to our sql data. Often we open SQL Analyzer to grab the data when we know exactly what we want. Other non-SQL users wade through the application housing the data. I just thought of creating a web application where users could "crawl" the data by choosing their database and table and being presented with the data. Then they could drill down in the data by clicking links that are based on the table's foreign keys. In a perfect world there would be many features such as * Having custom converters based on the data such as showing text values rather than foreign key ids that link to a lookup table, showing numbers in specified formats, displaying a picture rather than the path, etc. * Allowing security based on passed credentials or a user entered username/password. Passed credentials would allow access to the data the user has initial rights to. Manual user credentials would be useful for giving access to specific areas not available to the user or testing access to user accounts that applications use. * Searching * ??? Before I go and create something like this (which would be fun) does anyone know of something similar? An application with the source code available would be preferable but I'd be willing to take a look at closed commercial apps as well. Thanks! Matt Penner
-
We often need quick access to our sql data. Often we open SQL Analyzer to grab the data when we know exactly what we want. Other non-SQL users wade through the application housing the data. I just thought of creating a web application where users could "crawl" the data by choosing their database and table and being presented with the data. Then they could drill down in the data by clicking links that are based on the table's foreign keys. In a perfect world there would be many features such as * Having custom converters based on the data such as showing text values rather than foreign key ids that link to a lookup table, showing numbers in specified formats, displaying a picture rather than the path, etc. * Allowing security based on passed credentials or a user entered username/password. Passed credentials would allow access to the data the user has initial rights to. Manual user credentials would be useful for giving access to specific areas not available to the user or testing access to user accounts that applications use. * Searching * ??? Before I go and create something like this (which would be fun) does anyone know of something similar? An application with the source code available would be preferable but I'd be willing to take a look at closed commercial apps as well. Thanks! Matt Penner
MS Access.
-
MS Access.
Sorry, not quite sure what you mean by that reply. A little more specific? I'm not much of a fan of Access. I don't see how it would help me accomplish what I'm trying to do. Thanks.
-
Sorry, not quite sure what you mean by that reply. A little more specific? I'm not much of a fan of Access. I don't see how it would help me accomplish what I'm trying to do. Thanks.
MS Access can link to a SQL Server database and then your users can use the query builder to get to the data. Means that there's no direct link into sql server (if you connect with a read only user) and they will be using an interface that many of them are probably already used to.