If everything works, you will get prompted to enter the username and password to authenticate into the database. Server Data Source is the file name of the FileMaker database (note that any spaces or other characters must be replaced with their percent encoding character). SequeLink Server Host and Port must be what's below. Data Source Name and Description can be whatever you want. A user configured in that database must be able to connect via ODBC/JDBC.įileMaker ODBC/JDBC Configuration screen.Ģ.) Configure the ODBC DSN.
FileMaker will not accept connections from outside of localhost.ġ.) Open the database in FileMaker and turn on ODBC/JDBC sharing (in File > Sharing > ODBC/JDBC Sharing Settings). Note 2 (This is the big one!): Must open the database on the computer that is doing the conversion. Note: Must have installed the ODBC drivers for FileMaker, which are included on the FileMaker database install disk.
Similar to my Paradox DB post, the goal is to convert the FileMaker into SQL Server and then write scripts against SQL Server to ultimately convert and transform the data. This adds additional complexity and headache. However, FileMaker is.how shall I put this.more non-standard than usual.). However, in true Apple fashion, the FileMaker database stores data in a "non-standard" fashion (I say non-standard in quotes because every database has its own flavor on just about everything DB-related. This is something that the Windows world just dominates and does very well (and it's a well-deserved compliment to Microsoft and the Windows world). FileMaker is a subsidiary of Apple, attempting to keep the Mac relevant in the data world.
0 kommentar(er)
