5 Replies Latest reply on Nov 6, 2014 8:09 AM by Mike_Mitchell

    evaluate FileMaker

    douglas168

      Hi,

       

      We have a web develop company using Java to develop our web application for internal use only. Right now, the quality of their work is low to say the least. We are exploring the possibly of doing it internally and along with outside consultants using Access or FileMaker. We do have experience with Access with our staff but we like to learn more about FileMaker as another option.

       

      Right now, our requirements are

       

      1- web based (run inside a browser)

      2- multiple user can logon to access to use

      3- about to encrypt or hide certain column within database base on user's permission

      4- able to access MySQL

      5- using SSO service to logon

       

      These are just the few. I am wondering FileMaker experts can share their thoughts about FileMaker and perhaps point me to information as to FileMaker comparison with other DB applications.

       

      thanks in advance,

      Douglas

        • 1. Re: evaluate FileMaker
          Malcolm

          1- web based (run inside a browser)

           

          FileMaker offers WebDirect as a way to deliver FileMaker databases via

          the web without requiring any web programming. This is a resource

          intensive solution and the number of simultaneous connections has

          relatively low limits. In essence, you are throwing computing power at

          the problem, instead of programming power.

           

          Custom Web Publishing with either XML or PHP is an alternative. In this

          case the database is used as a back-end storage medium. The web

          programmer provides the front-end. The number of connections is high and

          the server load is light.

           

          2- multiple user can logon to access to use

           

          Yes, it's a multi-user solution.

           

          3- about to encrypt or hide certain column within database base on

          user's permission

           

          User access privileges may be very finely grained. You can control

          access to fields (columns) based on permissions.

           

          4- able to access MySQL

           

          FileMaker can access External SQL Sources (ESS) and you can include

          those tables in your FileMaker solution. You may need third party

          drivers for mySQL connections.

           

          5- using SSO service to logon

           

          FileMaker Pro client allows SSO using AD and OD authentication, however,

          the web interfaces don't have that advantage.

           

          Malcolm

          • 2. Re: evaluate FileMaker
            Mike_Mitchell

            Slight correction:

             

            "FileMaker Pro client allows SSO using AD and OD authentication, however, the web interfaces don't have that advantage."

             

            It is possible to use LDAP authentication through PHP to tap AD / OD using Custom Web Publishing. WebDirect doesn't offer SSO.

             

            FileMaker-backed web sites can meet all your requirements. My question would be, though, if you're going to go to the trouble of building a CWP site using a FileMaker back end and tap a MySQL database, what are you gaining? Why not just use a PHP / MySQL web site directly?

            • 3. Re: evaluate FileMaker
              wimdecorte

              Malcolm wrote:

               

               

               

              5- using SSO service to logon

               

              FileMaker Pro client allows SSO using AD and OD authentication

               

              Correction:  SSO is only possible in an all-windows AD setup, it does not work with OD.   External Authentication (EA) itself is possible against AD, OD or local accounts on the FMS machine.  But SSO is special-case EA scenario that only works in this scenario:

              - user logs into a domain machine - running windows - with an AD account

              - FMS runs Windows and is member server of that AD domain

              - the user's AD group membership matches one of the externally authenticated accounts set up in FM

               

              On Mac you can sort of mimic SSO by using the keychain to store the credentials but that is not true SSO

              • 4. Re: evaluate FileMaker
                ibrahim_bittar

                Or use the complete FileMaker platform?

                • 5. Re: evaluate FileMaker
                  Mike_Mitchell

                  Even better.