[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


What's the quickest and easiest method of creating a mobile app and connecting it to an Oracle database using Delphi XE

Posted on 2014-04-04
Medium Priority
Last Modified: 2014-04-08
I have been using Delphi since version 1 but am new to XE5 and all of the mobile tools.  I need to create a very simple app for an Ipad that will connect to an Oracle server over the web and feed up information.  I'm reading about Intraweb, Rest, Firedac, datasnap etc and it's all a little confusing and I'm on a time limit.  I'm looking for someone that is very versed in doing this type of thing that can get me there fast because I've only have a few days.

I'm including Oracle in this search because I know that there are built in products to expose data to the web there as well.
Question by:Randy Rich
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 28

Expert Comment

by:Sinisa Vuk
ID: 39977741
Just quick pick (I'm really don't use it for now) - blog about connecting to remote database:
..using devart's ODAC direct access component.

Author Comment

by:Randy Rich
ID: 39977761
What's the pitfalls to ODAC?  Obviously you would be limited by bandwidth, but is it efficient?
LVL 28

Expert Comment

by:Sinisa Vuk
ID: 39977822
I can suggest just to try trial version. In win platform is quite efficient.
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 39978164
You really never want an Internet app that can connect directly to any database.  That is a pretty big security hole.

You typically have a web service or some piece of middleware in the DMZ and the database server well behind the DMZ.

The front end app can talk to the web service and the web service can talk to the database.

Author Comment

by:Randy Rich
ID: 39978173
So in Delphi XE5 which components would be the best for talking to a web service?
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39979240
I'm not a Delphi person so I'm left to Google.

Look for:  Delphi XE consume web service.

LVL 38

Expert Comment

by:Geert Gruwez
ID: 39982342
the easiest way is to create a static webpages with a delphi exe
you connect to the db as usual and save the files via ftp to the website

it all depends on what your app has to do

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

656 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