{"id":1452,"date":"2012-11-06T20:23:09","date_gmt":"2012-11-06T20:23:09","guid":{"rendered":"https:\/\/markus-schall.de\/?p=1452"},"modified":"2025-10-09T08:32:38","modified_gmt":"2025-10-09T08:32:38","slug":"sql-interfaces-from-filemaker-to-store-cms-or-other-databases","status":"publish","type":"post","link":"https:\/\/www.markus-schall.de\/en\/2012\/11\/sql-interfaces-from-filemaker-to-store-cms-or-other-databases\/","title":{"rendered":"SQL interfaces from FileMaker to the store, CMS or other databases"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1455\" title=\"FileMaker Conference: Presentation on interfaces for FileMaker\" src=\"https:\/\/markus-schall.de\/wp-content\/uploads\/fmk-2012_filemaker-schnittstellen.jpg\" alt=\"FileMaker Conference: Presentation on interfaces for FileMaker\" width=\"201\" height=\"150\" srcset=\"https:\/\/www.markus-schall.de\/wp-content\/uploads\/fmk-2012_filemaker-schnittstellen.jpg 201w, https:\/\/www.markus-schall.de\/wp-content\/uploads\/fmk-2012_filemaker-schnittstellen-16x12.jpg 16w\" sizes=\"auto, (max-width: 201px) 100vw, 201px\" \/>At this year's FileMaker conference in Salzburg, I gave a presentation on how to connect a FileMaker database to other systems such as online stores, content management systems like WordPress or Typo3 or other SQL databases. In my presentation, I used a connection from FileMaker to an xt:Commerce or Gambio online store as an example. I will show you a method for easily integrating any external database that can be accessed via ODBC into a FileMaker database. In this way, data from all kinds of third-party systems can be integrated into a FileMaker solution and brought to the PC or Mac desktop and, with FileMaker Go, to the iPad, iPhone or iPod touch.<!--more--><\/p>\n<p>In my workshop, I explain how an online store (e.g. xt:Commerce or Gambio) can be connected to a FileMaker database. I will first show how database tables from online stores that are based on a MySQL database can be transferred together with their content to any FileMaker database with just a few mouse clicks. Based on the data tables transferred to FileMaker, a script-controlled connection to any existing FileMaker database can then be realized. The workshop shows how articles can be exported from FileMaker to an online store at the touch of a button and how orders and customer data can be imported from the online store into the FileMaker database.<\/p>\n<p>With such a solution, the administration of an online store can be greatly simplified and recurring operational processes such as the recording of customer and order data can be automated in FileMaker.<\/p>\n<p><strong>Topic overview:<\/strong><\/p>\n<ul>\n<li>Access to MySQL databases with ODBC<\/li>\n<li>Setting up an ODBC data source under Mac OS X and Windows<\/li>\n<li>Transferring data tables from an online store to FileMaker<\/li>\n<li>Script-controlled connection of the store data to any FileMaker database<\/li>\n<li>Creating and changing data records in a MySQL database from FileMaker<\/li>\n<\/ul>\n<div style=\"margin-bottom: 5px;\"><strong> <a title=\"FMK2012: Interfaces from FileMaker to online store systems from Markus Schall\" href=\"http:\/\/de.slideshare.net\/fmkonferenz\/fmk2012-xtcommerce\" target=\"_blank\" rel=\"noopener\">FMK2012: Interfaces from FileMaker to online store systems from Markus Schall<\/a><\/strong><\/div>\n<div style=\"margin-bottom: 5px;\">from the\u00a0<strong><a href=\"http:\/\/de.slideshare.net\/fmkonferenz\" target=\"_blank\" rel=\"noopener\">FM Conference Association<\/a><\/strong><\/div>\n<div style=\"margin-bottom: 5px;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>At this year's FileMaker conference in Salzburg, I gave a presentation on how to connect a FileMaker database to other systems such as online stores, content management systems like WordPress or Typo3 or other SQL databases. In my presentation, I used a connection from FileMaker to an xt:Commerce or Gambio online store as an example. I show ... <a title=\"SQL interfaces from FileMaker to the store, CMS or other databases\" class=\"read-more\" href=\"https:\/\/www.markus-schall.de\/en\/2012\/11\/sql-interfaces-from-filemaker-to-store-cms-or-other-databases\/\" aria-label=\"Read more about SQL interfaces from FileMaker to the store, CMS or other databases\">Read more<\/a><\/p>","protected":false},"author":1,"featured_media":1428,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":6,"footnotes":""},"categories":[3],"tags":[410],"class_list":["post-1452","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemaker","tag-filemaker"],"_links":{"self":[{"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/posts\/1452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/comments?post=1452"}],"version-history":[{"count":2,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/posts\/1452\/revisions"}],"predecessor-version":[{"id":2714,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/posts\/1452\/revisions\/2714"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/media\/1428"}],"wp:attachment":[{"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/media?parent=1452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/categories?post=1452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markus-schall.de\/en\/wp-json\/wp\/v2\/tags?post=1452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}