Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    FileMaker SQL Info For The DBA

    Uploaded by

    Danny Dawson
    The document discusses FileMaker Pro 9's external SQL data source feature which allows live connections between FileMaker databases and Microsoft SQL Server, Oracle, and MySQL data sources. It outlines six things database administrators should know about the feature, including that FileMaker Pro users will need connection details, access is determined by the DBA, and FileMaker Server centralizes ODBC driver management.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    FileMaker SQL Info For The DBA

    Uploaded by

    Danny Dawson
    32 views2 pages
    The document discusses FileMaker Pro 9's external SQL data source feature which allows live connections between FileMaker databases and Microsoft SQL Server, Oracle, and MySQL data sources. It outlines six things database administrators should know about the feature, including that FileMaker Pro users will need connection details, access is determined by the DBA, and FileMaker Server centralizes ODBC driver management.

    Original Description:

    FileMaker SQL Info for the DBA

    Original Title

    FileMaker SQL Info for the DBA

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses FileMaker Pro 9's external SQL data source feature which allows live connections between FileMaker databases and Microsoft SQL Server, Oracle, and MySQL data sources. It outlines six things database administrators should know about the feature, including that FileMaker Pro users will need connection details, access is determined by the DBA, and FileMaker Server centralizes ODBC driver management.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    32 views2 pages

    FileMaker SQL Info For The DBA

    Uploaded by

    Danny Dawson
    The document discusses FileMaker Pro 9's external SQL data source feature which allows live connections between FileMaker databases and Microsoft SQL Server, Oracle, and MySQL data sources. It outlines six things database administrators should know about the feature, including that FileMaker Pro users will need connection details, access is determined by the DBA, and FileMaker Server centralizes ODBC driver management.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    FileMaker 9

    The External SQL Data Source Feature


    What the DBA should know

    The External SQL Data Source feature in FileMaker 9; What the DBA should know The External SQL Data Source feature in FileMaker 9 establishes a live connection between FileMaker Pro databases and Microsoft SQL Server, Oracle and MySQL data sources. FileMaker Pro users can self-serve some of their reporting needs and build complete solutions for their departmental or individual needs with this feature. Here are the top 6 things that the DBA should know. 1. FileMaker Pro user will need the: IP address or domain name of the SQL data source User name and password of the SQL data source 2. Access to the SQL data source is determined by the DBA Read/write or read only access Access to Tables or Views representing the data Database or database view 3. FileMaker Pro requires no extra proprietary tables so it imposes no extra management burden. 4. The External SQL Data Source feature cannot define or alter schema. FileMaker users do have the ability to execute SQL statements through the Execute SQL Script Step feature if the DBA grants privileges that allow this. 5. FileMaker Pro uses optimistic record locking; records are locked only as long as it takes to set up and commit a transaction. It does not hold record locks while users are modifying data. 6. FileMaker Server gives you the ability to centralize ODBC driver manage- ment for all users. The DBA can get a more technical understanding of this feature by downloading the External SQL Data Source Tech Brief (www.filemaker.com/downloads/pdf/public_ techbrief_ess_en.pdf), or by contacting a FileMaker systems engineer.

    You might also like