Custom Queries to SQL database - user friendly

Posted on 2013-09-22
Medium Priority
Last Modified: 2013-09-24
I would like to use an app on the Iphone for our organization users that will allow them to access Queries to our SQL server.

Basically, some of our depts need to have an app that will pull up pre-arranged queries in a nice report that they can see current records.

Is there an app that exists that will do everything above and user friendly?
Question by:al4629740
LVL 10

Accepted Solution

Banthor earned 1000 total points
ID: 39513327
Build a standard Web app with a mobile formatted interface.
Then you can manage the access and the business rules in stored procedures and use any device that supports html as a client.
I create a dozen off these a year for independent clients

Author Comment

ID: 39513331
do you have an example?
LVL 20

Assisted Solution

darbid73 earned 1000 total points
ID: 39514188
This is a pretty common question.

For links for examples on writing this yourself. See the links in this post.

See my answer here too if you are looking for more on building your own app.

If you are looking for something already done;
See this app in iTunes.  I have used the MSAccess version and thought it was ok.  Note there is also a similar question here in the last week or 2 about iphone apps and sql server but I could not find it.  I believe this app was also recommended.

I also did a quick search on iTunes and found this app as well.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

600 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