Introduction to External SQL Sources 外部 SQL ソース入門
3 ESS 3 ESS : 4 ESS : 4 5 ESS 5 Step 1:... 6 Step 2: DSN... 6 Step 3: FileMaker Pro... 6 Step 4: FileMaker Pro 1. 6 Step 5:... 6 Step 6: FileMaker Pro... 7 7 DSN 8 Mac OS X DSN... 8 Windows DSN... 12 FileMaker Pro 14 17 19 19 ESS FileMaker Pro 22... 22?... 23... 23... 24 ESS vs. FileMaker Pro SQL 24 ESS 26 SQL... 26... 27... 27... 27... 27 28... 28 FileMaker TechNet... 28 ESS... 28 ODBC... 29... 29 29 2
FileMaker Pro FileMaker Pro 9 FileMaker Pro 10 ESS ESS ESS ESS FileMaker Technical Network (TechNet) ESS Introduction to External SQL Sources URL http://www.filemaker.com/downloads/documentation/techbrief_intro_ess.pdf ESS FileMaker Pro ODBC Execute SQL SQL SQL ODBC SQL Execute SQL ODBC FileMaker Pro 10 ESS FileMaker Pro ESS FileMaker Pro ESS FileMaker Pro ESS ESS FileMaker Server ESS DSN ESS FileMaker Pro ESS 3
ESS : ESS ESS SQL E SQL FileMaker Pro Oracle FileMaker Pro ESS FileMaker Pro IT MySQL E Web FileMaker Pro ESS MySQL FileMaker Pro FileMaker Pro MySQL Microsoft SQL Server FileMaker Pro Oracle ESS o o FileMaker Pro FileMaker Pro ESS FileMaker Pro ESS : ESS ESS FileMaker Pro SQL ESS FileMaker Pro ESS SQL ESS FileMaker Pro Execute SQL ESS FileMaker Pro FileMaker Pro ESS ESS FileMaker Pro FileMaker Pro ESS SQL 4
SQL FileMaker Pro FileMaker Pro ESS FileMaker Pro 10 Oracle 9i Oracle 10g Oracle 11g* MS SQL Server 2000 MS SQL Server 2005 MS SQL Server 2008* MySQL 5.0 Community Edition MySQL 5.1 Community Edition* * FileMaker Pro 10 ESS ODBC FileMaker, Inc. ODBC ODBC ODBC FileMaker Web http://www.filemaker.co.jp/support/technologies/sql.html ESS ESS FileMaker Pro FileMaker Pro FileMaker Pro IT FileMaker Pro IT 10 FileMaker Pro 1 15 ESS Oracle 5
Step 1: Oracle DBA 10 Oracle DBA Step 2: DSN DBA FileMaker Server 10 FileMaker Server DSN ODBC DSN DSN Oracle Step 3: FileMaker Pro DSN FileMaker Pro Advanced ESS FileMaker Pro Advanced File Manage External Data Sources... ODBC DSN Oracle FileMaker Pro FileMaker Pro Oracle Step 4: FileMaker Pro 1 FileMaker Pro Oracle Oracle DBA Oracle FileMaker Pro Step 5: 1 15 6
SQL Step 6: FileMaker Pro Oracle FileMaker Pro Oracle Oracle Oracle Oracle 2 FileMaker Pro Oracle Oracle Oracle DBA 2002 DSN DBA DBA 1 FileMaker Pro DBA DSN FileMaker Pro DSN FileMaker Pro DBA FileMaker Pro SQL 7
FileMaker Pro 10 10 30 SQL SQL 3 SQL 1 DBA DBA DSN DSN FileMaker Pro FileMaker Server DSN FileMaker Pro ODBC Mac OS X DSN Mac OS MySQL 5 DSN 1. URL ODBC 2.7 Actual Technologies: http://www.actualtechnologies.com/product_opensourcedatabases.php MySQL Connector ODBC *1 *1 Windows 2. Mac OS X ODBC Administrator /Applications/Utilities *2 System DSN Add *2 Mac OS X v10.6 Snow Leopard Apple 8
(FileMaker Pro ESS System DSN 1 ) 3. Actual Open Source Databases 4. Create a New Data Source to an Open Source Database [Continue] 9
5. MySQL DSN ODBC Administrator System DSN DSN System DSN User DSN DSN System DSN 6. MySQL IP DSN localhost MySQL 7. SQL 10
8. DSN Done ( ODBC ) 11
9. ODBC Administrator DSN Apply ODBC Administrator DSN Windows DSN Windows DSN Mac OS 1. URL MySQL Connector ODBC 3.51.14 http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32 2. Start > Control Panel > Administrative Tools > Data Sources (ODBC) Windows ODBC administration tool System DSN Add 12
3. MySQL ODBC 3.51 4. DSN IP 13
5. OK DSN System DSN FileMaker Pro FileMaker Pro FileMaker Pro 9 10 FileMaker Pro FileMaker Pro 7 8.5 FileMaker Pro Define File References FileMaker Pro 9 10 ODBC FileMaker Pro ODBC Manage External Data Sources FileMaker Pro MySQL DSN 14
1. File > Manage > External Data Sources New 2. ODBC DSN Specify 15
3. DSN DSN DSN DSN OK 4. ODBC 16
FileMaker Pro FileMaker Pro 1. Manage Database Relationships FileMaker Pro customers_mysql 2. customers_mysql SQL MySQL customer 1 17
3. FileMaker Pro 18
ODBC FileMaker Pro FileMaker Pro SQL FileMaker Pro SQL Sync FileMaker Pro Last, First FileMaker Pro FileMaker Pro DBA 19
FileMaker Pro 1. FileMaker Pro customer_additional 2. SQL id_customer 20
3. SQL FileMaker Pro 4. FileMaker Pro FileMaker Pro 21
ESS FileMaker Pro FileMaker Pro FileMaker Pro ESS FileMaker Pro SQL FileMaker Pro FileMaker Pro SQL FileMaker Pro SQL MySQL 65,535 FileMaker Pro 10 MySQL FileMaker Pro FileMaker Pro 65,535 SQL FileMaker Pro SQL FileMaker Pro 22
? FileMaker Pro FileMaker Pro 1 FileMaker Pro ESS ESS FileMaker Pro FileMaker Pro 10 SQL FileMaker Pro FileMaker Pro 10 Records Refresh Window Refresh Window ODBC ODBC Refresh Window ESS FileMaker Pro ESS 2 1 ESS 2 FileMaker Pro FileMaker Pro FileMaker Pro ESS FileMaker Pro ESS SQL ESS SQL DBA 23
ESS FileMaker Pro SQL SQL ESS vs. FileMaker Pro SQL ESS FileMaker FileMaker Pro 3 24
ODBC [Execute SQL] SQL ODBC ODBC Oracle 9i, Oracle 10g, Oracle 11g, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, MySQL 5.0 5.1 Community Edition ODBC ODBC FileMaker Pro ODBC SQL FileMaker Pro SQL SQL FileMaker Pro Execute SQL ESS ODBC FileMaker Pro ODBC ODBC Execute SQL SQL ESS ESS 3 25
ESS ODBC FileMaker Pro Execute SQL FileMaker Pro ODBC ODBC Execute SQL ESS DSN DSN ESS ODBC Execute SQL DSN ESS ESS FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Pro ESS ESS FileMaker Pro ESS FileMaker Pro FileMaker Pro ESS SQL ESS 1 SQL SQL SQL DBA 3 Oracle MySQL MS SQL Server 1 SQL 26
SQL 1000 60 DBA SQL SELECT name_first, name_last, address, city, state, zip FROM customer_master WHERE region= East eastern_address_book FileMaker Pro 1 SQL ESS FileMaker Pro SQL SQL SQL ESS FileMaker Pro FileMaker SQL ESS ESS FileMaker Pro ESS FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Pro ESS FileMaker Pro FileMaker Pro ESS ESS SQL ESS 27
ESS ESS FileMaker Pro ODBC ESS ODBC ODBC ODBC ODBC DSN ODBC ODBC FileMaker Pro SQL FileMaker Pro FileMaker Pro FileMaker Pro FileMaker TechNet ESS ESS ESS TechNet TechNet ESS FileMaker Pro ESS TechNet Web http://www.filemaker.co.jp/technet/ ESS ESS Express Oracle Database Server (9i, 10g, 11g): http://www.oracle.com/database/index.html ( Express ) MySQL Community Edition (5.0 5.1): http://dev.mysql.com/downloads/mysql/5.0.html (MySQL Express : the Community Edition Web GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html) 28
MS SQL Server (2000, 2005, 2008): http://www.microsoft.com/sql/default.mspx Express Web http://www.microsoft.com/sql/editions/express/default.mspx ODBC ESS ODBC Web http://www.filemaker.co.jp/support/technologies/sql.html ESS ESS SQL SQL http://podgoretsky.com/ftp/docs/db/sql%20in%2021%20days/fm/fm.htm Soliant Consulting 8 FileMaker Web FileMaker 5 FileMaker Developer Conference 2003 FileMaker Pro FileMaker Fellowship FileMaker FileMaker Professional Training Foundation Series 3 FileMaker FileMaker Web Macintosh Double Helix SQL Server 29
--- 2009 FileMaker, Inc. All rights reserved. FileMaker FileMaker, Inc. FileMaker FileMaker FileMaker FileMaker FileMaker --- 2009 FileMaker, Inc. All rights reserved. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries, and the file folder logo is a trademark of FileMaker, Inc. All other trademarks are the property of their respective owners. FileMaker makes no warranties, express or implied, with respect to the performance or reliability of any products presented herein that are manufactured by independent vendors. All understandings, agreements, or warranties, if any, take place between the vendors and prospective users. Product specifications and availability subject to change without notice. (Docv2) THIS DOCUMENT IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, AND FILEMAKER DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, OR THE WARRANTY OF NON-INFRINGEMENT. IN NO EVENT SHALL FILEMAKER OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS, PUNITIVE OR SPECIAL DAMAGES, EVEN IF FILEMAKER OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY. FILEMAKER MAY MAKE CHANGES TO THIS DOCUMENT AT ANY TIME WITHOUT NOTICE. THIS DOCUMENT MAY BE OUT OF DATE AND FILEMAKER MAKES NO COMMITMENT TO UPDATE THIS INFORMATION. 30