Mobile Database Access

[SuburbanFarmer]

Just go to a major vendor like Microsoft or Oracle. They have off the shelf products for a database with mobile device clients for secure access.

That's what I thought too. They simply aren't there yet.

3-4 phone manufacturers using different OS's, that aren't compatible with much of anything.

Yeah, I am not sure about OS variance, but you can probably hit Android pretty easily.

What about this?

http://www.impathic.com/access/

That does look really sweet, but I need to be able to filter access to their Supervisors - not full access to everything. I'm not sure if that app can do it... Researching.

[Speaker to Animals]

That's what I thought too. They simply aren't there yet.

3-4 phone manufacturers using different OS's, that aren't compatible with much of anything.

Yeah, I am not sure about OS variance, but you can probably hit Android pretty easily.

What about this?

http://www.impathic.com/access/

That does look really sweet, but I need to be able to filter access to their Supervisors - not full access to everything. I'm not sure if that app can do it... Researching.

Looks limited to iOS, though.

[SuburbanFarmer]

Dude - just set up an SQL server in AWS or Azure, Java or ASP.net (preferred IMHO) web interface....then just write a short script to import the data from the spread sheet to the database...

make the Web Interface accessible via VPN only and HTTPS.

That was my original idea, but they're not interested in spending the $$$ for a server and software - I came up with around 2k total. Then there's still the matter of building a front-end for it...

[Speaker to Animals]

What if you just had a chron script that copied only the records and fields from the database you want to be displayed into a mirror access database that the clients all connect to?

If all the mobile clients are doing is reading the data, then you just protected the original records anyway.