Ask the Expert

User interface options when linking or moving to Oracle

I have a customer interested in the Oracle Standard One 10g. They are a small company (50 employees) who hope to grow, but they use Filemaker Pro almost exclusively (they think MS Access is too difficult to learn). What would you recommend as a user interface (some queries, some update forms, no Web) if they did move to Oracle? Or should they keep their Filemaker stuff and link it to Oracle via ODBC?

    Requires Free Membership to View

You can link virtually any platform to Oracle via ODBC. Depending on their FileMaker application, a link of tables in Oracle through ODBC may work great. But in some cases, it doesn't work so well. Use the latest ODBC drivers from Oracle and hopefully it will all work well for you.

But I would prefer a more centralized application platform. And this typically means Web or application servers between the client and the database. A central point of administration can make this a very attractive option. But it may be hard to re-engineer an existing solution.

This was first published in February 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: