Still we knew that the SQL developer might want to rename some columns, or even release new views to replace the old ones after some weeks this is a real case, not fantasy So we wanted to build a system that would resist a change on the source side. Enter your database User ID and password at the prompt. What script steps are we talking about? You can align the FileMaker fields to the Access fields by dragging the double arrow icon: Submit a new link.

Uploader: Tazilkree
Date Added: 12 January 2011
File Size: 32.41 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 54939
Price: Free* [*Free Regsitration Required]

Some of the important fields I need to update have special characters that require Unicode. A community of Filemaker developers, users and anyone maac wishes to share anything related to FileMaker. The table will be added to the Relationships tab: OK, we solved the performance issue, but while doing so we really took control over the left side of the import order dialog source.

For this example, double click on all the columns of the Employees table. Want to add to the discussion?

Welcome to Reddit, the front page of the internet. Please contact us at support actualtech. Submit a new link.


What is an ODBC driver?

The database will be empty – you may create a few records if you wish. Log in or sign up in seconds. Give your database file a name. As you can see, this techniques opens up a lot of possibilities.

Your sales information is stored in a Microsoft Access database, and you want to import your sale force contact information into your FileMaker database. If applicable, enter your database User name and Password in the Connect dialog box.

Have you never been bothered by inconsistent database structures between a data source and your own application? Performance is a key here, and this excludes ESS immediately.

Mac ODBC: Setting up a FileMaker ESS table

You can just accept the default values for the “Edit Data Source” dialog: If you combine this with the fact that an import script step is able to create a new table, that Execute SQL is able to delete this table DROPthat you can now duplicate a record set without being limited because a table cannot import to itself, etc, etc… the potential is huge!

When you click on a table name, the columns defined for that table will appear on the right column. You can then browse and search data from the ODBC database. Click Add to configure a driver for your data source. Submit a new text post. As you can see on the image, you can combine a source name and some other comments.


Select the table you would like to view and press OK. So we go for ODBC imports, but refinements are to come later. When all records have been imported, FileMaker will display a summary:. FileMaker allows this, but with dramatically poor performance.

Click OK to save your data source information. One can also write: Next, FileMaker will display a dialog box where you can map the fields from the Access database to the fields of the FileMaker database:. A User DSN is available only when you log in.

Here is a short filemaoer of the situation we had to address. For Access databases, just leave the User name and Password fields empty.

One spot seemed nice for this: This technical note will describe the steps involved. I’ll check it out when I get back to work.