Apps for Android developped with Delphi XE7

I plan developping small apps for Android platform using Delphi XE7.
The apps should access a Microsoft SQL database located on a MS server.
Are there suitable SQL component to do this ?
Is there some documentation somewhere ?
LVL 1
LeTayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sinisa VukCommented:
Use FireDac componets which comes in older versions too. FireDac can connect to wide range of databases.
Here is great article how: android-database-application-development-in-rad-studio
More on firedac
0
LeTayAuthor Commented:
Thanks for the link.
Unfortunately, it points to an article concerning XE5, not XE7, and does not seem to say something about accessing MS/SQL !?
0
LeTayAuthor Commented:
I found link to XE7
Seems that that version of FireDAC is ok for SQL Server
But it seems that this is an additional cost ...
Also, the apps if for all customers (potential anybody) so I wonder if such developped apps is suitable for this purpose (security etc...)
Is a Client/Server  schema with HTML and a Web Server not better ?
Is this included in some Delphi XE7 version (studio ? enterprise ? etc;..)
Thanks
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Sinisa VukCommented:
what cost you talking about? FireDAC comes with XE7. Works quite good. Is it server local?. You need security over internet?

another option is to use REST with web based services:
REST_Client_Library
Using_the_REST_Client_Library_to_Access_REST-based_Web_Services
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
controlrCommented:
i found that devArt's SDAC provided better overall performance and cross platform consideration.
we have thoroughly ltested both FD and SDAC, SDAC teh hands-down winner is SDAC!

SDAC provides more robust features if you plan on large scale implementations with failover, etc.
We have migrated over 20 apps to the SDAC, and not going back to the Delphi data components.

Looking atthe price diff from using Delphi Pro + SDAC for msSsql, its a better buy and less risk - as SDAC always keeps current of SQL versions and  specific tweeks (2014 memory tables, change notifications, etc). which is not something I would build -on with fireDac.  


A note on Datasnap: We have tested the approach of using Datasnap and doing server/SQL calls. there are serious issues with dataSnap when it comes to data over 16K. so keep that in mind. this issue has been in dataSnap since its release, and has yet to be resolved (not anticipating a resolve anytime soon)

hope this helps
0
LeTayAuthor Commented:
Not a very large site, in fact
0
controlrCommented:
if performance  / result size if not a factor then go for convenience in writing the code.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.