ORACLE vs. FileMaker

[JohnnyZ]

The company I work for has spent the last year and over $2 million on an ineffective ORACLE impementation. My interest with FileMaker prompted me to create some solutions to demonstrate 1)the capabilities of FileMaker and 2)how FileMaker allows the final users to participate in the database design process. The demonstration was successful. I now need to make a proposal to the company executives selling a FileMaker solution to compensate for the ORACLE shortcomings. This solution will have to interface with ORACLE, nevertheless. Please give me any information that will help sell the effectiveness and validity of FileMker solutions! TIA

[SteveB]

Check the Filemaker web site...they have a long list of corporate clients using FM.

Steve

[kenneth2k1]

Wow. Oracle is pretty good. If its implementation was not successful, I would want my 2 milli back. Was it developed in-house?

The filemaker site also has some comparisons with other DBMS. But they seem to like picking on Access (easy target. But hey, that's Apple)

[Anatoli]

RE: Wow. Oracle is pretty good. If its implementation was not successful, I would want my 2 milli back. Was it developed in-house?

Absolutely!

RE: The filemaker site also has some comparisons with other DBMS. But they seem to like picking on Access (easy target. But hey, that's Apple)

The two -- FM and Access are close. To compare FM and Oracle is a bit out of question. Still comparing just on the price...

[CobaltSky]

Hi Johnny,

FileMaker has good import and export capabilities and also some SQL compliance. However in order to more fully integrate it with the enterprise level rdbms, you might wish to look at some of the third party tools that offer extended SQL data transfer implementations.

One such is the PDM plug-in:

http://www.profdata.nl/pdm/generic.jsp?taxonomy_id=5

which is widely used and is available as a cross-platform tool for integrating FileMaker with ODBC compliant databases - of which Oracle is one.

If you get into the rhythm of using FileMaker with a fast data transfer tool, you will find that it can become a versatile front end and reporting tool for the larger system.

[JohnnyZ]

Thanks, Ray.I'll try that plugin. Are there any specific examples of FileMaker and ORACLE interacting?

[Leb i Sol]

Hey Johnny!

Quick side notes:

user deifined access over ODBC is pretty Good into ORACLE...I have barelly touched on it and used it with some ASP pages!

perhaps this link will lead to some more insides:

http://www.orafaq.com/faqodbc.htm

Good Luck!

[JohnnyZ]

Another great tip! Thanks.

[Leb i Sol]

also, if you like XML consider FM XML~ODBC ways

here is a quick link to pretty good XML tool

http://www.altova.com/features_convert.html

and if you really want to examine your ODBC performance and grab some pre-production statistics:

http://www.networkcomputing.com/605/605work1.html

it is a big topic...I hope you find your ways to best solution!

Take care!

[JohnnyZ]

Wow. Thanks again. XML-Spy looks promising.